Re: Performance of NOT IN and <> with PG 9.0.4

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Performance of NOT IN and <> with PG 9.0.4
Date: 2011-05-24 19:49:06
Message-ID: BANLkTin1TRna9JDL9se+j7ROdaATXSqP+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, May 24, 2011 at 3:32 PM, Jasmin Dizdarevic
<jasmin(dot)dizdarevic(at)gmail(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasmin Dizdarevic 2011-05-24 21:10:34 Re: Performance of NOT IN and <> with PG 9.0.4
Previous Message manuel antonio ochoa 2011-05-24 19:26:17 Re: Problems Pgdump