gt; 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
2356
> NOT IN as I illustrated. The third plan looks to be the same thing plus
> some parallelization frammishes.
>
> I'm not clear on what "small/medium/large" means, in particular not on
> which of these corresponds to the OP's report of 9-second execution.
>
>
The following bug has been logged online:
Bug reference: 3826
Logged by: Alexander Steffens
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3b4
Operating system: Win2003R2x64
Description:Very Slow Execution of examplequery (wrong plan?)
Details:
Hello, I
