Re: Parallel Aggregates for string_agg and array_agg

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Parallel Aggregates for string_agg and array_agg
Дата
Msg-id 20180327002001.nmu6ww6f2mk7wuny@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: Parallel Aggregates for string_agg and array_agg  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
Hi,

On 2018-03-27 13:14:15 +1300, David Rowley wrote:
> I have to say, it really would be a shame to have this concern block
> us from future optimisations in aggregation.

Yea, I think that's an important point. By the dint of Tom's argument
we're never going to be able to provide parallelism for any aggregate
where input order matters.  It's not like users are magically going to
stop depending on it, if they already do. Seems more likely that we'll
grow more users depending on it.

We could theoretically provide differently named aggregates where one
allows parallelism, the other doesn't, without duplicating the backing
code... Not pretty tho.

Greetings,

Andres Freund


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: ppc64le support in 9.3 branch?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Parallel Aggregates for string_agg and array_agg