From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | "Fujii(dot)Yuki(at)df(dot)MitsubishiElectric(dot)co(dot)jp" <Fujii(dot)Yuki(at)df(dot)mitsubishielectric(dot)co(dot)jp>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alexander Pyhalov <a(dot)pyhalov(at)postgrespro(dot)ru>, Stephen Frost <sfrost(at)snowman(dot)net>, "Finnerty, Jim" <jfinnert(at)amazon(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se> |
Subject: | Re: [CAUTION!! freemail] Re: Partial aggregates pushdown |
Date: | 2023-12-11 14:24:25 |
Message-ID: | CA+TgmoZVzXWcxXkdC_Q9MmbUGCjYuD2xbyHxgR_4FdU+aAX3jg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Dec 7, 2023 at 4:12 PM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Second, the patch already has a mechanism to check the remote server
> version to see if it is the same or newer. Here is the version check
> documentation patch:
Right. This feature can certainly be implemented in a
backward-compatible way. I'm not sure that we have as much control
over what does and does not get pushed down as we really want here,
but it's completely possible to do this in a way that doesn't break
other use cases.
> However, functions don't have pre-created records, and internal
> functions don't see to have an SQL-defined structure, but as I remember
> the internal aggregate functions all take the same internal structure,
> so I guess we only need one fixed input and one output that would
> output/input such records. Performance might be an issue, but at this
> point let's just implement this and measure the overhead since there are
> few/any(?) other viable options.
IMHO records will be the easiest approach, but it will be some work to try it.
> Fourth, going with #2 where we do the pushdown using an SQL keyword also
> allows extensions to automatically work, while requiring partial
> aggregate functions for every non-partial aggregate will require work
> for extensions, and potentially lead to more version mismatch issues.
Yeah.
> Finally, I am now concerned that this will not be able to be in PG 17,
> which I was hoping for.
Getting it ready to ship by March seems very difficult. I'm not saying
it couldn't happen, but I think more likely it won't.
--
Robert Haas
EDB: http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2023-12-11 14:31:29 | Re: Make COPY format extendable: Extract COPY TO format implementations |
Previous Message | Alena Rybakina | 2023-12-11 14:05:33 | Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features) |