Parallel Aggregates for string_agg and array_agg
Tomer Praizler <[email protected]> Wed, 13 Mar 2019 22:52:45 +0200
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <CAD=kdR8AS5wYtc+=Bd6v_qMGVQNDEqAMvwL3n0f+1KJLYfY0jA@mail.gmail.com> |
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!