RE: WIP: Aggregation push-down - take2

Hi everyone.

I rebased the following patches which were submitted in [1].
    v17-0001-Introduce-RelInfoList-structure.patch
    v17-0002-Aggregate-push-down-basic-functionality.patch
    v17-0003-Use-also-partial-paths-as-the-input-for-grouped-path.patch

I checked I can apply the rebased patch to commit 2cd2569c72b8920048e35c31c9be30a6170e1410.

I'm going to register the rebased patch in next commitfest.

Sincerely yours,
Yuuki Fujii

[1] https://commitfest.postgresql.org/32/

--
Yuuki Fujii
Information Technology R&D Center Mitsubishi Electric Corporation

> -----Original Message-----
> From: Fujii.Yuki@df.MitsubishiElectric.co.jp
> <Fujii.Yuki@df.MitsubishiElectric.co.jp>
> Sent: Friday, April 15, 2022 4:33 PM
> To: pgsql-hackers@lists.postgresql.org
> Cc: david@pgmasters.net; ah@cybertec.at; tgl@sss.pgh.pa.us; Tomas Vondra
> <tomas.vondra@enterprisedb.com>; zhihui.fan1213@gmail.com;
> legrand_legrand@hotmail.com; daniel@yesql.se
> Subject: [CAUTION!! MELCO?] WIP: Aggregation push-down - take2
>
> Hi everyone.
>
> I develop postgresql's extension such as fdw in my work.
> I'm interested in using postgresql for OLAP.
> After [1] having been withdrawn, I reviewed [1].
> I think that this patch is realy useful when using OLAP queries.
> Furthermore, I think it would be more useful if this patch works on a foreign
> table.
> So, I would like to ask you a question on this patch in this new thread.
>
> I changed this patch a little and confirmed that my idea is true.
> The followings are things I found and differences of between my prototype and
> this patch.
>   1. Things I found
>    I execute a query which contain join of postgres_fdw's foreign table and a
> table and aggregation of the join result.
>    In my setting, my prototype reduce this query's response by 93%.
>   2. Differences between my prototype and this patch
>    (1) Pushdown aggregation of foeign table if FDW pushdown partial
> aggregation
>    (2) postgres_fdw pushdowns some partial aggregations I attached my
> prototype source code and content of my experiment.
> I want to resume development of this patch if there is some possibility of
> accept of this patch's function.
> I took a contact to Mr.Houska on resuming development of this patch.
> As a result, Mr.Houska advised for me that I ask in pgsql-hackers whether any
> reviewers / committers are interested to work on the patch.
> Is anyone interested in my work?
>
> Sincerely yours.
> Yuuki Fujii
>
> [1] https://commitfest.postgresql.org/32/
>
> --
> Yuuki Fujii
> Information Technology R&D Center Mitsubishi Electric Corporation