Re: Adding a ROLLUP switches to GroupAggregate unexpectedly

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Adding a ROLLUP switches to GroupAggregate unexpectedly
Дата
Msg-id 19774.1459450608@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Adding a ROLLUP switches to GroupAggregate unexpectedly  (Chris Cogdon <chris@cogdon.org>)
Ответы Re: Adding a ROLLUP switches to GroupAggregate unexpectedly  ("ktm@rice.edu" <ktm@rice.edu>)
Список pgsql-performance
Chris Cogdon <chris@cogdon.org> writes:
> Hi folks! I’ve a query where adding a rollup to the group by switches to
> GroupAggregate unexpectedly, where the standard GROUP BY uses
> HashAggregate.

The current implementation of rollup doesn't support using hashed
aggregation.  I don't know if that's for lack of round tuits or because
it's actually hard, but it's not the planner's fault.

            regards, tom lane


В списке pgsql-performance по дате отправления:

Предыдущее
От: Chris Cogdon
Дата:
Сообщение: Adding a ROLLUP switches to GroupAggregate unexpectedly
Следующее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: Adding a ROLLUP switches to GroupAggregate unexpectedly