having and union in v7beta
| От | Jose Soares |
|---|---|
| Тема | having and union in v7beta |
| Дата | |
| Msg-id | 38BA829F.C8BA2978@sferacarta.com обсуждение |
| Ответы |
Re: [HACKERS] having and union in v7beta
|
| Список | 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
В списке pgsql-hackers по дате отправления: