Partition-wise aggregation/grouping

Edit
ID 1250
Title Partition-wise aggregation/grouping
Topic Performance
Created 2017-08-23 11:19:21
Last modified 2018-04-10 14:00:55 (6 years, 5 months ago)
Latest email 2018-04-10 14:27:51 (6 years, 5 months ago)
Status
2018-03: Committed
2018-01: Moved to next CF
2017-11: Moved to next CF
2017-09: Moved to next CF
Target version
Authors Jeevan Chalke (jeevan.chalke)
Reviewers Ashutosh Bapat (ashutoshbapat)Become reviewer
Committer Robert Haas (rhaas)
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/1250
git checkout commitfest/cf/1250
Emails
Partition-wise aggregation/grouping
First at 2017-03-21 07:17:20 by Jeevan Chalke <jeevan.chalke at enterprisedb.com>
Latest at 2018-04-10 14:27:51 by Jeevan Chalke <jeevan.chalke at enterprisedb.com>
Latest attachment (0001-Remove-target-from-GroupPathExtraData-instead-fetch-.patch) at 2018-03-29 13:01:01 from Jeevan Chalke <jeevan.chalke at enterprisedb.com>
    Attachment (0001-Remove-target-from-GroupPathExtraData-instead-fetch-.patch) at 2018-03-29 13:01:01 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Remove-target-from-GroupPathExtraData-instead-fetch-.patch) at 2018-03-27 09:13:56 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (fix_pwa_andres_concern.patch) at 2018-03-23 11:31:54 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Teach-postgres_fdw-to-push-aggregates-for-child-rela.patch) at 2018-03-23 11:05:59 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (partition-wise-agg-v23.tar.gz) at 2018-03-22 10:15:56 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (0001-Refactor-partitonwise-aggregate-signalling.patch) at 2018-03-21 21:56:52 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (partition-wise-agg-v22.tar.gz) at 2018-03-21 12:01:28 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (0003-Allow-create_partial_grouping_paths-to-return-NULL.patch) at 2018-03-20 20:34:39 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (partition-wise-agg-v21.tar.gz) at 2018-03-20 14:46:29 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (0003-Don-t-pass-the-grouping-target-around-unnecessarily.patch) at 2018-03-19 17:26:18 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (0003-Don-t-pass-grouping-target-around-unnecessarily.patch) at 2018-03-15 21:49:40 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (partition-wise-agg-v20.tar.gz) at 2018-03-15 13:46:55 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v19.tar.gz) at 2018-03-15 10:08:51 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v18.tar.gz) at 2018-03-14 14:21:16 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v17.tar.gz) at 2018-03-13 14:13:05 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (fix_issues_from_AB_refactoring_changes.patch) at 2018-03-12 14:19:31 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (cgp_split.patch) at 2018-03-12 12:37:07 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (partition-wise-agg-v16.tar.gz) at 2018-03-07 14:37:34 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (pg_cgp_refactor.patch) at 2018-03-07 11:09:45 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0003-Refactor-code-to-add-Gather-Gather-Merge.patch) at 2018-03-06 20:15:41 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (pg_cgp_refactor.patch) at 2018-03-06 11:29:51 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (partition-wise-agg-v15.tar.gz) at 2018-03-05 08:56:41 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v14.tar.gz) at 2018-03-01 10:34:26 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (fix_aggref_in_non-agg_error.patch) at 2018-02-27 09:29:18 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (tpch20.zip) at 2018-02-27 06:32:24 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (use_cheapest_total_path.patch) at 2018-02-26 11:38:30 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (partially-grouped-rel-rmh.patch) at 2018-02-22 21:23:24 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (18_pwa_off.out) at 2018-02-14 06:47:37 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (partitioning.zip) at 2018-02-13 07:07:58 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v13.tar.gz) at 2018-02-08 13:05:54 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partially_grouped_rel.patch) at 2018-02-01 13:59:49 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (partition-wise-agg-v12.tar.gz) at 2018-01-29 08:42:52 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v11.tar.gz) at 2018-01-18 13:55:17 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v10.tar.gz) at 2018-01-11 11:00:48 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v9.tar.gz) at 2018-01-02 07:06:36 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v8.tar.gz) at 2017-11-23 13:08:16 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v7.tar.gz) at 2017-11-15 12:01:03 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (fdw_prefetch.patch) at 2017-11-13 08:41:34 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: No)
    Attachment (partition-wise-agg-v6.tar.gz) at 2017-10-27 11:01:26 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (pg_cost_append_v1.patch) at 2017-10-13 06:36:23 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
    Attachment (partition-wise-agg-v5.tar.gz) at 2017-10-09 12:10:04 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v4.tar.gz) at 2017-09-27 10:12:29 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v3.tar.gz) at 2017-09-18 07:07:46 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v2.tar.gz) at 2017-09-08 12:17:56 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (partition-wise-agg-v1.tar.gz) at 2017-08-23 11:13:04 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: No)
    Attachment (agg_pushdown_partition_wise_v2.diff) at 2017-04-27 11:23:46 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (agg_pushdown_partition_wise.diff) at 2017-04-26 10:28:02 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (pg_partwise_agg_WIP.patch) at 2017-03-21 07:17:20 from Jeevan Chalke <jeevan.chalke at enterprisedb.com> (Patch: Yes)
History
When Who What
2018-04-10 14:00:55 David Steele (dsteele) Closed in commitfest 2018-03 with status: Committed
2018-04-10 14:00:55 David Steele (dsteele) Changed committer to rhaas
2018-04-02 09:48:13 Ashutosh Bapat (ashutoshbapat) New status: Ready for Committer
2018-03-19 08:49:32 Burak Velioglu (velioglub) Removed velioglub from reviewers
2018-03-19 08:49:29 Burak Velioglu (velioglub) Added velioglub as reviewer
2018-02-07 15:42:59 David Steele (dsteele) Closed in commitfest 2018-01 with status: Moved to next CF
2017-11-30 02:15:07 Michael Paquier (michael-kun) Closed in commitfest 2017-11 with status: Moved to next CF
2017-10-09 12:11:56 Jeevan Chalke (jeevan.chalke) New status: Needs review
2017-10-02 09:04:48 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2017-10-02 09:04:40 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2017-09 with status: Moved to next CF
2017-09-20 11:43:22 Jeevan Chalke (jeevan.chalke) New status: Needs review
2017-09-12 13:19:20 Aleksander Alekseev (a.alekseev) New status: Waiting on Author
2017-08-23 11:20:58 Jeevan Chalke (jeevan.chalke) Changed authors to Jeevan Chalke (jeevan.chalke)
2017-08-23 11:20:58 Jeevan Chalke (jeevan.chalke) Changed reviewers to Ashutosh Bapat (ashutoshbapat)
2017-08-23 11:19:22 Jeevan Chalke (jeevan.chalke) Attached mail thread CAM2+6=V64_xhstVHie0Rz=KPEQnLJMZt_e314P0jaT_oJ9MR8A@mail.gmail.com
2017-08-23 11:19:21 Jeevan Chalke (jeevan.chalke) Created patch record
Edit