Declarative partitioning

Edit
Title Declarative partitioning
Topic SQL Commands
Created 2016-04-15 04:38:47
Last modified 2016-12-07 18:23:39 (7 years, 3 months ago)
Latest email 2017-01-30 21:42:10 (7 years, 1 month ago)
Status
2017-01: Committed
2016-11: Moved to next CF
2016-09: Moved to next CF
Target version
Authors Amit Langote (amitlan)
Reviewers Robert Haas (rhaas), jacob bogers (lucifer333), Ashutosh Bapat (ashutoshbapat)Become reviewer
Committer Robert Haas (rhaas)
Links
Emails
Declarative partitioning
First at 2015-08-18 10:30:20 by Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
Latest at 2016-08-10 10:29:11 by Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
Latest attachment (0001-Add-syntax-to-specify-partition-key-v7.patch) at 2016-06-27 10:26:13 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
    Attachment (0001-Add-syntax-to-specify-partition-key-v7.patch) at 2016-06-27 10:26:13 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Add-syntax-to-specify-partition-key-v6.patch) at 2016-06-09 01:50:21 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (pg_dump_adjust.patch) at 2016-06-08 13:22:54 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Add-syntax-to-specify-partition-key-v5.patch) at 2016-05-23 10:05:41 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Add-syntax-to-specify-partition-key-v5.patch) at 2016-05-20 08:37:23 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (20160518_decl_part_opt.patch) at 2016-05-18 15:36:27 from Ildar Musin <i.musin at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Add-syntax-to-specify-partition-key-v4.patch) at 2016-05-11 02:26:23 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Add-syntax-to-specify-partition-key-v3.patch) at 2016-04-21 02:05:38 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Add-syntax-to-specify-partition-key-v2.patch) at 2016-04-20 10:28:40 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Add-syntax-to-specify-partition-key-v1.patch) at 2016-04-15 04:35:42 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (decl-part-20160217-1.tar.gz) at 2016-02-17 02:56:27 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (0001-Add-relkind-RELKIND_PARTITIONED_REL-to-pg_class.h.patch) at 2016-02-15 01:55:57 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (declarative-partitioning-wip-1.patch.tar.gz) at 2015-10-30 10:08:46 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (declarative-partitioning-wip-1.patch) at 2015-08-18 10:30:20 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
Declarative partitioning - another take
First at 2016-08-10 11:09:42 by Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
Latest at 2017-01-30 21:42:10 by Peter Eisentraut <peter.eisentraut at 2ndquadrant.com>
Latest attachment (0001-Avoid-tuple-coversion-in-common-partitioning-cases.patch) at 2017-01-25 01:33:28 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
    Attachment (0001-Avoid-tuple-coversion-in-common-partitioning-cases.patch) at 2017-01-25 01:33:28 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Set-ecxt_scantuple-correctly-for-tuple-routing.patch) at 2017-01-20 02:58:25 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Fix-a-bug-of-insertion-into-an-internal-partition.patch) at 2017-01-19 11:23:55 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Fix-a-bug-of-insertion-into-an-internal-partition.patch) at 2017-01-19 05:15:48 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Set-ecxt_scantuple-correctly-for-tuple-routing.patch) at 2017-01-12 03:53:04 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Fix-reporting-of-violation-in-ExecConstraints-again.patch) at 2017-01-10 11:06:45 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-information_schema-system_views.sql-and-relkind-P.patch) at 2017-01-10 09:17:54 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Fix-some-wrong-thinking-in-check_new_partition_bound.patch) at 2017-01-10 09:07:00 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (catalog_update_partitions.patch) at 2017-01-10 05:44:12 from Keith Fiske <keith at omniti.com> (Patch: Yes)
    Attachment (0001-Set-ecxt_scantuple-correctly-for-tuple-routing.patch) at 2017-01-06 11:23:15 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Set-ecxt_scantuple-correctly-for-tuple-routing.patch) at 2016-12-28 01:41:17 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (no-BulkInsertState-partitioned-table.patch) at 2016-12-27 10:07:50 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (fix-wrong-ecxt_scantuple-crash.patch) at 2016-12-27 09:54:46 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Allocate-partition_tuple_slot-in-respective-nodes.patch) at 2016-12-27 08:59:05 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Allocate-partition_tuple_slot-in-respective-nodes.patch) at 2016-12-26 10:46:41 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Use-correct-tuple-descriptor-before-and-after-routin.patch) at 2016-12-22 08:35:51 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Refactor-tuple-routing-setup-code.patch) at 2016-12-21 10:33:44 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (turn-elog-into-ereport-2.patch) at 2016-12-21 05:20:47 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (turn-elog-into-ereport-2.patch) at 2016-12-21 05:03:13 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (turn-elog-into-ereport-1.patch) at 2016-12-20 04:43:41 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Invalidate-the-parent-s-relcache-after-partition-cre-2.patch) at 2016-12-19 03:00:29 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0002-Change-how-RelationGetPartitionQual-and-related-code.patch) at 2016-12-16 08:42:54 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Invalidate-the-parent-s-relcache-after-partition-cre.patch) at 2016-12-16 08:02:48 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partitioning_inh_flag_v1.diff) at 2016-12-15 15:40:11 from Dmitry Ivanov <d.ivanov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Miscallaneous-code-and-comment-improvements.patch) at 2016-12-13 06:58:59 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (hacky_partitioning_hotfix_v2.diff) at 2016-12-12 17:45:38 from Dmitry Ivanov <d.ivanov at postgrespro.ru> (Patch: Yes)
    Attachment (hacky_partitioning_hotfix.diff) at 2016-12-12 17:14:14 from Dmitry Ivanov <d.ivanov at postgrespro.ru> (Patch: Yes)
    Attachment (misc-code-fixes-1.patch) at 2016-12-12 06:37:17 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partitioned-table-ins-upd-doc-fixes-1.patch) at 2016-12-09 02:31:40 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (misc-comment-doc-fixes.patch) at 2016-12-08 08:57:31 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partkey-flush-fix.patch) at 2016-12-07 16:38:16 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-20.patch) at 2016-12-07 11:42:48 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (partition-fixes-rmh.patch) at 2016-12-07 04:38:03 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-19.patch) at 2016-11-30 10:53:32 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-18.patch) at 2016-11-24 10:34:29 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-17.patch) at 2016-11-22 09:15:38 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-16.patch) at 2016-11-18 10:59:08 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-15.patch) at 2016-11-17 11:27:13 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-14.patch) at 2016-11-15 10:30:17 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-13.patch) at 2016-11-11 10:30:37 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-12.patch) at 2016-11-10 12:40:09 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-11.patch) at 2016-11-09 11:14:27 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (warnings.txt) at 2016-11-07 17:24:59 from Jaime Casanova <jaime.casanova at 2ndquadrant.com> (Patch: No)
    Attachment (failing_test_1.sql) at 2016-11-07 17:15:24 from Jaime Casanova <jaime.casanova at 2ndquadrant.com> (Patch: No)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-10.patch) at 2016-10-28 07:53:54 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-9.patch) at 2016-10-07 09:20:06 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-8.patch) at 2016-10-06 07:14:04 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-7.patch) at 2016-10-04 08:02:54 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-6.patch) at 2016-09-29 12:09:08 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (multi-level-inh-lateral-join-info.patch) at 2016-09-27 11:19:44 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (reparameterize-append-path.patch) at 2016-09-27 08:39:02 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (canonical_partition_indexes.patch) at 2016-09-22 07:32:14 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-5.patch) at 2016-09-15 08:53:31 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-4.patch) at 2016-09-09 08:55:48 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-3.patch) at 2016-09-06 08:07:33 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (fix_server_crash.patch) at 2016-09-06 07:13:39 from Ashutosh Bapat <ashutosh.bapat at enterprisedb.com> (Patch: Yes)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables-2.patch) at 2016-08-26 08:15:45 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (0001-Catalog-and-DDL-for-partitioned-tables.patch) at 2016-08-10 11:09:42 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
History
When Who What
2016-12-07 18:23:39 Robert Haas (rhaas) Closed in commitfest 2017-01 with status: Committed
2016-12-07 18:23:39 Robert Haas (rhaas) Changed committer to rhaas
2016-12-06 08:36:08 zhang lian zhuang (zlianzhuang) Removed zlianzhuang from reviewers
2016-12-06 08:32:37 zhang lian zhuang (zlianzhuang) Added zlianzhuang as reviewer
2016-11-30 09:56:40 Amit Langote (amitlan) Closed in commitfest 2016-11 with status: Moved to next CF
2016-10-04 08:03:55 Amit Langote (amitlan) New status: Needs review
2016-10-03 04:25:59 Michael Paquier (michael-kun) New status: Waiting on Author
2016-10-03 04:25:04 Michael Paquier (michael-kun) Closed in commitfest 2016-09 with status: Moved to next CF
2016-09-29 12:21:43 Amit Langote (amitlan) New status: Needs review
2016-09-28 17:56:40 Robert Haas (rhaas) New status: Waiting on Author
2016-09-26 14:36:28 Robert Haas (rhaas) Added rhaas as reviewer
2016-09-01 11:13:47 Ashutosh Bapat (ashutoshbapat) Added ashutosh_bapat as reviewer
2016-08-10 11:11:17 Amit Langote (amitlan) Attached mail thread ad16e2f5-fc7c-cc2d-333a-88d4aa446f96@lab.ntt.co.jp
2016-05-26 04:02:33 jacob bogers (lucifer333) Added lucifer333 as reviewer
2016-04-15 04:39:02 Amit Langote (amitlan) Changed authors to Amit Langote (amitlan)
2016-04-15 04:38:47 Amit Langote (amitlan) Attached mail thread 55D3093C.5010800@lab.ntt.co.jp
2016-04-15 04:38:47 Amit Langote (amitlan) Created patch record
Edit