| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Mike Winter <mike(dot)winter(at)frontlogic(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: "SELECT IN" Still Broken in 7.4b |
| Date: | 2003-08-20 17:10:35 |
| Message-ID: | 1061399435.40948.15.camel@jester |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Ensure your IN list is unique. You might find better times by through
an indexed temp table.
On Wed, 2003-08-20 at 16:32, Mike Winter wrote:
> I'm sure many on this list are sick of hearing about this problem, but it
> was on the fix list for 7.4, but doesn't appear to have been changed.
>
> You can see one of the many threads on the problem at:
> http://archives.postgresql.org/pgsql-sql/2003-05/msg00352.php
>
> Basically, queries of the form SELECT <rows> FROM <table> WHERE <row> IN
> (<list of values>) take forever for high numbers of rows in the IN clause.
> We've done timing on 7.3 and 7.4b and there is no speed improvement on
> these queries.
>
> Does anyone know what the status of this bug is?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aasmund Midttun Godal | 2003-08-20 17:12:49 | Before/After Trigger User Switching |
| Previous Message | Rod Taylor | 2003-08-20 17:09:46 | Re: "SELECT IN" Still Broken in 7.4b |