IN optimization in 7.2 ????? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject IN optimization in 7.2 ?????
Date
Msg-id 20020218152404.A13100@depesz.pl
Whole thread Raw
Responses Re: IN optimization in 7.2 ?????  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
hi
was there optimization for IN (SELECT ... ) usage in 7.2?
we just got query which runs 7 times as fast with in than with exists !
the query is like select field from table where id in (select ... where
 fieldx in (... IN (...)));

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ...                 [enjoy the silence]
... words are meaningless and forgettable ...             [depeche mode]

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Work Around for Oracle Context Indexes?
Next
From: david blood
Date:
Subject: ...