| From: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
|---|---|
| To: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Gregory Stark <stark(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: possible bug in 8.4 |
| Date: | 2008-12-19 10:50:32 |
| Message-ID: | CCFD1996-3933-4F8B-A3CE-1E9881DEDAA7@pointblue.com.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
and the plan on 8.4:
gj=# 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=3000000 width=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)
This looks like a regression to me, or am I wrong ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-12-19 10:52:42 | Re: Hot standby and b-tree killed items |
| Previous Message | Teodor Sigaev | 2008-12-19 10:26:56 | Re: Review: B-Tree emulation for GIN |