not exists clause

From: "S Golly" <gollykai(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: not exists clause
Date: 2008-01-10 20:15:53
Message-ID: 4a5f56930801101215l5ae2d5bdk2db4f1873e0789ca@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2008-01-10 21:50:30 Re: not exists clause
Previous Message Jared Mauch 2008-01-10 14:34:40 Re: big database performance