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!