Partition-wise join for declarative partitioned tables

Edit
Title Partition-wise join for declarative partitioned tables
Topic Performance
Created 2017-02-10 13:03:54
Last modified 2017-10-10 00:44:29 (6 years, 5 months ago)
Latest email 2020-04-08 10:18:53 (3 years, 11 months ago)
Status
2017-11: Committed
2017-09: Moved to next CF
2017-03: Moved to next CF
Target version
Authors Ashutosh Bapat (ashutoshbapat)
Reviewers Etsuro Fujita (efujita), Amit Langote (amitlan), Antonin Houska (a.houska), Thomas Munro (macdice)Become reviewer
Committer Robert Haas (rhaas)
Links
Emails
Partition-wise join for join between (declaratively) partitioned tables
First at 2016-06-15 07:25:08 by Ashutosh Bapat <ashutosh.bapat at enterprisedb.com>
Latest at 2017-08-10 03:58:40 by Thomas Munro <thomas.munro at enterprisedb.com>
Latest attachment (bitmapset-track-leading-empty-space.patch) at 2017-08-10 03:58:40 from Thomas Munro <thomas.munro at enterprisedb.com>
    Attachment (bitmapset-track-leading-empty-space.patch) at 2017-08-10 03:58:40 from Thomas Munro <thomas.munro at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_patches_v24.tar.gz) at 2017-08-08 08:51:02 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v23.tar.gz) at 2017-07-31 13:07:22 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (q4_idx_orderdate.out) at 2017-07-26 09:28:20 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (part_perf.zip) at 2017-07-25 05:31:04 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (Q21_SE_patch.out) at 2017-07-21 06:12:28 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (part_reg.zip) at 2017-07-19 04:24:12 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v22.tar.gz) at 2017-07-14 07:02:30 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v21.tar.gz) at 2017-07-10 10:27:48 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v20.tar.gz) at 2017-05-22 06:32:26 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v18.zip) at 2017-04-21 14:29:17 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v17.zip) at 2017-04-05 02:50:14 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v17.zip) at 2017-04-04 14:22:01 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v16.zip) at 2017-03-30 05:22:45 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v15.zip) at 2017-03-27 12:36:06 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v14.zip) at 2017-03-24 12:24:36 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (0012-Multi-level-partitioned-table-expansion.patch) at 2017-03-24 10:48:39 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (pg_dp_join_patches_v13.zip) at 2017-03-23 12:48:59 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v12.zip) at 2017-03-22 12:46:40 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (geqo_fix.patch) at 2017-03-22 09:49:57 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_patches_v11.zip) at 2017-03-21 17:10:42 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v9.zip) at 2017-03-21 11:46:00 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (queries.out) at 2017-03-21 11:41:25 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (postgres_fdw_pwj.patch) at 2017-03-21 10:22:13 from Rajkumar Raghuwanshi <rajkumar.raghuwanshi at enterprisedb.com> (Patch: Yes)
    Attachment (pwj_regress_2.out) at 2017-03-20 16:07:29 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v8.zip) at 2017-03-20 13:44:16 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pwj_regress_test.out) at 2017-03-19 04:15:33 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v7.zip) at 2017-03-17 13:15:45 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v6.zip) at 2017-03-17 10:28:18 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v5.zip) at 2017-03-16 11:19:49 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v4.zip) at 2017-03-15 12:55:22 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v3.zip) at 2017-03-14 12:04:38 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (pg_dp_join_patches_v2.zip) at 2017-03-10 10:43:40 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
    Attachment (0001-Free-up-memory-consumed-by-the-paths.patch) at 2017-03-02 04:52:58 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Free-up-memory-consumed-by-the-paths.patch) at 2017-03-01 08:56:29 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Refactor-set_append_rel_pathlist.patch) at 2017-02-10 12:53:20 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Refactor-set_append_rel_pathlist.patch) at 2017-02-10 05:49:09 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Refactor-set_append_rel_pathlist.patch) at 2017-02-09 10:50:26 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_v6.patch) at 2017-01-02 12:32:41 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_v5.patch) at 2016-12-27 05:31:36 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (mem_usage_func_wise_measurement_slabwise.patch) at 2016-12-01 11:02:34 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (memory_context_change.patch) at 2016-11-11 12:50:15 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (free_unused_paths.patch) at 2016-10-28 07:09:54 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_v4.patch) at 2016-10-14 04:37:05 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (partition_join_extra_testcases.patch) at 2016-09-27 07:25:50 from Rajkumar Raghuwanshi <rajkumar.raghuwanshi at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_v3.patch) at 2016-09-22 10:41:27 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_v2.patch) at 2016-09-20 10:56:34 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (pwj_install_fix.patch) at 2016-09-16 12:30:00 from Rajkumar Raghuwanshi <rajkumar.raghuwanshi at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join.patch) at 2016-09-09 09:47:17 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (pg_dp_join_assess_phase.patch) at 2016-07-19 14:11:18 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (partitioned_join.out) at 2016-06-15 07:25:08 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: No)
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
2017-10-10 00:44:29 Robert Haas (rhaas) Closed in commitfest 2017-11 with status: Committed
2017-10-10 00:44:29 Robert Haas (rhaas) Changed committer to rhaas
2017-10-02 12:26:51 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2017-09 with status: Moved to next CF
2017-09-28 21:19:39 Daniel Gustafsson (d_gustafsson) Attached mail thread CAFjFpRdjQvaUEV5DJX3TW6pU5eq54NCkadtxHX2JiJG_GvbrCA@mail.gmail.com
2017-09-04 06:47:57 Etsuro Fujita (efujita) Added efujita as reviewer
2017-09-01 12:37:44 Antonin Houska (a.houska) Changed reviewers to Amit Langote (amitlan), Antonin Houska (a.houska), Thomas Munro (macdice)
2017-07-07 01:08:58 Thomas Munro (macdice) Added macdice as reviewer
2017-04-07 18:10:41 Robert Haas (rhaas) Closed in commitfest 2017-03 with status: Moved to next CF
2017-02-14 07:09:08 Amit Langote (amitlan) Added amitlan as reviewer
2017-02-10 13:04:30 Ashutosh Bapat (ashutoshbapat) Changed authors to Ashutosh Bapat (ashutosh_bapat)
2017-02-10 13:03:54 Ashutosh Bapat (ashutoshbapat) Attached mail thread CAFjFpRfQ8GrQvzp3jA2wnLqrHmaXna-urjm_UY9BqXj=EaDTSA@mail.gmail.com
2017-02-10 13:03:54 Ashutosh Bapat (ashutoshbapat) Created patch record
Edit