Re: strange query behavior - Mailing list pgsql-performance

From Ragnar
Subject Re: strange query behavior
Date
Msg-id 1166037311.6369.123.camel@localhost.localdomain
Whole thread Raw
In response to strange query behavior  ("Tim Jones" <TJones@optio.com>)
List pgsql-performance
On mið, 2006-12-13 at 13:42 -0500, Tim Jones wrote:

>   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?

can you provide us with an EXPLAIN ANALYZE for these 2 cases?

what version pg is this?

does this happen only for a particular single value, or for any values?

I assume you have ANALYZEd the table in question.

gnari



pgsql-performance by date:

Previous
From: "Tim Jones"
Date:
Subject: strange query behavior
Next
From: Tom Lane
Date:
Subject: Re: strange query behavior