| From: | Mike Winter <mike(dot)winter(at)frontlogic(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: "SELECT IN" Still Broken in 7.4b |
| Date: | 2003-08-20 18:51:13 |
| Message-ID: | Pine.LNX.4.33L2.0308201247550.6023-100000@frontlogic.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.
--
_______________________________________________________________________
Front Logic Inc. Tel: 306.653.2725 x14
226 Pacific Ave or 1.800.521.4510 x14
Saskatoon, SK Fax: 306.653.0972
S7K 1N9 Canada Cell: 306.717.2550
http://www.frontlogic.com mike(dot)winter(at)frontlogic(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-08-20 19:24:33 | Re: "SELECT IN" Still Broken in 7.4b |
| Previous Message | Stephan Szabo | 2003-08-20 17:41:09 | Re: "SELECT IN" Still Broken in 7.4b |