Andres Freund <andres@anarazel.de> writes:
> On 2017-06-06 23:32:53 -0400, Peter Eisentraut wrote:
>> I'm not sure how you would parallelize these, since in most uses you
>> want to have a deterministic output order.
> Unless you specify ORDER BY you don't really have that anyway, consider
> hash-aggregation. If you want deterministic order, you really need an
> ORDER BY inside the aggregate.
Hash aggregation does not destroy the property that array_agg/string_agg
will produce results whose components appear in the order that the
subquery emitted them in. It only causes the various aggregate results
in a GROUP BY query to themselves appear in random order.
Now you could argue that the subquery might've gotten parallelized and
emitted its outputs in some random order, so doing the same thing one
level further up changes nothing. But you can't defend this on this
basis that it was historically unpredictable, because it wasn't.
regards, tom lane