Andres Freund <and...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers