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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
