Home > mailing lists

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

From	Craig Ringer
Subject	Re: Performance of NOT IN and <> with PG 9.0.4
Date	May 16, 2011 11:07:05
Msg-id	4DD10533.7050904@postnewspapers.com.au 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 (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
List	pgsql-sql

Tree view

On 05/16/2011 06:05 PM, Jasmin Dizdarevic wrote:
> Hi,
>
> is there a reason why Not IN-performance is so poor in 9.0.4 compared to
> 8.4?

Example queries?

EXPLAIN ANALYZE output?

http://wiki.postgresql.org/wiki/SlowQueryQuestions

--
Craig Ringer

pgsql-sql by date:

From: Jasmin Dizdarevic
Date: 16 May 2011, 10:05:12
Subject: Performance of NOT IN and <> with PG 9.0.4

From: Steve Crawford
Date: 16 May 2011, 15:50:30
Subject: Re: self join

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

Previous

Next