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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Performance of NOT IN and <> with PG 9.0.4
Date: 2011-05-25 14:13:21
Message-ID: 4884.1306332801@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> 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?

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasmin Dizdarevic 2011-05-25 15:23:12 Re: Performance of NOT IN and <> with PG 9.0.4
Previous Message Craig Ringer 2011-05-25 02:07:08 Re: Problems Pgdump