X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id EEC0ED1B8D9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Aug 2003 14:10:36 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 24055-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 20 Aug 2003 14:10:27 -0300 (ADT)
Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106])
	by svr1.postgresql.org (Postfix) with ESMTP id 2F28BD1B9A6
	for <pgsql-sql@postgresql.org>; Wed, 20 Aug 2003 14:10:26 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by mailav.tor1.inquent.com (Postfix) with ESMTP
	id 3C2FF1024D; Wed, 20 Aug 2003 13:02:41 -0400 (EDT)
Received: from [10.0.2.6] (unknown [10.0.2.6])
	by mailav.tor1.inquent.com (Postfix) with ESMTP
	id 4E52B10248; Wed, 20 Aug 2003 13:02:39 -0400 (EDT)
Subject: Re: "SELECT IN" Still Broken in 7.4b
From: Rod Taylor <rbt@rbt.ca>
To: Mike Winter <mike.winter@frontlogic.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <Pine.LNX.4.33L2.0308201002210.6023-100000@frontlogic.com>
References: <Pine.LNX.4.33L2.0308201002210.6023-100000@frontlogic.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-0fEhq5Bicqtx59hgYpmq"
Message-Id: <1061399435.40948.15.camel@jester>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.4 
Date: Wed, 20 Aug 2003 17:10:35 +0000
X-Virus-Scanned: by AMaViS perl-11
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/230
X-Sequence-Number: 14846

--=-0fEhq5Bicqtx59hgYpmq
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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.
>=20
> You can see one of the many threads on the problem at:
> http://archives.postgresql.org/pgsql-sql/2003-05/msg00352.php
>=20
> 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.
>=20
> Does anyone know what the status of this bug is?

--=-0fEhq5Bicqtx59hgYpmq
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/Q6uL6DETLow6vwwRAocRAJ9gHZTEFVZsfnbmZi0mWV1p5L6qbwCfWu3g
IF9YeOE+3HaTsZ6LEzRYlx0=
=hXfF
-----END PGP SIGNATURE-----

--=-0fEhq5Bicqtx59hgYpmq--