Re: Adding a ROLLUP switches to GroupAggregate unexpectedly - Mailing list pgsql-performance

From Tom Lane
Subject Re: Adding a ROLLUP switches to GroupAggregate unexpectedly
Date
Msg-id 19774.1459450608@sss.pgh.pa.us
Whole thread Raw
In response to Adding a ROLLUP switches to GroupAggregate unexpectedly  (Chris Cogdon <chris@cogdon.org>)
Responses Re: Adding a ROLLUP switches to GroupAggregate unexpectedly  ("ktm@rice.edu" <ktm@rice.edu>)
List 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 by date:

Previous
From: Chris Cogdon
Date:
Subject: Adding a ROLLUP switches to GroupAggregate unexpectedly
Next
From: "ktm@rice.edu"
Date:
Subject: Re: Adding a ROLLUP switches to GroupAggregate unexpectedly