DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=ASDs1MP/l23eIVtHb9bscTB+a95lSbWzPpSDwPiJHprz+D3J/Pssv5b7yCs0Etw5L2
	DGhUhi6KmXMqab1+9tXdimmvSwk7mK9aqiJIdIL9LdA/EPyFEiml5RfHvfu+tV0Ote8y
	ucfQ/TfnTZes4hpPeAyy2Ui1uJkWM0FvMR8qM=
MIME-Version: 1.0
In-Reply-To: <BANLkTi=X8CBCF_mx4SEp1Wh3b2Gn6vS_mg@mail.gmail.com>
References: <BANLkTimo9PG9r+pP-wxT=Amk79G_UmtCwg@mail.gmail.com>
	<4DD10533.7050904@postnewspapers.com.au>
	<BANLkTi=GmO5NaTGb80e7LpX8mRcvPyKucg@mail.gmail.com>
	<BANLkTinp_jkY5mpruP8JkTekpDKMkjovyQ@mail.gmail.com>
	<BANLkTim_EvVzTzzbbOhmDQGPMUoc0fNLFA@mail.gmail.com>
	<BANLkTi=X8CBCF_mx4SEp1Wh3b2Gn6vS_mg@mail.gmail.com>
Date: Tue, 24 May 2011 15:49:06 -0400
Message-ID: <BANLkTin1TRna9JDL9se+j7ROdaATXSqP+A@mail.gmail.com>
Subject: Re: Performance of NOT IN and <> with PG 9.0.4
From: Robert Haas <robertmhaas@gmail.com>
To: Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>
Cc: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1

On Tue, May 24, 2011 at 3:32 PM, Jasmin Dizdarevic
<jasmin.dizdarevic@gmail.com> wrote:
> enable_material = off

Is there any chance you can reproduce this with a simpler test case
that doesn't involve quite so many joins?

It looks to me like shutting off enable_material is saving you mostly
by accident here.  There's only one materialize node in the whole
plan.

And just incidentally, do you have any of the other enable_* settings
turned off?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company