|From:||Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>|
|Subject:||Partial aggregates pushdown|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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  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
|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?|