Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 1DFB06328CA for ; Mon, 2 Aug 2010 17:22:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 65048-06 for ; Mon, 2 Aug 2010 20:21:57 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40]) by mail.postgresql.org (Postfix) with ESMTP id 12C306323E8 for ; Mon, 2 Aug 2010 17:21:58 -0300 (ADT) Received: by mail.anarazel.de (Postfix, from userid 108) id 724C5448007; Mon, 2 Aug 2010 22:21:56 +0200 (CEST) Received: from anarazel.de (e178230031.adsl.alicedsl.de [85.178.230.31]) by mail.anarazel.de (Postfix) with ESMTPSA id 43216448005; Mon, 2 Aug 2010 22:21:53 +0200 (CEST) Received: by anarazel.de (Postfix, from userid 1000) id D56C81C00A7; Mon, 2 Aug 2010 22:21:51 +0200 (CEST) Date: Mon, 2 Aug 2010 22:21:51 +0200 From: Andres Freund To: Maciek Sakrejda Cc: pgsql-performance@postgresql.org Subject: Re: Optimizing NOT IN plans / verify rewrite Message-ID: <20100802202151.GB2892@anarazel.de> References: <20100802195257.GA2892@anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/14 X-Sequence-Number: 39857 On Mon, Aug 02, 2010 at 01:06:00PM -0700, Maciek Sakrejda wrote: > All fields involved are declared NOT NULL, but thanks for the heads up. Afair the planner doesnt use that atm. Andres