From: Mike Winter <mike.winter@frontlogic.com>
To: pgsql-sql@postgresql.org
Subject: Re: "SELECT IN" Still Broken in 7.4b
Date: Wed, 20 Aug 2003 12:51:13 -0600 (CST)
Message-ID: <Pine.LNX.4.33L2.0308201247550.6023-100000@frontlogic.com> (raw)
In-Reply-To: <1061399435.40948.15.camel@jester>
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.winter@frontlogic.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike.winter@frontlogic.com
Subject: Re: "SELECT IN" Still Broken in 7.4b
In-Reply-To: <Pine.LNX.4.33L2.0308201247550.6023-100000@frontlogic.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox