Re: "SELECT IN" Still Broken in 7.4b

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-24 21:38:16
Message-ID: 6425.1061761096@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Mike Winter <mike(dot)winter(at)frontlogic(dot)com> writes:
> 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?

Try it in CVS tip ...

regards, tom lane

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-08-25 05:59:59 Re: Joined deletes but one table being a subquery.
Previous Message Tom Lane 2003-08-24 21:37:14 Re: [SQL] "SELECT IN" Still Broken in 7.4b