Skip site navigation (1) Skip section navigation (2)

Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)

From: Alexander Steffens <mail(at)a-st(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3826: Very Slow Execution of examplequery (wrong plan?)
Date: 2009-04-16 12:22:46
Message-ID: af11f8750904160522y3d60792cp770a54f03c203696@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Frank HeikensDate: 2009-04-16 12:48:18
Subject: BUG #4759: RETURNS TABLE not supported in pgAdmin
Previous:From: sergeyDate: 2009-04-16 11:09:10
Subject: BUG #4758: deadlock.c:944

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group