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

"Alexander Steffens" <mail@a-st.de> writes:

> Hello, I have found an Query (with data)
> that need to execute on MS-SQL 2005 < 9sec,
> on Postgresql I will stop it now after more than 30 mins:

> 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
> )

What plan does MS-SQL use to complete this? I wonder whether it's producing
the same answer Postgres is.


--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!