Partial aggregates push down

Edit

ID 4019

Title Partial aggregates push down

Topic Performance

Created 2022-11-22 01:08:20

Last modified 2024-01-27 01:57:29 (9 months, 3 weeks ago)

Latest email 2024-08-23 00:07:18 (2 months, 4 weeks ago)

Status

2024-01: Returned with feedback

2023-11: Moved to next CF

2023-09: Moved to next CF

2023-07: Moved to next CF

2023-03: Moved to next CF

2023-01: Moved to next CF

Target version

Authors Yuki Fujii (fujiiyuki)

Reviewers 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/4019
git checkout commitfest/cf/4019

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)

History

When	Who	What
2024-01-27 01:57:29	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2024-01 with status: Returned with feedback
2023-12-15 23:32:10	Yuki Fujii (fujiiyuki)	Changed targetversion to None
2023-12-04 09:19:55	John Naylor (john.naylor)	Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 09:46:24	Peter Eisentraut (petere)	Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-26 07:35:40	Yuki Fujii (fujiiyuki)	Changed targetversion to 17
2023-08-02 19:32:37	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-09 03:21:55	Greg Stark (stark)	Changed targetversion to None
2023-04-09 02:29:59	Greg Stark (stark)	Closed in commitfest 2023-03 with status: Moved to next CF
2023-01-31 16:16:54	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2023-01 with status: Moved to next CF
2022-11-22 01:14:49	Yuki Fujii (fujiiyuki)	Changed authors to Yuki Fujii (fujiiyuki)
2022-11-22 01:12:17	Yuki Fujii (fujiiyuki)	Changed targetversion to 16
2022-11-22 01:08:21	Yuki Fujii (fujiiyuki)	Attached mail thread cf744a8ee4d47bdabe1da9174d4f3dc9@postgrespro.ru
2022-11-22 01:08:20	Yuki Fujii (fujiiyuki)	Created patch record

Edit