Push aggregation down to base relations and joins

Edit

Title

Topic

Server Features

Created

2017-08-17 15:59:06

Last modified

2020-10-01 04:28:36 (1 minute ago)

Latest email

2020-07-03 10:07:24 (2 months, 4 weeks ago)

Status

2020-11: Needs review

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

Tom Lane (tgl), Ashutosh Bapat (ashutoshbapat), Richard Guo (richardguo), Andy Fan (andyf)Become reviewer

Committer

Links

Emails

WIP: Aggregation push-down: First at 2017-04-04 08:41:57 by Antonin Houska <ah at cybertec.at>
Latest at 2020-07-03 10:07:24 by Laurenz Albe <laurenz.albe at cybertec.at>
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
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