Partial aggregates pushdown

From: Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Partial aggregates pushdown
Date: 2021-10-15 13:15:33
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


One of the issues when we try to use sharding in PostgreSQL is absence
of partial aggregates pushdown.

I see several opportunities to alleviate this issue.
If we look at Citus, it implements aggregate, calculating internal state
of an arbitrary agregate function and exporting it as text. So we could
calculate internal states independently on all data sources and then
finalize it, which allows to compute arbitrary aggregate.

But, as mentioned in [1] thread, for some functions (like
count/max/min/sum) we can just push down them. It seems easy and covers
a lot of cases.
For now there are still issues - for example you can't handle functions
as avg() as we should somehow get its internal state or sum() variants,
which need aggserialfn/aggdeserialfn. Preliminary version is attached.

Is someone else working on the issue? Does suggested approach make


Best regards,
Alexander Pyhalov,
Postgres Professional

Attachment Content-Type Size
0001-Partial-aggregates-push-down.patch text/x-diff 22.0 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Gilles Darold 2021-10-15 13:29:13 Re: [PATCH] Proposal for HIDDEN/INVISIBLE column
Previous Message Robert Haas 2021-10-15 13:08:27 Re: should we allow users with a predefined role to access pg_backend_memory_contexts view and pg_log_backend_memory_contexts function?