Home > mailing lists

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

From	Jasmin Dizdarevic
Subject	Performance of NOT IN and <> with PG 9.0.4
Date	May 16, 2011 10:05:12
Msg-id	BANLkTimo9PG9r+pP-wxT=Amk79G_UmtCwg@mail.gmail.com Whole thread Raw
Responses	Re: Performance of NOT IN and <> with PG 9.0.4 (Craig Ringer <craig@postnewspapers.com.au>)
List	pgsql-sql

Hi,

is there a reason why Not IN-performance is so poor in 9.0.4 compared to 8.4?

Jasmin

From: Harald Fuchs
Date: 15 May 2011, 08:04:56
Subject: Re: self join

From: Craig Ringer
Date: 16 May 2011, 11:07:05
Subject: Re: Performance of NOT IN and <> with PG 9.0.4