not exists clause - Mailing list pgsql-performance

From S Golly
Subject not exists clause
Date
Msg-id 4a5f56930801101215l5ae2d5bdk2db4f1873e0789ca@mail.gmail.com
Whole thread Raw
Responses Re: not exists clause  (Josh Berkus <josh@agliodbs.com>)
Re: not exists clause  (Guy Rouillier <guyr-ml1@burntmail.com>)
List pgsql-performance
I cannot get the "not exists" clause of ANSI SQL to execute correctly.
select t.col11, t.col1... from table1 t where not exists (select 1 from table2 where col2 = t.col1);
table1 has 40M + rows. if that matters.
 
OS is FreeBSD 6.2, postgresql version 8.2.6
 
Is it not supported or a bug ?
thank you for your support.
 
 
 
 
 

pgsql-performance by date:

Previous
From: Jared Mauch
Date:
Subject: Re: big database performance
Next
From: Josh Berkus
Date:
Subject: Re: not exists clause