Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance of NOT IN and <> with PG 9.0.4 - Mailing list pgsql-sql

From Robert Haas
Subject Re: Performance of NOT IN and <> with PG 9.0.4
Date
Msg-id BANLkTin1TRna9JDL9se+j7ROdaATXSqP+A@mail.gmail.com
Whole thread Raw
In response to Performance of NOT IN and <> with PG 9.0.4  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
Responses Re: Performance of NOT IN and <> with PG 9.0.4
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Robert Haas
Date:
Subject: Re: Performance of NOT IN and <> with PG 9.0.4
Next
From: Tom Lane
Date:
Subject: Re: Performance of NOT IN and <> with PG 9.0.4