Parallel Aggregates for string_agg and array_agg

From: Tomer Praizler <tomer(dot)praizler(at)gmail(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Parallel Aggregates for string_agg and array_agg
Date: 2019-03-13 20:52:45
Message-ID: CAD=kdR8AS5wYtc+=Bd6v_qMGVQNDEqAMvwL3n0f+1KJLYfY0jA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hey!

Just wanted to check if there is any magic that can be done to make this
happen.
The closest thing I ran into was this guy patch -
https://www.postgresql.org/message-id/CAKJS1f8LV7AT%3DAAhdYGKtGrGkSkEgO6C_SW2Ztz1sR3encisqw%40mail.gmail.com

I didn't try it, but wanted to check if there is any way to deal with the
need to aggregate on a string, by creating an array while doing a group by?
Should I manipulate my data to be able to do it, maybe by generating an int
out of those strings? Any other idea?

Thanks!

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David Rowley 2019-03-13 23:01:48 Re: Parallel Aggregates for string_agg and array_agg
Previous Message David Raymond 2019-03-13 19:25:55 RE: Elegant way to insert of some value in some tables in short instruction