[SQL] Performance of NOT IN and <> with PG 9.0.4

2011-05-16 Thread Jasmin Dizdarevic 
Hi,

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

Ty
Jasmin

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

2011-05-16 Thread Craig Ringer 

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

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] self join

2011-05-16 Thread Steve Crawford 

On 05/14/2011 07:36 PM, Jasen Betts wrote:


use the "NOT IN" operator with a subquery to retch the disallowed
values
Hmmm, "retch" as a synonym for "output"? I've seen more than one case 
where that is an appropriate description. :)


Cheers,
Steve


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql