Re: NOT IN and NOT EXIST

On 07/04/2014 06:12 AM, Sameer Kumar wrote:
> NOT EXISTS translates to HASH ANTI JOIN and NOT IN translates to NOT
> (HASHED) operation.
>
> Given that the columns used in NOT IN clause (for outer as well as
> inner) are NOT NULL, should not it translate a NOT IN plan similar to
> NOT EXISTS plan?

It will, hopefully in 9.5.

https://commitfest.postgresql.org/action/patch_view?id=1487
--
Vik