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

Re: strange query behavior

From: Ragnar <gnari(at)hive(dot)is>
To: Tim Jones <TJones(at)optio(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: strange query behavior
Date: 2006-12-13 19:15:11
Message-ID: 1166037311.6369.123.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: 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



In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2006-12-13 19:16:32
Subject: Re: strange query behavior
Previous:From: Bucky JordanDate: 2006-12-13 18:49:52
Subject: Re: New to PostgreSQL, performance considerations

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