having and union in v7beta
Jose Soares <jose@sferacarta.com>
From: Jose Soares <jose@sferacarta.com>
To: hackers <pgsql-hackers@postgresql.org>
Date: 2000-02-28T14:13:51Z
Lists: pgsql-hackers
I'm comparing v6.5.2 against v7.0 and I see now:
UPDATEs and INSERTs are faster in v7.0 than v5.6.2 but
SELECTs are slow, specially:
SELECT ... UNION (is 3 / 4 times slow)
and
SELECT...HAVING, this last for example doesn't work.
I'm waiting for hours to have the result of following query:
EXPLAIN select * from comuni where nome in
(select nome from comuni group by nome having 1 < count(nome));
Seq Scan on comuni (cost=0.00..3429753.65 rows=8342 width=84)
SubPlan
-> Aggregate (cost=0.00..822.22 rows=834 width=12)
-> Group (cost=0.00..801.37 rows=8342 width=12)
-> Index Scan using knome on comuni (cost=0.00..780.51
rows=8)
EXPLAIN
--
Jose' Soares
Bologna, Italy Jose@sferacarta.com