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 2025-02-04 15:29:12 (15 hours, 23 minutes ago)

Latest email 2025-02-03 16:40:18 (1 day, 14 hours ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

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 2025-02-03 16:40:18 by Álvaro Herrera <alvherre at alvh.no-ip.org>
Latest attachment (v36-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2025-02-03 15:37:47 from Dmitry Koval <d.koval at postgrespro.ru>
    Attachment (v36-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2025-02-03 15:37:47 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v35-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2025-01-27 23:14:52 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    Attachment (v34-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch) at 2024-12-09 21:01:43 from Dmitry Koval <d.koval at postgrespro.ru> (Patch: Yes)
    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
2025-02-04 15:29:12	Dmitry Koval (d.koval)	Closed in commitfest 2025-01 with status: Moved to next CF
2025-01-28 06:59:19	Dmitry Koval (d.koval)	New status: Needs review
2025-01-27 22:24:16	stephane tachoires (sttachoires)	Posted comment with messageid <173801665634.528.3822988233112757834.pgcf@coridan.postgresql.org>
2025-01-27 22:24:16	stephane tachoires (sttachoires)	New status: Waiting on Author
2024-12-11 05:00:10	Michael Paquier (michael-kun)	Closed in commitfest 2024-11 with status: Moved to next CF
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