Re: strange explain - Mailing list pgsql-hackers

From Tom Lane
Subject Re: strange explain
Date
Msg-id 29686.1021303499@sss.pgh.pa.us
Whole thread Raw
In response to Re: strange explain  ("Rod Taylor" <rbt@zort.ca>)
List pgsql-hackers
"Rod Taylor" <rbt@zort.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


pgsql-hackers by date:

Previous
From: "Rod Taylor"
Date:
Subject: Re: strange explain
Next
From: Stephan Szabo
Date:
Subject: Re: Join of small table with large table