Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY

From:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To:	Amit Langote <amitlangote09(at)gmail(dot)com>
Cc:	Justin Pryzby <pryzby(at)telsasoft(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject:	Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY
Date:	2021-04-27 00:04:21
Message-ID:	20210427000421.GA27977@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-08-03 23:48:54 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎  2020-08-03 23:51:44 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>  2020-08-04 16:56:25 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>  2020-08-04 17:53:17 from Robert Haas <robertmhaas(at)gmail(dot)com>   2020-08-26 23:40:07 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>    2020-08-27 15:46:09 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-08-31 07:00:19 from Hao Wu <hawu(at)vmware(dot)com>      2020-09-02 04:25:16 from Hao Wu <hawu(at)vmware(dot)com>       2020-09-03 09:53:38 from Amit Langote <amitlangote09(at)gmail(dot)com>      2020-09-10 20:54:24 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> 📎       2020-09-11 20:28:49 from Robert Haas <robertmhaas(at)gmail(dot)com>     2020-09-01 18:15:27 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>  2020-09-23 05:39:55 from Amit Langote <amitlangote09(at)gmail(dot)com>   2020-09-23 15:23:21 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>    2020-09-24 03:51:52 from Amit Langote <amitlangote09(at)gmail(dot)com>     2020-10-01 03:50:39 from Michael Paquier <michael(at)paquier(dot)xyz>     2020-10-16 22:13:21 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎      2020-11-03 23:56:06 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎       2020-11-30 15:22:35 from Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>        2020-11-30 15:29:51 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>       2020-12-01 01:30:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com>        2020-12-01 15:25:19 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>         2021-01-08 19:14:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎          2021-01-10 22:15:41 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎           2021-02-26 20:32:36 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎            2021-03-11 16:26:51 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎            2021-03-15 23:04:37 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎             2021-03-17 17:48:43 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎              2021-03-17 18:45:34 from Justin Pryzby <pryzby(at)telsasoft(dot)com>               2021-03-19 13:57:37 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                2021-03-21 17:54:53 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                 2021-03-21 18:01:15 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                  2021-03-21 18:14:20 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                   2021-03-21 18:22:00 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                    2021-03-21 18:29:03 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                     2021-03-21 19:07:12 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                      2021-03-21 19:15:19 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                       2021-03-23 14:18:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                        2021-03-23 14:55:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                         2021-03-23 15:25:23 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                          2021-03-25 15:50:39 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                           2021-03-25 21:03:36 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                            2021-03-31 18:30:12 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                             2021-04-11 21:20:35 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                              2021-04-11 21:23:00 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                               2021-04-13 02:13:34 from Amit Langote <amitlangote09(at)gmail(dot)com>                                2021-04-13 16:10:30 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                 2021-04-20 22:41:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                  2021-04-21 00:46:49 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                   2021-04-21 20:38:55 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                    2021-04-22 09:56:25 from Amit Langote <amitlangote09(at)gmail(dot)com>                                     2021-04-22 19:26:02 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                      2021-04-23 09:33:09 from Amit Langote <amitlangote09(at)gmail(dot)com>                                       2021-04-23 17:12:19 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                        2021-04-23 23:31:44 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                         2021-04-26 12:04:55 from Amit Langote <amitlangote09(at)gmail(dot)com>                                          2021-04-26 12:40:54 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                           2021-04-26 19:44:46 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                            2021-04-27 00:04:21 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                             2021-04-27 07:34:30 from Amit Langote <amitlangote09(at)gmail(dot)com>                                              2021-04-27 14:06:09 from Amit Langote <amitlangote09(at)gmail(dot)com>                                               2021-04-27 15:47:33 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                               2021-04-27 16:32:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                2021-04-27 23:32:11 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                 2021-04-28 14:21:04 from Amit Langote <amitlangote09(at)gmail(dot)com>                                                  2021-04-28 16:11:12 from Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 📎                                                   2021-04-28 19:49:47 from Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                   2021-04-30 13:57:02 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                    2021-05-05 10:58:59 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>                                                     2021-05-06 05:35:34 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                                                      2021-05-06 11:22:56 from Pavel Luzanov <p(dot)luzanov(at)postgrespro(dot)ru>                                                      2021-05-06 20:48:29 from Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                     2021-05-06 17:32:08 from Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                    2021-05-06 17:13:47 from Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                     2021-05-13 04:24:36 from Amit Langote <amitlangote09(at)gmail(dot)com>                                    2021-05-24 09:07:12 from Noah Misch <noah(at)leadboat(dot)com>                                     2021-05-24 11:39:16 from Amit Langote <amitlangote09(at)gmail(dot)com>                                     2021-05-25 19:31:58 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                              2021-04-12 07:42:50 from Amit Langote <amitlangote09(at)gmail(dot)com>                               2021-04-12 12:32:40 from Amit Langote <amitlangote09(at)gmail(dot)com> 📎                  2021-04-10 18:42:26 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                   2021-04-21 22:12:48 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                2021-03-21 18:06:45 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>        2021-03-25 21:08:27 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>  2020-10-15 01:04:24 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>   2020-10-15 01:08:40 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>   2020-10-15 01:09:11 from David Rowley <dgrowleyml(at)gmail(dot)com>    2020-10-15 03:38:23 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>  2020-12-25 08:02:05 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v2-0001-Allow-a-partdesc-omitting-partitions-to-be-cached.patch	text/x-diff	23.6 KB

In response to

• Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY at 2021-04-26 19:44:46 from Alvaro Herrera

Responses

• Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY at 2021-04-27 07:34:30 from Amit Langote

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Chapman Flack	2021-04-27 00:13:19	Do we have a way to dynamically make a callback stub?
Previous Message	Andres Freund	2021-04-26 23:07:17	Re: Performance degradation of REFRESH MATERIALIZED VIEW