"Tim Jones" <TJones(at)optio(dot)com> writes:
> 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.
Please provide EXPLAIN ANALYZE output for both cases.
> Possibly I need to reindex this
> particular index?
More likely you need to ANALYZE the table so that the planner has
up-to-date stats ...
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Tomeh, Husam||Date: 2006-12-13 19:25:00|
|Subject: Re: Optimizing a query|
|Previous:||From: Ragnar||Date: 2006-12-13 19:15:11|
|Subject: Re: strange query behavior|