Re: strange query behavior - Mailing list pgsql-performance

From Tom Lane
Subject Re: strange query behavior
Date
Msg-id 10648.1166037392@sss.pgh.pa.us
Whole thread Raw
In response to strange query behavior  ("Tim Jones" <TJones@optio.com>)
Responses Re: strange query behavior  ("Tim Jones" <TJones@optio.com>)
List pgsql-performance
"Tim Jones" <TJones@optio.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

pgsql-performance by date:

Previous
From: Ragnar
Date:
Subject: Re: strange query behavior
Next
From: James Cloos
Date:
Subject: Optimizing a query