parallel aggregation

From: Alexander Saydakov <saydakov(at)yahooinc(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: parallel aggregation
Date: 2023-04-12 00:34:26
Message-ID: CAA46WsqSxp9wt1ogxMtYAUFmFj_YcGBVirdffJD-c_wxfB+vuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a few questions regarding aggregate functions that would be parallel
safe.
1. do the inputs of combinefunc always go through
serialfunc-deserialfunc or they can come directly from sfunc (worker on the
same machine, perhaps)?
2. can the result of combinefunc ever be fed to sfunc as opposed to other
combiners or finalfunc?

I have in mind a scenario, when a different data structure is used in the
combine stage. For that it would be good if the conversion can happen in
serialfunc-deserialfunc, and the combiner does not even know about the
other structure used for state transition during aggregation. If that is
the case, the only problem remains with the finalfunc. It has to be ready
to receive both types.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2023-04-12 00:35:56 Re: "PANIC: could not open critical system index 2662" - twice
Previous Message Siddharth Jain 2023-04-11 23:31:25 Transaction Rollback errors