Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From:	Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
To:	pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date:	2025-06-03 20:53:13
Message-ID:	4433b492-9e97-4334-96d9-ddaaa5083099@postgrespro.ru
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2022-05-31 09:32:43 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎  2022-05-31 10:30:22 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>   2022-05-31 19:43:16 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎    2022-05-31 20:43:26 from Zhihong Yu <zyu(at)yugabyte(dot)com>     2022-05-31 22:14:25 from Zhihong Yu <zyu(at)yugabyte(dot)com>     2022-06-01 18:58:42 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎      2022-06-01 19:10:22 from Zhihong Yu <zyu(at)yugabyte(dot)com>  2022-05-31 11:02:27 from Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>   2022-05-31 20:22:32 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>  2022-07-13 18:27:44 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎   2022-07-13 19:03:46 from Zhihong Yu <zyu(at)yugabyte(dot)com>    2022-07-13 20:05:44 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎     2022-07-13 20:17:30 from Zhihong Yu <zyu(at)yugabyte(dot)com>      2022-07-13 20:33:45 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎       2022-07-14 08:12:14 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>        2022-07-15 11:00:48 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>         2022-08-29 16:56:47 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎         2022-09-07 17:03:09 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎          2022-09-07 18:43:34 from Justin Pryzby <pryzby(at)telsasoft(dot)com>           2022-09-08 11:35:24 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎            2022-09-08 12:26:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com>             2022-09-08 14:10:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>             2022-09-08 14:26:51 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>             2022-09-19 19:26:28 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎             2022-11-28 22:30:14 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎              2023-03-19 20:45:13 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>               2023-03-28 08:28:05 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                2023-03-28 19:34:33 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                 2023-03-28 20:43:45 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                  2023-03-29 10:13:37 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                   2023-03-29 13:32:36 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                    2023-07-06 16:10:28 from Daniel Gustafsson <daniel(at)yesql(dot)se>                     2023-07-06 18:43:23 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                      2023-07-18 12:51:41 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                       2023-07-19 13:43:47 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                        2023-07-20 11:56:33 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                         2023-11-11 10:26:03 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                       2023-12-04 07:52:06 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                        2024-01-26 12:50:07 from vignesh C <vignesh21(at)gmail(dot)com>                         2024-01-26 14:01:52 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                          2024-01-26 16:36:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                           2024-01-26 17:08:08 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                           2024-01-26 18:36:59 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                            2024-03-08 10:26:17 from "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru>                             2024-03-12 16:45:28 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                              2024-03-19 13:06:41 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                               2024-03-19 14:29:47 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                                2024-03-19 14:43:33 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                 2024-03-26 23:39:04 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                  2024-03-27 20:18:00 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                   2024-03-30 12:40:43 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                    2024-03-31 00:56:50 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                    2024-03-31 02:12:19 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                     2024-04-04 19:17:45 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                      2024-04-05 13:00:44 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                       2024-04-05 19:06:03 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                                       2024-04-06 22:22:51 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                        2024-04-06 22:38:56 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                        2024-04-07 19:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                         2024-04-07 22:15:06 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                          2024-04-08 04:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                           2024-04-08 06:16:54 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                        2024-04-08 10:43:51 from Tender Wang <tndrwang(at)gmail(dot)com> 📎                                         2024-04-08 12:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                          2024-04-08 20:43:21 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                           2024-04-09 23:03:40 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                            2024-04-10 09:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                             2024-04-10 12:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                              2024-04-10 17:22:35 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                               2024-04-11 07:57:12 from Richard Guo <guofenglinux(at)gmail(dot)com>                                                2024-04-11 08:59:10 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                 2024-04-11 12:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                  2024-04-11 13:27:40 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                   2024-04-11 14:21:17 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                   2024-04-11 17:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                    2024-04-12 01:53:43 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                     2024-04-12 02:20:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                      2024-04-12 13:04:23 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                       2024-04-12 17:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                        2024-04-12 19:59:57 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                         2024-04-13 10:04:58 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                          2024-04-15 14:30:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                           2024-04-15 15:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                            2024-04-15 15:38:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                          2024-04-15 15:26:56 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                           2024-04-18 10:35:41 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                            2024-04-18 16:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                             2024-04-18 17:03:21 from Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org> 📎                                                             2024-04-18 17:49:22 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                              2024-04-19 09:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                             2024-04-18 23:26:07 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                              2024-04-19 13:29:44 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                               2024-04-22 10:31:48 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                2024-04-24 20:26:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                 2024-04-26 13:33:33 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                                  2024-04-28 00:59:37 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                                   2024-04-28 11:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                    2024-04-28 11:36:51 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                    2024-04-28 13:42:59 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                                                    2024-04-28 14:09:09 from "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>                                                                 2024-04-28 01:04:54 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                  2024-04-28 13:18:42 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                   2024-04-28 14:54:16 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                              2024-04-29 18:00:01 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                               2024-04-30 00:10:47 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                                2024-04-30 03:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                 2024-04-30 21:14:07 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                                  2024-05-08 19:19:08 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                   2024-05-11 09:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                    2024-05-11 13:19:38 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                                    2024-05-12 14:43:40 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                                     2024-05-13 08:45:57 from Daniel Gustafsson <daniel(at)yesql(dot)se>                                                                      2024-05-13 09:45:49 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                                       2024-05-13 10:37:31 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                            2024-04-18 19:59:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                            2024-04-18 20:51:31 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                      2024-04-19 11:34:46 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                    2024-04-30 20:15:05 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                     2024-05-01 19:51:24 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                      2024-05-03 13:23:14 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                       2024-05-03 13:32:25 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                        2024-05-08 18:00:10 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                         2024-05-08 21:37:46 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                          2024-05-08 21:51:32 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                           2024-05-14 14:49:53 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                            2024-05-17 10:05:01 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                             2024-05-17 11:02:40 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                              2024-05-17 11:33:40 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                               2024-05-24 19:29:39 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                2024-05-24 20:00:00 from Alexander Lakhin <exclusion(at)gmail(dot)com>                                                                 2024-05-25 12:53:11 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                  2024-05-26 03:58:11 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                        2024-05-25 17:53:17 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                         2024-05-26 03:56:33 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                        2024-08-08 17:13:51 from Noah Misch <noah(at)leadboat(dot)com> 📎                                         2024-08-08 22:43:11 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                         2024-08-09 07:18:29 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                          2024-08-10 15:43:59 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                           2024-08-10 15:57:48 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                            2024-08-18 22:24:02 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                             2024-08-21 10:48:45 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                              2024-08-21 11:55:04 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                               2024-08-21 12:06:31 from Pavel Borisov <pashkin(dot)elfe(at)gmail(dot)com>                                                2024-08-21 12:40:44 from Alexander Korotkov <aekorotkov(at)gmail(dot)com> 📎                                                 2024-08-22 16:33:27 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                  2024-08-22 16:43:22 from "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>                                                  2024-08-22 16:43:35 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                   2024-08-22 17:25:07 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                    2024-08-23 00:56:23 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                     2024-08-27 18:24:35 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                      2024-08-28 13:45:36 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                       2024-08-30 08:43:10 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                        2024-12-09 06:36:25 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                         2024-12-09 21:01:43 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                          2025-01-27 22:24:16 from stephane tachoires <stephane(dot)tachoires(at)gmail(dot)com>                                                           2025-01-27 23:14:52 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                            2025-01-31 09:07:17 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                          2025-01-31 09:22:51 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                           2025-02-03 15:37:47 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                            2025-02-03 16:40:18 from Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                            2025-03-17 06:55:16 from vignesh C <vignesh21(at)gmail(dot)com>                                                             2025-03-17 13:36:56 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                             2025-05-12 08:31:04 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                              2025-05-21 00:35:35 from jian he <jian(dot)universality(at)gmail(dot)com>                                                               2025-05-21 12:30:01 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                                2025-05-21 14:54:48 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                 2025-05-21 17:01:06 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                                  2025-05-22 02:59:10 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                   2025-05-22 08:57:43 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                                    2025-06-03 09:58:24 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                             2025-05-19 22:35:45 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                              2025-06-03 10:12:28 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                               2025-06-03 11:06:09 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                               2025-06-03 20:53:13 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                                2025-06-04 10:45:32 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                 2025-06-04 19:44:26 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                                  2025-06-05 01:41:47 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>                                                                   2025-06-05 16:40:12 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎                                                                  2025-06-05 04:22:40 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                   2025-06-05 07:16:34 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                    2025-06-05 12:24:42 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                   2025-06-05 16:41:22 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>                                                                    2025-06-06 02:28:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                                     2025-06-06 07:13:22 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                    2025-01-31 09:19:29 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>  2022-08-11 06:56:37 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎  2022-09-19 19:56:42 from Robert Haas <robertmhaas(at)gmail(dot)com>   2022-09-19 20:42:38 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>    2022-09-20 12:20:52 from Robert Haas <robertmhaas(at)gmail(dot)com>     2024-03-25 10:28:36 from Alexander Korotkov <aekorotkov(at)gmail(dot)com>   2022-10-11 16:21:54 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎    2022-10-11 16:58:01 from Zhihong Yu <zyu(at)yugabyte(dot)com>     2022-10-11 17:15:05 from Zhihong Yu <zyu(at)yugabyte(dot)com>      2022-10-13 08:57:33 from Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru> 📎
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v39-0001-Implement-ALTER-TABLE-.-MERGE-PARTITIONS-.-comma.patch	text/plain	150.6 KB
v39-0002-Implement-ALTER-TABLE-.-SPLIT-PARTITION-.-comman.patch	text/plain	217.0 KB

In response to

• Re: Add SPLIT PARTITION/MERGE PARTITIONS commands at 2025-06-03 10:12:28 from Alexander Korotkov

Responses

• Re: Add SPLIT PARTITION/MERGE PARTITIONS commands at 2025-06-04 10:45:32 from jian he

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2025-06-03 21:04:55	Re: SpinLockAcquire and SpinLockRelease is broken on ARM/ARM64? (Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum)
Previous Message	Thomas Munro	2025-06-03 20:46:31	Re: C11 / VS 2019