Re: Combining Aggregates - Mailing list pgsql-hackers

From David Rowley
Subject Re: Combining Aggregates
Date
Msg-id CAKJS1f9wfPKSYt8CG=T271xbyMZjRzWQBjEixiqRF-oLH_u-Zw@mail.gmail.com
Whole thread Raw
In response to Re: Combining Aggregates  (Heikki Linnakangas <hlinnaka@iki.fi>)
Responses Re: Combining Aggregates  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 27 July 2015 at 04:58, Heikki Linnakangas <hlinnaka@iki.fi> wrote:

This patch seems sane to me, as far as it goes. However, there's no planner or executor code to use the aggregate combining for anything. I'm not a big fan of dead code, I'd really like to see something to use this.

I've attached an updated version of the patch. The main change from last time is that I've added executor support and exposed this to the planner via two new parameters in make_agg().

I've also added EXPLAIN support, this will display "Partial [Hash|Group]Aggregate" for cases where the final function won't be called and displays "Finalize [Hash|Group]Aggregate" when combining states and finalizing aggregates.

This patch is currently intended for foundation work for parallel aggregation.

--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: pg_hba_lookup function to get all matching pg_hba.conf entries
Next
From: David Rowley
Date:
Subject: Re: Parallel Aggregate