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 (2 years, 1 month ago)
Latest email 2019-11-15 09:10:25 (6 days, 6 hours 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 2019-11-15 09:10:25 by Etsuro Fujita <etsuro.fujita at gmail.com>
Latest attachment (v27-0002-Modify-partition_range_bounds_merge.patch) at 2019-11-15 05:20:39 from amul sul <sulamul at gmail.com>
    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