Parallel Aggregation support for aggregate functions that use transitions not implemented for array_agg

From: "Regina Obe" <lr(at)pcorp(dot)us>
To: "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Parallel Aggregation support for aggregate functions that use transitions not implemented for array_agg
Date: 2017-06-06 17:52:45
Message-ID: 000201d2deed$b4c37710$1e4a6530$@pcorp.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.
At a cursory glance, it seems they do not use this.
Examples I see that do support it are the average and standard deviation
functions.

Is there a reason for this or it just wasn't gotten to?

Thanks,
Regina

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-06-06 18:11:06 Re: retry shm attach for windows (WAS: Re: OK, so culicidae is *still* broken)
Previous Message Petr Jelinek 2017-06-06 17:36:13 Re: Get stuck when dropping a subscription during synchronizing table