Add SPLIT PARTITION/MERGE PARTITIONS commands

Edit

3659

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v36, Patch count: 2, First patch: +2901−30, All patches: +7080−42

Topic

SQL Commands

Created

2022-05-31 09:34:38

Last modified

2025-02-04 15:29:12 (2 weeks, 3 days ago)

Latest email

2025-02-03 16:40:18 (2 weeks, 3 days 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

Authors

Dmitry Koval (d.koval)

Reviewers

stephane tachoires (sttachoires)Become reviewer

Committer

Alexander Korotkov (smagen)

Links

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