Re: Parallel Aggregate

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Parallel Aggregate
Дата
Msg-id CAKJS1f8272VRL_JcSXmFxFp8PyV_O3b_O4O0M=eSSYhbU2aHLQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel Aggregate  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Ответы Re: Parallel Aggregate  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Список pgsql-hackers
On 21 December 2015 at 17:23, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:

Attached latest performance report. Parallel aggregate is having some overhead
in case of low selectivity.This can be avoided with the help of cost comparison
between normal and parallel aggregates.


Hi, Thanks for posting an updated patch.

Would you be able to supply a bit more detail on your benchmark? I'm surprised by the slowdown reported with the high selectivity version. It gives me the impression that the benchmark might be producing lots of groups which need to be pushed through the tuple queue to the main process. I think it would be more interesting to see benchmarks with varying number of groups, rather than scan selectivity. Selectivity was important for parallel seqscan, but less so for this, as it's aggregated groups we're sending to main process, not individual tuples.

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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Re: In-core regression tests for replication, cascading, archiving, PITR, etc.
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: Threads in PostgreSQL