Congratulations PostgreSQL-Team for your work! with the current 8.4 B1 Version of PostgreSQL the bad execution time of my example-Query containing a NOT EXISTS changed from "aborted after hours" to just 5 seconds - double as quick as my result with MS-SQL.
That's wonderful! > insert into t1 > select distinct (t1.a + t2.a)*2 > from t1,t2 > where not exists ( > select * from t1 tt where tt.a = (t1.a + t2.a)*2 > ) I assume there is now a hashed ANTI-SEMI-JOIN operator implemented? Thanks Alexander -- Dipl.-Math. Alexander Steffens Dorotheenstr. 16 23564 Lübeck -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
