Re: [E] Re: parallel aggregation

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Alexander Saydakov <saydakov(at)yahooinc(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: [E] Re: parallel aggregation
Date: 2023-04-13 02:39:26
Message-ID: CAApHDvoG-qaTKjGn_EMgzJR3r0sN0T6n2k5sObn1=hrgJ3HQHg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 13 Apr 2023 at 14:31, Alexander Saydakov <saydakov(at)yahooinc(dot)com> wrote:
> 1. I wonder if there is a clean separation between the phases: once partial aggregation is done only combining is done after that (state transition function never receives results of combining).

Currently the transfn won't be called again on a state that has had
the combinefn called on it. I can't think of a future reason that we
might change that. My imagination might be lacking, however.

> 2. Can a combiner output also go through serial-deserial before hitting another combiner or finalizer?

Not currently. However, I *can* think of reasons why that might change
in the future. If we wanted to accept partially aggregated results
from foreign servers and then combine them locally then, if those
foreign servers did parallel aggregation, the foreign server's
combined states would need to be serialised before sending over the
network. It feels like just a matter of time before we grow the
ability to do that. Lots of work has been done on foreign data
wrappers in the past few years. It feels like it has tailed off a bit,
but I wouldn't be surprised if we had the ability to do that in the
next few years.

David

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Howroyd 2023-04-13 03:02:40 Re: Guidance on INSERT RETURNING order
Previous Message Alexander Saydakov 2023-04-13 02:31:37 Re: [E] Re: parallel aggregation