Re: Parallel Aggregate

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Parallel Aggregate
Дата
Msg-id CAKJS1f9WC+9REW3kRAt0BAZ8c9JvtyUeovzOPfYSjo7A0nxdSA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel Aggregate  (Paul Ramsey <pramsey@cleverelephant.ca>)
Ответы Re: Parallel Aggregate  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Haribabu Kommi
Дата:
Сообщение: Re: Parallel Aggregate
Следующее
От: David Rowley
Дата:
Сообщение: Re: Combining Aggregates