Declarative partitioning

Edit
Title Declarative partitioning
Topic SQL Commands
Created 2016-04-15 04:38:47
Last modified 2016-12-07 18:23:39 (5 months, 2 weeks ago)
Latest email 2017-01-30 21:42:10 (3 months, 3 weeks ago)
Status
2017-01: Committed
2016-11: Moved to next CF
2016-09: Moved to next CF
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