Re: Parallel Aggregate - Mailing list pgsql-hackers

From David Rowley
Subject Re: Parallel Aggregate
Date
Msg-id CAKJS1f9WC+9REW3kRAt0BAZ8c9JvtyUeovzOPfYSjo7A0nxdSA@mail.gmail.com
Whole thread Raw
In response to Re: Parallel Aggregate  (Paul Ramsey <pramsey@cleverelephant.ca>)
Responses Re: Parallel Aggregate  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 22 December 2015 at 04:16, Paul Ramsey <pramsey@cleverelephant.ca> wrote:
Shouldn’t parallel aggregate come into play regardless of scan selectivity?

I'd say that the costing should take into account the estimated number of groups.

The more tuples that make it into each group, the more attractive parallel grouping should seem. In the extreme case if there's 1 tuple per group, then it's not going to be of much use to use parallel agg, this would be similar to a scan with 100% selectivity. So perhaps the costings for it can be modeled around a the parallel scan costing, but using the estimated groups instead of the estimated tuples.


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

pgsql-hackers by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: Parallel Aggregate
Next
From: David Rowley
Date:
Subject: Re: Combining Aggregates