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, 5 months ago)
Latest email 2020-04-08 10:18:53 (4 years, 5 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