| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-12-13 19:16:32 | Re: strange query behavior |
| Previous Message | Bucky Jordan | 2006-12-13 18:49:52 | Re: New to PostgreSQL, performance considerations |