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 BANLkTim_EvVzTzzbbOhmDQGPMUoc0fNLFA@mail.gmail.com
Whole thread Raw
In response to Re: Performance of NOT IN and <> with PG 9.0.4  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
List pgsql-sql
Tree view 
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 = 'on'
> 4(!) sec. with set enable_material = 'off'
>
> @Robert Haas: I thought it would be interesting to you, because
> you've committed a patch regarding materialization 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?

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

pgsql-sql by date:

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