Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Performance of NOT IN and <> with PG 9.0.4
Date
Msg-id 4884.1306332801@sss.pgh.pa.us
Whole thread Raw
In response to Re: Performance of NOT IN and <> with PG 9.0.4  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Performance of NOT IN and <> with PG 9.0.4  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
List pgsql-sql
Tree view 
Robert Haas <robertmhaas@gmail.com> writes:
> 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?

I didn't stop to count, but are there enough that join_collapse_limit
or from_collapse_limit could be in play?
        regards, tom lane

pgsql-sql by date:

Previous
From: Robert Haas
Date:
Subject: Re: Performance of NOT IN and <> with PG 9.0.4
Next
From: Rob Sargent
Date:
Subject: Re: extracting location info from string