Skip site navigation (1) Skip section navigation (2)

strange query behavior

From: "Tim Jones" <TJones(at)optio(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: strange query behavior
Date: 2006-12-13 18:42:20
Message-ID: (view raw or whole thread)
Lists: pgsql-performance

  I have a query that uses an IN clause and it seems in perform great
when there is more than two values in it but if there is only one it is
really slow. Also if I change the query to use an = instead of IN in the
case of only one value it is still slow. Possibly I need to reindex this
particular index?


Tim Jones
Healthcare Project Manager
Optio Software, Inc.
(770) 576-3555


pgsql-performance by date

Next:From: Tom LaneDate: 2006-12-13 18:47:16
Subject: Re: Slow update with simple query
Previous:From: RonDate: 2006-12-13 18:03:04
Subject: Re: New to PostgreSQL, performance considerations

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group