Re: NOT IN and NOT EXIST

From: Vik Fearing <vik(dot)fearing(at)dalibo(dot)com>
To: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: PostgreSQL General Discussion Forum <pgsql-general(at)postgresql(dot)org>
Subject: Re: NOT IN and NOT EXIST
Date: 2014-07-05 23:14:54
Message-ID: 53B886EE.7030505@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Kiran 2014-07-06 12:44:47 breakpoints in eclipse using postgresql
Previous Message David Wall 2014-07-05 17:51:23 Re: pg_dump slower than pg_restore