Re: possible bug in 8.4 - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: possible bug in 8.4
Date
Msg-id 87k59xkt5m.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: possible bug in 8.4  (Grzegorz Jaskiewicz <gj@pointblue.com.pl>)
Responses Re: possible bug in 8.4
List pgsql-hackers
Grzegorz Jaskiewicz <gj@pointblue.com.pl> writes:

> all I know, is that the same query will work on 8.3 in reasonably  acceptable
> time frame.
>

Because I see the exact same plan -- in fact with the exact same cost:


Welcome to psql 8.3.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help with psql commands      \g
orterminate with semicolon to execute query      \q to quit
 

postgres=# explain select a.a from a where a not in (select a from b);                              QUERY PLAN
                     
 
-------------------------------------------------------------------------Seq Scan on a  (cost=99035.00..257874197565.00
rows=3000000width=4)  Filter: (NOT (subplan))  SubPlan    ->  Materialize  (cost=99035.00..171493.00 rows=5400000
width=4)         ->  Seq Scan on b  (cost=0.00..75177.00 rows=5400000 width=4)
 
(5 rows)


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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: WAL documentation changes
Next
From: KaiGai Kohei
Date:
Subject: Re: Updates of SE-PostgreSQL 8.4devel patches (r1324)