Partial aggregates push down

Edit

ID 3369

Title Partial aggregates push down

Topic Performance

Created 2021-10-21 10:57:33

Last modified 2022-04-07 21:55:14 (2 years, 7 months ago)

Latest email 2024-08-23 00:07:18 (2 months, 4 weeks 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 CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3369
git checkout commitfest/cf/3369

Emails

Partial aggregates pushdown: First at 2021-10-15 13:15:33 by Alexander Pyhalov <a.pyhalov at postgrespro.ru>
Latest at 2024-08-23 00:07:18 by Tomas Vondra <tomas at vondra.me>
Latest attachment (0002-v2-POC-Partial-aggregate-pushdown-internal-transtype.patch) at 2024-06-30 21:42:19 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp>
    Attachment (0002-v2-POC-Partial-aggregate-pushdown-internal-transtype.patch) at 2024-06-30 21:42:19 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    Attachment (0001-POC-Partial-aggregate-pushdown-notinternal-transtype.patch) at 2024-06-23 08:23:32 from "Fujii.Yuki at df.MitsubishiElectric.co.jp" <Fujii.Yuki at df.MitsubishiElectric.co.jp> (Patch: Yes)
    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