Re: strange explain

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rod Taylor" <rbt(at)zort(dot)ca>
Cc: "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su>, "Pgsql Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: strange explain
Date: 2002-05-13 15:24:59
Message-ID: 29686.1021303499@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Rod Taylor" <rbt(at)zort(dot)ca> writes:
> Is this what the TODO entry 'Make IN / NOT IN have similar performance
> as EXISTS' means?

No. The TODO item is talking about IN with a sub-SELECT, which is not
optimized at all at the moment. IN with a list of scalar values is
converted to ((x = value1) OR (x = value2) OR ...), which we can do
something with.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message C. Maj 2002-05-13 15:49:51 Re: pgaccess - the discussion is over
Previous Message Rod Taylor 2002-05-13 15:17:27 Re: strange explain