Push aggregation down to base relations and joins

Edit
Comment/Review
Change Status
ID 1247
Title Push aggregation down to base relations and joins
Topic Server Features
Created 2017-08-17 15:59:06
Last modified 2021-03-11 10:06:27 (3 years, 8 months ago)
Latest email 2021-03-11 13:34:41 (3 years, 8 months ago)
Status
2021-03: Withdrawn
2021-01: Moved to next CF
2020-11: Moved to next CF
2020-09: Moved to next CF
2020-07: Moved to next CF
2020-03: Moved to next CF
2020-01: Moved to next CF
2019-11: Moved to next CF
2019-09: Moved to next CF
2019-07: Moved to next CF
2019-03: Moved to next CF
2019-01: Moved to next CF
2018-11: Moved to next CF
2018-09: Moved to next CF
2018-07: Moved to next CF
2018-03: Moved to next CF
2018-01: Moved to next CF
2017-11: Moved to next CF
2017-09: Moved to next CF
Target version
Authors Antonin Houska (a.houska)
Reviewers Ashutosh Bapat (ashutoshbapat), Tom Lane (tgl), Richard Guo (richardguo), Andy Fan (andyf)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/1247
git checkout commitfest/cf/1247
Emails
WIP: Aggregation push-down
First at 2017-04-04 08:41:57 by Antonin Houska <ah at cybertec.at>
Latest at 2021-03-11 13:34:41 by David Steele <david at pgmasters.net>
Latest attachment (v17-0001-Introduce-RelInfoList-structure.patch) at 2020-07-03 10:07:24 from Laurenz Albe <laurenz.albe at cybertec.at>
    Attachment (v17-0001-Introduce-RelInfoList-structure.patch) at 2020-07-03 10:07:24 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (v16-0001-Introduce-RelInfoList-structure.patch) at 2020-05-19 08:17:20 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v2-0001-tiny-changes-for-init_grouping_targets.patch) at 2020-04-21 08:37:25 from Andy Fan <zhihui.fan1213 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Introduce-RelInfoList-structure.patch) at 2020-01-16 15:25:50 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (pushdown-agg.ods) at 2020-01-11 01:11:24 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: No)
    Attachment (v14-0001-Introduce-RelInfoList-structure.patch) at 2019-07-17 14:39:52 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v13-0001-Introduce-RelInfoList-structure.patch) at 2019-07-12 08:41:51 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v12-0001-Introduce-RelInfoList-structure.patch) at 2019-07-09 13:47:44 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v11-001-Introduce_RelInfoList.patch) at 2019-02-28 16:02:54 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v10-001-Export_estimate_hashagg_tablesize.patch) at 2019-02-05 09:40:15 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v09-001-Export_estimate_hashagg_tablesize.patch) at 2019-01-15 14:06:18 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (agg_pushdown_v8.tgz) at 2018-08-31 15:05:58 from Antonin Houska <ah at cybertec.at> (Patch: No)
    Attachment (agg_pushdown_v6.diff) at 2018-02-28 16:02:43 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (agg_pushdown_v5.tgz) at 2017-12-22 15:43:57 from Antonin Houska <ah at cybertec.at> (Patch: No)
    Attachment (agg_pushdown_v4.tgz) at 2017-11-03 15:33:45 from Antonin Houska <ah at cybertec.at> (Patch: No)
    Attachment (partial.tgz) at 2017-09-08 12:36:03 from Antonin Houska <ah at cybertec.at> (Patch: No)
    Attachment (agg_pushdown_v3.tgz) at 2017-08-17 15:22:22 from Antonin Houska <ah at cybertec.at> (Patch: No)
    Attachment (agg_pushdown_v2.diff) at 2017-04-28 08:46:09 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (agg_pushdown.diff) at 2017-04-04 08:41:57 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
History
When Who What
2021-03-11 10:06:27 Antonin Houska (a.houska) Closed in commitfest 2021-03 with status: Withdrawn
2021-03-03 16:42:23 David Steele (dsteele) New status: Waiting on Author
2021-02-01 12:43:58 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-01 11:08:49 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-10-01 04:28:36 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-03 09:20:06 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2020-07 with status: Moved to next CF
2020-07-03 10:08:26 Laurenz Albe (laurenz) New status: Needs review
2020-07-02 12:39:22 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2020-04-28 11:27:53 Andy Fan (andyf) Added andyf as reviewer
2020-04-08 15:35:40 David Steele (dsteele) Closed in commitfest 2020-03 with status: Moved to next CF
2020-02-01 12:55:05 Tomas Vondra (fuzzycz) Closed in commitfest 2020-01 with status: Moved to next CF
2019-11-29 06:39:49 Michael Paquier (michael-kun) Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 19:01:34 Álvaro Herrera (alvherre) Closed in commitfest 2019-09 with status: Moved to next CF
2019-08-01 23:53:10 Thomas Munro (macdice) Closed in commitfest 2019-07 with status: Moved to next CF
2019-07-18 01:40:45 Richard Guo (richardguo) Added richardguo as reviewer
2019-04-09 03:35:20 Michael Paquier (michael-kun) Closed in commitfest 2019-03 with status: Moved to next CF
2019-02-28 16:04:56 Antonin Houska (a.houska) New status: Needs review
2019-02-21 20:37:09 Tom Lane (tgl) New status: Waiting on Author
2019-02-05 10:09:48 Antonin Houska (a.houska) New status: Needs review
2019-02-04 06:03:12 Michael Paquier (michael-kun) New status: Waiting on Author
2019-02-04 06:03:08 Michael Paquier (michael-kun) Closed in commitfest 2019-01 with status: Moved to next CF
2019-01-15 14:18:31 Antonin Houska (a.houska) New status: Needs review
2018-11-30 21:54:28 Dmitry Dolgov (erthalion) New status: Waiting on Author
2018-11-30 21:54:16 Dmitry Dolgov (erthalion) Closed in commitfest 2018-11 with status: Moved to next CF
2018-11-30 21:54:12 Dmitry Dolgov (erthalion) New status: Needs review
2018-11-18 21:46:37 Tom Lane (tgl) New status: Waiting on Author
2018-11-18 21:46:31 Tom Lane (tgl) Added tgl as reviewer
2018-10-02 06:26:10 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Moved to next CF
2018-08-10 22:22:09 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-04-10 12:45:43 David Steele (dsteele) Closed in commitfest 2018-03 with status: Moved to next CF
2018-02-07 15:46:33 David Steele (dsteele) Closed in commitfest 2018-01 with status: Moved to next CF
2017-12-22 15:53:04 Antonin Houska (a.houska) New status: Needs review
2017-11-30 04:16:03 Michael Paquier (michael-kun) New status: Waiting on Author
2017-11-30 04:15:32 Michael Paquier (michael-kun) Closed in commitfest 2017-11 with status: Moved to next CF
2017-10-02 12:26:46 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2017-09 with status: Moved to next CF
2017-09-11 11:09:33 Ashutosh Bapat (ashutoshbapat) Added ashutoshbapat as reviewer
2017-08-30 19:31:04 Antonin Houska (a.houska) Changed authors to Antonin Houska (a.houska)
2017-08-17 15:59:06 Antonin Houska (a.houska) Attached mail thread 9666.1491295317@localhost
2017-08-17 15:59:06 Antonin Houska (a.houska) Created patch record
Edit
Comment/Review
Change Status