Re: [HACKERS] Parallel Aggregation support for aggregate functionsthat use transitions not implemented for array_agg

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Parallel Aggregation support for aggregate functionsthat use transitions not implemented for array_agg
Дата
Msg-id f24345e8-4f7a-a4ac-69a9-68700a4872d7@2ndquadrant.com
обсуждение исходный текст
Ответ на [HACKERS] Parallel Aggregation support for aggregate functions that use transitions not implemented for array_agg  ("Regina Obe" <lr@pcorp.us>)
Ответы Re: [HACKERS] Parallel Aggregation support for aggregate functionsthat use transitions not implemented for array_agg  (Andres Freund <andres@anarazel.de>)
Re: [HACKERS] Parallel Aggregation support for aggregate functions that use transitions not implemented for array_agg  ("Regina Obe" <lr@pcorp.us>)
Список pgsql-hackers
On 6/6/17 13:52, Regina Obe wrote:
> It seems CREATE  AGGREGATE was expanded in 9.6 to support parallelization of
> aggregate functions using transitions, with the addition of serialfunc and
> deserialfunc to the aggregate definitions.
> 
> https://www.postgresql.org/docs/10/static/sql-createaggregate.html
> 
> I was looking at the PostgreSQL 10 source code for some example usages of
> this and was hoping that array_agg and string_agg would support the feature.

I'm not sure how you would parallelize these, since in most uses you
want to have a deterministic output order.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Why does logical replication launcher setapplication_name?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Fix tab-completion of ALTER SUBSCRIPTION SETPUBLICATION