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
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 |