From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
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 19:24:33 |
Message-ID: | 3F43CAF1.9050405@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Mike Winter wrote:
> On Wed, 20 Aug 2003, Rod Taylor wrote:
>
>>Ensure your IN list is unique. You might find better times by through
>>an indexed temp table.
>
> That is what I ended up doing, but it's not a very elegant solution.
> MySQL does queries of this type orders of magnitudes faster than Postgres
> on large value lists, although I have no specific algorithmic solutions to
> offer for how to make it faster. I don't believe making the IN lists
> unique has any affect on performance.
>
I have no idea whether it will be better or worse performance, but in
7.4 you could do:
select blah from foo where id = any (ARRAY[list_of_literals]);
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | George McQuade | 2003-08-20 19:31:43 | Table conversion query... |
Previous Message | Mike Winter | 2003-08-20 18:51:13 | Re: "SELECT IN" Still Broken in 7.4b |