Re: Add SPLIT PARTITION/MERGE PARTITIONS commands

From:	Dmitry Koval <d(dot)koval(at)postgrespro(dot)ru>
To:	Pgsql Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: Add SPLIT PARTITION/MERGE PARTITIONS commands
Date:	2024-03-12 16:45:28
Message-ID:	6fac39a4-2652-4781-a383-86b8cafcc2ff@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-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>  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
v25-0001-ALTER-TABLE-MERGE-PARTITIONS-command.patch	text/plain	104.9 KB
v25-0002-ALTER-TABLE-SPLIT-PARTITION-command.patch	text/plain	175.6 KB
v25-0003-Documentation-for-ALTER-TABLE-SPLIT-PARTITION-ME.patch	text/plain	9.2 KB
v25-0004-SPLIT-PARTITION-optimization.patch	text/plain	42.2 KB

In response to

• Re: Add SPLIT PARTITION/MERGE PARTITIONS commands at 2024-03-08 10:26:17 from Andrey M. Borodin

Responses

• Re: Add SPLIT PARTITION/MERGE PARTITIONS commands at 2024-03-19 13:06:41 from stephane tachoires

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Alvaro Herrera	2024-03-12 16:50:48	Re: [EXTERNAL] Re: Add non-blocking version of PQcancel
Previous Message	Bharath Rupireddy	2024-03-12 16:39:48	Re: Introduce XID age and inactive timeout based replication slot invalidation