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
