Add SPLIT PARTITION/MERGE PARTITIONS commands

Edit
ID 3659
Title Add SPLIT PARTITION/MERGE PARTITIONS commands
Topic SQL Commands
Created 2022-05-31 09:34:38
Last modified 2024-09-06 11:46:30 (1 month, 1 week ago)
Latest email 2024-08-30 08:43:10 (1 month, 2 weeks ago)
Status
2024-11: Needs review
2024-03: Moved to next CF
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
Target version 18
Authors Dmitry Koval (d.koval)
Reviewers stephane tachoires (sttachoires)Become reviewer
Committer Alexander Korotkov (smagen)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3659
git checkout commitfest/cf/3659
Emails
Add SPLIT PARTITION/MERGE PARTITIONS commands
First at 2022-05-31 09:32:43 by Dmitry Koval <d.koval at postgrespro.ru>
Latest at 2024-08-30 08:43:10 by Dmitry Koval <d.koval at postgrespro.ru>
Latest attachment (v33-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2024-08-30 08:43:10 from Dmitry Koval <d.koval at postgrespro.ru>
    Attachment (v33-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2024-08-30 08:43:10 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v32-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2024-08-27 18:24:35 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0001-Avoid-repeated-table-name-lookups-in-createPartit.patch) at 2024-08-21 12:40:44 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Avoid-repeated-table-name-lookups-in-createPartit.patch) at 2024-08-21 11:55:04 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Avoid-repeated-table-name-lookups-in-createPartit.patch) at 2024-08-18 22:24:02 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-createPartitionTable-security-issue.patch) at 2024-08-10 15:43:59 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (namespace-check.diff) at 2024-08-09 07:18:29 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (repro-merge-partition-race-v0.patch) at 2024-08-08 17:13:51 from Noah Misch <noah at leadboat.com> (Patch: Yes)
    Attachment (v3-0001-Fix-the-name-collision-detection-in-MERGE-SPLIT-p.patch) at 2024-05-17 11:33:40 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-the-name-collision-detection-in-MERGE-SPLIT-p.patch) at 2024-05-17 10:05:01 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Don-t-copy-extended-statistics-during-MERGE-SPLIT-pa.patch) at 2024-05-14 14:49:53 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v1-0001-Rename-roles-to-avoid-conflicts-in-concurrent-wor.patch) at 2024-05-13 09:45:49 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0003-Fix-for-the-search-of-temporary-partition-for-the.patch) at 2024-05-12 14:43:40 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0002-Don-t-copy-extended-statistics-during-MERGE-SPLIT.patch) at 2024-05-08 18:00:10 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v9_fix.diff) at 2024-04-30 00:10:47 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Document-the-way-partition-MERGE-SPLIT-operations-cr.patch) at 2024-04-28 13:18:42 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v9-0001-Change-the-way-ATExecMergePartitions-handles-the-.patch) at 2024-04-28 00:59:37 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v8-0003-Fix-error-message-in-check_partition_bounds_for_s.patch) at 2024-04-22 10:31:48 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Change-the-way-ATExecMergePartitions-handles-the-.patch) at 2024-04-19 13:29:44 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v6-0005-Fix.patch) at 2024-04-18 23:26:07 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (0001-doc-review-for-ALTER-TABLE-.-SPLIT-MERGE-PARTITION.patch) at 2024-04-18 20:51:31 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (0001-Add-tab-completion-for-ALTER-TABLE-SPLIT-MERGE-PARTI.patch) at 2024-04-18 17:03:21 from Dagfinn Ilmari Mannsåker <ilmari at ilmari.org> (Patch: Yes)
    Attachment (v6-0002-Verify-persistence-of-new-partitions-during-MERGE.patch) at 2024-04-18 10:35:41 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v6_afterfix.diff) at 2024-04-15 15:26:56 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v6-0001-Fix-for-SPLIT-MERGE-partitions-of-temporary-table.patch) at 2024-04-13 10:04:58 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Fix-for-SPLIT-MERGE-partitions-of-temporary-table.patch) at 2024-04-12 19:59:57 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0001-Fix-for-SPLIT-MERGE-partitions-of-temporary-table.patch) at 2024-04-12 13:04:23 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0001-Fix-for-SPLIT-MERGE-partitions-of-temporary-table.patch) at 2024-04-11 13:27:40 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Fix-for-SPLIT-MERGE-partitions-of-temporary-table.patch) at 2024-04-11 08:59:10 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-Fix-for-SPLIT-MERGE-partitions-of-temporary-table.patch) at 2024-04-10 17:22:35 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-Fixes-for-ALTER-TABLE-.-SPLIT-MERGE-PARTITIONS-.-.patch) at 2024-04-08 20:43:21 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Fix-some-grammer-errors-from-error-messages-and-code.patch) at 2024-04-08 10:43:51 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2024-04-05 13:00:44 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v30-0002-Implement-ALTER-TABLE-.-SPLIT-PARTITION-.-comman.patch) at 2024-04-04 19:17:45 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v29-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2024-03-31 02:12:19 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v28-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2024-03-31 00:56:50 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (0001-ALTER-TABLE-MERGE-PARTITIONS-command-v27.patch) at 2024-03-30 12:40:43 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0003-Documentation-for-ALTER-TABLE-SPLIT-PARTITION-ME-v26.patch) at 2024-03-26 23:39:04 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v25-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2024-03-12 16:45:28 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v24-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2024-01-26 18:36:59 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v23-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2024-01-26 17:08:08 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (regression.diffs) at 2024-01-26 16:36:33 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v22-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2024-01-26 14:01:52 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v21-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2023-12-04 07:52:06 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v20-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2023-11-11 10:26:03 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v19-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2023-07-19 13:43:47 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v18-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2023-07-06 18:43:23 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v17-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2023-03-29 13:32:36 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v16-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2023-03-28 20:43:45 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v15-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2023-03-28 08:28:05 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v14-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2022-11-28 22:30:14 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v13-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2022-10-13 08:57:33 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v12-0001-PGPRO-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2022-10-11 16:21:54 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v11-0001-PGPRO-ALTER-TABLE-MERGE-PARTITIONS-command.patch) at 2022-09-19 19:26:28 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v10-0001-partitions-split-merge.patch) at 2022-09-08 11:35:24 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v9-0001-partitions-split-merge.patch) at 2022-09-07 17:03:09 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v8-0001-partitions-split-merge.patch) at 2022-08-29 16:56:47 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v7-0001-partitions-split-merge.patch) at 2022-08-11 06:56:37 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v6-0001-partitions-split-merge.patch) at 2022-07-13 20:33:45 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v5-0001-partitions-split-merge.patch) at 2022-07-13 20:05:44 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0001-partitions-split-merge.patch) at 2022-07-13 18:27:44 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0001-partitions-split-merge.patch) at 2022-06-01 18:58:42 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-partitions-split-merge.patch) at 2022-05-31 19:43:16 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-partitions-split-merge.patch) at 2022-05-31 09:32:43 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
History
When Who What
2024-09-06 11:46:30 Dmitry Koval (d.koval) Closed in commitfest 2024-03 with status: Moved to next CF
2024-09-06 11:46:20 Dmitry Koval (d.koval) New status: Needs review
2024-09-06 11:42:29 Dmitry Koval (d.koval) Changed targetversion to 18
2024-04-06 22:23:18 Alexander Korotkov (smagen) Closed in commitfest 2024-03 with status: Committed
2024-04-06 22:23:11 Alexander Korotkov (smagen) Added smagen as committer
2024-04-05 19:06:03 stephane tachoires (sttachoires) Posted review with messageid <171234396370.1152.4160263899485631803.pgcf@coridan.postgresql.org>
2024-04-05 19:06:03 stephane tachoires (sttachoires) New status: Ready for Committer
2024-03-19 14:29:47 stephane tachoires (sttachoires) Posted review with messageid <171085858750.2046434.12246066729700037354.pgcf@coridan.postgresql.org>
2024-03-19 14:29:47 stephane tachoires (sttachoires) New status: Needs review
2024-03-19 13:06:41 stephane tachoires (sttachoires) Posted review with messageid <171085360143.2046436.7217841141682511557.pgcf@coridan.postgresql.org>
2024-03-19 13:06:41 stephane tachoires (sttachoires) New status: Waiting on Author
2024-02-01 18:06:46 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-29 12:43:33 stephane tachoires (sttachoires) New status: Needs review
2023-12-04 10:10:24 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-01 19:42:09 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-01 07:51:04 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-08-01 07:50:46 Daniel Gustafsson (d_gustafsson) Changed targetversion to 17
2023-07-20 11:56:33 stephane tachoires (sttachoires) Posted review with messageid <168985419302.1131.15826271058071638302.pgcf@coridan.postgresql.org>
2023-07-20 11:56:32 stephane tachoires (sttachoires) New status: Ready for Committer
2023-07-19 23:50:31 Dmitry Koval (d.koval) New status: Needs review
2023-07-18 12:51:41 stephane tachoires (sttachoires) Posted review with messageid <168968470101.1131.7543612669520409284.pgcf@coridan.postgresql.org>
2023-07-18 12:51:40 stephane tachoires (sttachoires) New status: Waiting on Author
2023-07-07 09:09:51 Dmitry Koval (d.koval) New status: Needs review
2023-07-06 16:10:11 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2023-04-09 04:20:08 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-03-29 16:22:45 stephane tachoires (sttachoires) New status: Ready for Committer
2023-03-29 10:13:37 stephane tachoires (sttachoires) Posted review with messageid <168008481713.1140.9911234689670772023.pgcf@coridan.postgresql.org>
2023-03-28 19:34:33 stephane tachoires (sttachoires) Posted comment with messageid <168003207361.1140.15583775619525779340.pgcf@coridan.postgresql.org>
2023-03-28 19:34:33 stephane tachoires (sttachoires) New status: Waiting on Author
2023-03-28 09:20:41 Dmitry Koval (d.koval) New status: Needs review
2023-03-20 12:26:15 stephane tachoires (sttachoires) New status: Waiting on Author
2023-03-19 20:52:29 stephane tachoires (sttachoires) Added sttachoires as reviewer
2023-03-19 20:45:13 stephane tachoires (sttachoires) Posted review with messageid <167925871389.628976.7563819615316504989.pgcf@coridan.postgresql.org>
2023-01-31 16:23:06 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-13 07:46:33 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-12 06:59:40 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-08-01 21:14:03 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-08 22:53:39 Jacob Champion (jchampion) Changed reviewers to
2022-06-03 18:24:44 Ibrar Ahmed (ibrar) Added ibrar as reviewer
2022-05-31 09:35:49 Dmitry Koval (d.koval) Changed authors to Dmitry Koval (d.koval)
2022-05-31 09:35:49 Dmitry Koval (d.koval) Changed targetversion to 16
2022-05-31 09:34:38 Dmitry Koval (d.koval) Attached mail thread c73a1746-0cd0-6bdd-6b23-3ae0b7c0c582@postgrespro.ru
2022-05-31 09:34:38 Dmitry Koval (d.koval) Created patch record
Edit