having and union in v7beta

From: Jose Soares <jose(at)sferacarta(dot)com>
To: hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: having and union in v7beta
Date: 2000-02-28 14:13:51
Message-ID: 38BA829F.C8BA2978@sferacarta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)sferacarta(dot)com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 2000-02-28 14:16:20 Re: [HACKERS] update_pg_pwd trigger does not work very well
Previous Message Karel Zak - Zakkr 2000-02-28 14:03:17 Re: [HACKERS] Cache query implemented