On Thu, Mar 31, 2016 at 10:03 AM, Chris Cogdon wrote:
> Description: Adding a summary row by changing “GROUP BY x” into “GROUP BY
> ROLLUP (x)” should not cause a switch from HashAggregate to GroupAggregate
While this restriction has not been lifted for PostgreSQL 9.6,
external sorting will be mu
On Thu, Mar 31, 2016 at 02:56:48PM -0400, Tom Lane wrote:
> Chris Cogdon 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 suppo
Chris Cogdon 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 rou
