Partial aggregates push down

Edit

Title

Topic

Performance

Created

2021-10-21 10:57:33

Last modified

2022-04-07 21:55:14 (2 years, 5 months ago)

Latest email

2024-08-23 00:07:18 (3 weeks ago)

Status

2022-03: Returned with feedback

2022-01: Moved to next CF

2021-11: Moved to next CF

Target version

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-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