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:content-transfer-encoding;
	b=mBHIP/DMrYZGwIeNMYVLDX6I1RR/EZkZMyV7ykc70qKtAGz/bPPSYtqWcHp+w5kN4N
	A8zyvGwBnFLG+KwXQHBBC3UklKc/wi63rAJ5XF68hPhWLLfbQ4Yr6c1wozG7HUTfQ2X2
	kUwh024vXw62WW1QyrlDV8CrjZi6gbeuytQZY=
MIME-Version: 1.0
In-Reply-To: <BANLkTinp_jkY5mpruP8JkTekpDKMkjovyQ@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>
Date: Tue, 24 May 2011 15:14:23 -0400
Message-ID: <BANLkTim_EvVzTzzbbOhmDQGPMUoc0fNLFA@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: Craig Ringer <craig@postnewspapers.com.au>, pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On Tue, May 24, 2011 at 7:45 AM, Jasmin Dizdarevic
<jasmin.dizdarevic@gmail.com> wrote:
> Hi,
> found the problem.
> 238 sec. with set enable_material =3D 'on'
> 4(!) sec. with set enable_material =3D 'off'
>
> @Robert Haas: I thought it would be interesting to you, because
> you've=A0committed=A0a patch regarding=A0materialization for 9.0. If you =
like to
> investigate this further, I can provide you more details.

Well, it makes me glad I insisted we add enable_material.

But I can't really tell from this output what is happening.  Can we
see the EXPLAIN ANALYZE output on 9.0, with and without
enable_material?

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