Postgres Pro
Downloads
Home   >   mailing lists

Re: "SELECT IN" Still Broken in 7.4b - Mailing list pgsql-sql

From Tom Lane
Subject Re: "SELECT IN" Still Broken in 7.4b
Date
Msg-id 6425.1061761096@sss.pgh.pa.us
Whole thread Raw
In response to "SELECT IN" Still Broken in 7.4b  (Mike Winter <mike.winter@frontlogic.com>)
List pgsql-sql
Tree view 
Mike Winter <mike.winter@frontlogic.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

pgsql-sql by date:

Previous
From: denis@coralindia.com
Date:
Subject: Re: Porting from PL/SQL to PLPGSQL
Next
From: Tomasz Myrta
Date:
Subject: Re: Joined deletes but one table being a subquery.