Partition-wise join for declarative partitioned tables

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/994
git checkout commitfest/cf/994

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)