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 (4 months, 2 weeks ago)
Latest email 2017-10-13 02:29:16 (4 months, 2 weeks ago)
Status
2017-11: Committed
2017-09: Moved to next CF
2017-03: Moved to next CF
Authors Ashutosh Bapat (ashutoshbapat)
Reviewers Etsuro Fujita (efujita), Antonin Houska (a.houska), Amit Langote (amitlan), 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 2017-10-13 02:29:16 by Ashutosh Bapat <ashutosh.bapat at enterprisedb.com>
Latest 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>
    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