Advanced partition matching for partition-wise join

Edit

ID 1553

Title Advanced partition matching for partition-wise join

Topic Server Features

Created 2018-02-27 08:19:01

Last modified 2020-04-08 02:44:49 (4 years, 7 months ago)

Latest email 2020-04-08 10:18:53 (4 years, 7 months ago)

Status

2020-03: Committed

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

Target version 13

Authors Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat)

Reviewers Etsuro Fujita (efujita), Amul Sul (sulamul), Mark Dilger (mark.dilger), Ashutosh Bapat (ashutoshbapat)Become reviewer

Committer Etsuro Fujita (efujita)

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

Emails

advanced partition matching algorithm for partition-wise join: First at 2017-08-21 07:13:16 by Ashutosh Bapat <ashutosh.bapat at enterprisedb.com>
Latest at 2020-04-08 10:18:53 by Ashutosh Bapat <ashutosh.bapat at 2ndquadrant.com>
Latest attachment (fix_warning_in_adv_pwj.patch) at 2020-04-08 10:14:28 from Ashutosh Bapat <ashutosh.bapat at 2ndquadrant.com>
    Attachment (fix_warning_in_adv_pwj.patch) at 2020-04-08 10:14:28 from Ashutosh Bapat <ashutosh.bapat at 2ndquadrant.com> (Patch: Yes)
    Attachment (fix-compiler-warning.patch) at 2020-04-08 10:12:09 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (changes_over_v34.patch) at 2020-04-06 11:45:34 from Ashutosh Bapat <ashutosh.bapat at 2ndquadrant.com> (Patch: Yes)
    Attachment (v34-0001-Allow-partitionwise-joins-in-more-cases.patch) at 2020-04-06 08:28:52 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (0001-Improve-partition-matching-for-partitionwise-join.patch) at 2020-04-03 15:15:36 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (0002-remove-merged-flag.patch) at 2020-04-01 16:51:17 from Ashutosh Bapat <ashutosh.bapat at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-v33.patch) at 2020-03-26 00:17:17 from Tomas Vondra <tomas.vondra at 2ndquadrant.com> (Patch: Yes)
    Attachment (v33-0001-Improve-partition-matching-for-partitionwise-join.patch) at 2020-03-24 18:03:11 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (changes_on_top_of_v32_0001.patch) at 2020-03-03 16:48:40 from Ashutosh Bapat <ashutosh.bapat.oss at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Improve-partition-matching-for-partitionwise-join.patch) at 2020-02-10 11:46:01 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Applying-Etsuro-Fujita-s-patches.patch) at 2020-02-05 12:51:13 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Applying-Etsuro-Fujita-s-patches.patch) at 2020-01-28 04:39:03 from Mark Dilger <mark.dilger at enterprisedb.com> (Patch: Yes)
    Attachment (v30-0001-Improve-partition-matching-for-partitionwise-join.patch) at 2020-01-15 14:41:00 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Improve-partition-matching-for-partitionwise-join.patch) at 2019-12-09 09:38:53 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Improve-partition-matching-for-partitionwise-join.patch) at 2019-11-22 13:08:15 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (v27-0002-Modify-partition_range_bounds_merge.patch) at 2019-11-15 05:20:39 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Improve-partition-matching-for-partitionwise-join.patch) at 2019-11-13 04:16:45 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (0002-Few-more-tests-and-adjustments-v2.patch) at 2019-11-06 06:11:47 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (0001-Improve-partition-matching-for-partitionwise-joins-v.patch) at 2019-11-05 13:14:50 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (Improve-partition-matching-for-partitionwise-joins-v25.patch) at 2019-11-01 10:28:29 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (modify-partbounds-changes-2.patch) at 2019-10-31 09:49:26 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (delta.patch) at 2019-10-25 09:59:03 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (modify-partbounds-changes-1.patch) at 2019-10-16 12:50:17 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (Improve-partition-matching-for-partitionwise-joins-v24.patch) at 2019-09-24 15:59:57 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (Modify-partition-matching-algorithm-1.patch) at 2019-08-28 10:22:04 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (Modify-partition-matching-algorithm-WIP.patch) at 2019-08-16 13:25:10 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (list_parted2.sql) at 2019-07-30 09:00:33 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: No)
    Attachment (Improve-partition-matching-for-partitionwise-joins-v23.patch) at 2019-07-08 11:33:32 from Etsuro Fujita <etsuro.fujita at gmail.com> (Patch: Yes)
    Attachment (0001-Hash-partition-bound-equality-refactoring-v22.patch) at 2019-07-02 04:47:17 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (0002-Partition-wise-join-for-1-1-1-0-0-1-partition-matchi-v21.patch) at 2019-04-24 11:26:06 from amul sul <sulamul at gmail.com> (Patch: No)
    Attachment (0002-Partition-wise-join-for-1-1-1-0-0-1-partition-matchi-v20.patch) at 2019-03-07 14:50:10 from amul sul <sulamul at gmail.com> (Patch: No)
    Attachment (0001-Hash-partition-bound-equality-refactoring-v19.patch) at 2019-03-05 10:14:32 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (0001-Hash-partition-bound-equality-refactoring-v18.patch) at 2019-02-04 05:35:06 from amul sul <sulamul at gmail.com> (Patch: Yes)
    Attachment (0001-Hash-partition-bound-equality-refactoring-v17.patch) at 2019-01-31 11:53:15 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Hash-partition-bound-equality-refactoring-v16.patch) at 2019-01-22 12:38:16 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0002-Targetlist-of-a-child-join-is-produced-by-translating-v15.patch) at 2018-11-26 16:03:57 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0002-Targetlist-of-a-child-join-is-produced-by-translating-v14.patch) at 2018-11-26 12:41:06 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Hash-partition-bound-equality-refactoring-v13.patch) at 2018-11-25 20:04:29 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0001-Hash-partition-bound-equality-refactoring-v12.patch) at 2018-10-25 21:19:09 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (0002-Targetlist-of-a-child-join-is-produced-by-translating-v11.patch) at 2018-09-12 20:14:52 from Dmitry Dolgov <9erthalion6 at gmail.com> (Patch: Yes)
    Attachment (pg_adv_dp_join_patches_v10.tar.gz) at 2018-07-17 09:58:23 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v9.tar.gz) at 2018-05-14 11:14:23 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v8.tar.gz) at 2018-04-03 13:34:45 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v7.tar.gz) at 2018-03-12 05:00:54 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v6.tar.gz) at 2018-02-26 10:03:21 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v5.tar.gz) at 2018-02-16 05:14:32 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v4.tar.gz) at 2018-02-09 05:27:40 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v3.tar.gz) at 2018-02-07 04:51:58 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_adv_dp_join_patches_v2.tar.gz) at 2017-12-03 11:23:36 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (0002-Modify-bound-comparision-functions-to-accept-members.patch) at 2017-10-11 11:08:23 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0011-Modify-bound-comparision-functions-to-accept-members.patch) at 2017-09-05 11:04:18 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (advance_partition_matching_test_v1.patch) at 2017-09-04 12:30:13 from Rajkumar Raghuwanshi <rajkumar.raghuwanshi at enterprisedb.com> (Patch: Yes)
    Attachment (0011-Modify-bound-comparision-functions-to-accept-members.patch) at 2017-09-01 19:12:03 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (advanced_partition_matching_test.patch) at 2017-08-28 07:14:15 from Rajkumar Raghuwanshi <rajkumar.raghuwanshi at enterprisedb.com> (Patch: Yes)
    Attachment (0010-Modify-bound-comparision-functions-to-accept-members.patch) at 2017-08-21 07:13:16 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)

History

When	Who	What
2020-04-08 02:44:49	Etsuro Fujita (efujita)	Closed in commitfest 2020-03 with status: Committed
2020-04-08 02:44:49	Etsuro Fujita (efujita)	Changed committer to efujita
2020-03-24 18:27:04	Etsuro Fujita (efujita)	New status: Needs review
2020-03-10 14:02:46	Ashutosh Bapat (ashutoshbapat)	Added ashutoshbapat as reviewer
2020-03-04 16:05:26	Mark Dilger (mark.dilger)	New status: Waiting on Author
2020-02-01 12:55:09	Tomas Vondra (fuzzycz)	Closed in commitfest 2020-01 with status: Moved to next CF
2020-01-23 22:32:35	Mark Dilger (mark.dilger)	Added mark.dilger as reviewer
2020-01-08 15:55:22	Dmitry Dolgov (erthalion)	Removed erthalion from reviewers
2019-11-29 03:39:44	Etsuro Fujita (efujita)	Closed in commitfest 2019-11 with status: Moved to next CF
2019-09-30 19:01:41	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Moved to next CF
2019-09-24 16:02:50	Etsuro Fujita (efujita)	New status: Needs review
2019-09-06 14:54:30	Álvaro Herrera (alvherre)	New status: Waiting on Author
2019-08-01 10:38:43	Etsuro Fujita (efujita)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-04-06 20:41:14	David Steele (dsteele)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-11 05:50:46	Amul Sul (sulamul)	Added sulamul as reviewer
2019-02-06 20:13:00	Dmitry Dolgov (erthalion)	Changed targetversion to 13
2019-01-31 15:58:32	Álvaro Herrera (alvherre)	Changed authors to Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat)
2019-01-31 11:58:30	Etsuro Fujita (efujita)	Closed in commitfest 2019-01 with status: Moved to next CF
2018-11-30 23:34:44	Dmitry Dolgov (erthalion)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-10-02 06:44:16	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Moved to next CF
2018-09-07 03:41:20	Etsuro Fujita (efujita)	Added efujita as reviewer
2018-08-10 22:24:10	Andrew Dunstan (adunstan)	Closed in commitfest 2018-07 with status: Moved to next CF
2018-04-10 12:58:15	David Steele (dsteele)	Closed in commitfest 2018-03 with status: Moved to next CF
2018-04-03 14:30:46	Dmitry Dolgov (erthalion)	Added erthalion as reviewer
2018-02-27 08:19:11	Ashutosh Bapat (ashutoshbapat)	Changed authors to Ashutosh Bapat (ashutoshbapat)
2018-02-27 08:19:01	Ashutosh Bapat (ashutoshbapat)	Attached mail thread CAFjFpRdjQvaUEV5DJX3TW6pU5eq54NCkadtxHX2JiJG_GvbrCA@mail.gmail.com
2018-02-27 08:19:01	Ashutosh Bapat (ashutoshbapat)	Created patch record

Edit