Re: Optimizing NOT IN plans / verify rewrite

From: Andres Freund <andres(at)anarazel(dot)de>
To: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimizing NOT IN plans / verify rewrite
Date: 2010-08-02 19:52:57
Message-ID: 20100802195257.GA2892@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

On Mon, Aug 02, 2010 at 12:12:51PM -0700, Maciek Sakrejda wrote:
> I'm running PostgreSQL 8.3 and I have a query with a couple of NOT IN
> subqueries:
With 8.3 you will have to use manual antijoins (i.e LEFT JOIN
... WHERE NULL). If you use 8.4 NOT EXISTS() will do that
automatically in many cases (contrary to NOT IN () which has strange
NULL semantics).

Anbdres

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Maciek Sakrejda 2010-08-02 20:06:00 Re: Optimizing NOT IN plans / verify rewrite
Previous Message Kevin Grittner 2010-08-02 19:49:54 Re: Optimizing NOT IN plans / verify rewrite