Re: IN optimization in 7.2 ?????

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: IN optimization in 7.2 ?????
Date: 2002-02-18 15:40:31
Message-ID: 20020218164031.A23194@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Feb 18, 2002 at 09:52:19AM -0500, Bruce Momjian wrote:
> Not that I know of.

strange. what could lead to this results then?
i used to think that IN (SELECT ...) is the slowest possible way at all.

depesz

p.s. of course both select's use indices, and table is vacuumed

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-02-18 15:42:45 Re: IN optimization in 7.2 ?????
Previous Message Bruce Momjian 2002-02-18 15:40:22 Re: Can somebody save my bacon?