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 (10 months, 1 week ago)
Latest email 2024-08-23 00:07:18 (3 months, 2 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