Partial aggregates push down

Edit
Title Partial aggregates push down
Topic Performance
Created 2021-10-21 10:57:33
Last modified 2022-04-07 21:55:14 (2 years, 2 months ago)
Latest email 2024-06-12 08:02:17 (1 week ago)
Status
2022-03: Returned with feedback
2022-01: Moved to next CF
2021-11: Moved to next CF
Target version 15
Authors Alexander Pyhalov (a.pyhalov)
Reviewers Ilya Gladyshev (qoops)Become reviewer
Committer
Links
Emails
Partial aggregates pushdown
First at 2021-10-15 13:15:33 by Alexander Pyhalov <a.pyhalov at postgrespro.ru>
Latest at 2024-06-12 08:02:17 by Jelte Fennema-Nio <postgres at jeltef.nl>
Latest attachment (PGConfDev2024_Presentation_Aggregation_Scaleout_FDW_Sharding_20240531.pdf) at 2024-06-05 00:14:45 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp>
    Attachment (PGConfDev2024_Presentation_Aggregation_Scaleout_FDW_Sharding_20240531.pdf) at 2024-06-05 00:14:45 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: No)
    Attachment (regression.diffs) at 2024-05-28 05:57:39 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-SQL-keyword-v5.patch) at 2024-05-27 21:30:59 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-SQL-keyword-v4.patch) at 2024-03-29 14:46:31 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-SQL-keyword-v3.patch) at 2024-03-26 11:33:21 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-SQL-keyword-v2.patch) at 2024-03-16 02:28:50 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-SQL-keyword.patch) at 2024-02-22 07:20:45 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v34.patch) at 2023-11-13 08:25:48 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v33.patch) at 2023-11-13 05:48:47 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v32.patch) at 2023-10-27 05:32:48 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (fdw_partial.diff.gz) at 2023-10-26 19:43:29 from Bruce Momjian <bruce at momjian.us> (Patch: No)
    Attachment (0001-Partial-aggregates-push-down-v31.patch) at 2023-10-26 11:11:09 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v30.patch) at 2023-10-18 05:22:34 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v29.patch) at 2023-09-28 07:21:10 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v28.patch) at 2023-09-28 04:40:40 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v27.patch) at 2023-09-26 22:35:28 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v26.patch) at 2023-09-26 06:26:25 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v25.patch) at 2023-09-25 03:18:13 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (check.patch) at 2023-07-20 10:23:44 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v24.patch) at 2023-07-19 00:43:38 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-For-partial-aggregation-we-can-t-rely-on-the-fact-th.diff) at 2023-07-14 13:40:16 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v23.patch) at 2023-07-10 07:35:27 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v22.patch) at 2023-06-09 11:38:37 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v21.patch) at 2023-06-07 23:08:54 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v20.patch) at 2023-06-06 12:31:20 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v19.patch) at 2023-06-06 03:08:50 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v18.patch) at 2023-06-02 03:54:06 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (aggpush.diff) at 2023-04-07 01:59:39 from Bruce Momjian <bruce at momjian.us> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v17.patch) at 2023-03-30 23:41:21 from Bruce Momjian <bruce at momjian.us> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v17.patch) at 2022-12-15 22:23:05 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v16.patch) at 2022-12-05 02:03:49 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (1.patch) at 2022-12-01 16:36:12 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v15.patch) at 2022-12-01 02:23:28 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v14.patch) at 2022-11-30 10:01:41 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v13.patch) at 2022-11-30 03:10:22 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v12.patch) at 2022-11-22 09:11:13 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v11.patch) at 2022-11-22 01:01:55 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v10.patch) at 2022-03-22 16:15:10 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v09.patch) at 2022-01-17 12:27:53 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v08.patch) at 2022-01-17 07:46:55 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v07.patch) at 2021-11-15 13:01:51 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v06.patch) at 2021-11-03 14:50:19 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v05.patch) at 2021-11-02 09:12:07 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v03.patch) at 2021-10-21 10:55:04 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down-v02.patch) at 2021-10-19 06:56:45 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Partial-aggregates-push-down.patch) at 2021-10-15 13:15:33 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
Re: Partial aggregates pushdown
First at 2021-10-21 21:43:38 by Zhihong Yu <zyu at yugabyte.com>
Latest at 2021-10-22 06:26:50 by Alexander Pyhalov <a.pyhalov at postgrespro.ru>
Latest attachment (0001-Partial-aggregates-push-down-v04.patch) at 2021-10-22 06:26:50 from Alexander Pyhalov <a.pyhalov at postgrespro.ru>
    Attachment (0001-Partial-aggregates-push-down-v04.patch) at 2021-10-22 06:26:50 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
History
When Who What
2022-04-07 21:55:14 Greg Stark (stark) Closed in commitfest 2022-03 with status: Returned with feedback
2022-03-22 00:49:38 Andres Freund (andresfreund) New status: Waiting on Author
2022-02-02 16:33:47 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-25 18:31:41 Justin Pryzby (justinpryzby) New status: Needs review
2022-01-14 12:17:09 Julien Rouhaud (rjuju) New status: Waiting on Author
2021-12-03 07:33:24 Michael Paquier (michael-kun) Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-15 13:07:04 Daniel Gustafsson (d_gustafsson) New status: Needs review
2021-11-03 13:45:47 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2021-11-01 21:09:42 Ilya Gladyshev (qoops) Added qoops as reviewer
2021-10-22 06:45:58 Alexander Pyhalov (a.pyhalov) Attached mail thread CALNJ-vTQ-kUz0OE7ZBoo-C7sviUv4Sp8HGR0s9wKi8EoW5ZxKQ@mail.gmail.com
2021-10-21 10:57:55 Alexander Pyhalov (a.pyhalov) Changed authors to Alexander Pyhalov (a.pyhalov)
2021-10-21 10:57:55 Alexander Pyhalov (a.pyhalov) Changed targetversion to 15
2021-10-21 10:57:33 Alexander Pyhalov (a.pyhalov) Attached mail thread cf744a8ee4d47bdabe1da9174d4f3dc9@postgrespro.ru
2021-10-21 10:57:33 Alexander Pyhalov (a.pyhalov) Created patch record
Edit