Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly

From:	Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc:	Michael Paquier <michael(at)paquier(dot)xyz>, Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>, Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>, Steve Singer <steve(at)ssinger(dot)info>, pgsql-hackers(at)lists(dot)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Jose Luis Tallon <jltallon(at)adv-solutions(dot)net>
Subject:	Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly
Date:	2020-12-24 00:14:18
Message-ID:	20201224001418.GA13286@alvherre.pgsql
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2018-12-24 11:08:43 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎  2018-12-26 18:09:39 from Robert Haas <robertmhaas(at)gmail(dot)com>   2018-12-26 18:19:06 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>    2018-12-27 01:57:10 from Michael Paquier <michael(at)paquier(dot)xyz>    2018-12-27 12:06:54 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>     2018-12-27 13:24:17 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>      2018-12-28 08:31:44 from Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>       2019-06-07 18:27:58 from Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>        2019-08-31 20:54:18 from a(dot)kondratov(at)postgrespro(dot)ru 📎         2019-09-17 11:04:37 from Surafel Temesgen <surafel3000(at)gmail(dot)com>          2019-09-18 12:46:20 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎           2019-09-19 04:43:00 from Michael Paquier <michael(at)paquier(dot)xyz>            2019-09-19 11:44:34 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>            2019-09-19 13:21:23 from Robert Haas <robertmhaas(at)gmail(dot)com>             2019-09-19 14:40:41 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>              2019-09-20 02:06:34 from Michael Paquier <michael(at)paquier(dot)xyz>               2019-09-20 08:26:21 from Jose Luis Tallon <jltallon(at)adv-solutions(dot)net>             2019-09-20 16:38:08 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>              2019-09-24 13:02:39 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎               2019-11-17 00:53:27 from Steve Singer <steve(at)ssinger(dot)info>                2019-11-20 18:16:48 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                 2019-11-24 01:10:51 from Steve Singer <steve(at)ssinger(dot)info>                 2019-11-26 22:09:55 from Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>                  2019-11-27 03:54:16 from Michael Paquier <michael(at)paquier(dot)xyz>                   2019-11-27 04:05:07 from Michael Paquier <michael(at)paquier(dot)xyz>                   2019-11-27 04:28:50 from Michael Paquier <michael(at)paquier(dot)xyz>                   2019-11-27 17:47:06 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                    2019-12-02 08:21:34 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                     2019-12-02 09:41:03 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                     2020-01-04 18:38:24 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                      2020-01-07 08:05:11 from Michael Paquier <michael(at)paquier(dot)xyz>                      2020-02-11 16:48:48 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                       2020-02-29 12:35:27 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                        2020-02-29 14:53:04 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                         2020-03-09 20:04:47 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                          2020-03-12 17:08:46 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                           2020-03-25 23:40:28 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                            2020-03-26 17:09:15 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                             2020-03-26 18:01:12 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                              2020-03-26 19:22:08 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                              2020-03-27 04:01:06 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                               2020-03-27 20:15:42 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                               2020-03-28 00:11:12 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                2020-03-30 18:02:22 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                 2020-03-30 18:34:39 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                  2020-03-31 10:56:07 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                   2020-04-01 06:03:34 from Michael Paquier <michael(at)paquier(dot)xyz>                                    2020-04-01 11:57:18 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                     2020-04-01 13:08:36 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                      2020-04-03 18:27:12 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                       2020-04-06 17:43:46 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                        2020-04-06 18:44:06 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                         2020-04-07 12:40:18 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                          2020-04-07 20:44:06 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                           2020-04-12 01:33:52 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                            2020-04-12 01:45:41 from Michael Paquier <michael(at)paquier(dot)xyz>                                            2020-04-26 17:56:14 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                             2020-08-09 11:02:52 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                              2020-08-10 02:24:43 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                               2020-08-11 05:39:45 from Michael Paquier <michael(at)paquier(dot)xyz>                                                2020-08-11 07:09:22 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                 2020-09-01 10:12:19 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                  2020-09-01 10:36:38 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                 2020-09-01 15:40:18 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                  2020-09-01 15:43:54 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                   2020-09-01 15:48:30 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                    2020-09-02 01:00:12 from Michael Paquier <michael(at)paquier(dot)xyz>                                                     2020-09-02 01:29:28 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                      2020-09-02 01:48:34 from Michael Paquier <michael(at)paquier(dot)xyz>                                                     2020-09-02 02:24:10 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                      2020-09-02 04:56:44 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                       2020-09-02 21:00:17 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                        2020-09-02 23:07:07 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                         2020-09-04 02:43:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                          2020-09-08 23:39:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                           2020-09-09 00:02:38 from Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>                                                            2020-09-09 00:17:58 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                             2020-09-09 12:22:00 from Michael Paquier <michael(at)paquier(dot)xyz>                                                              2020-09-09 13:03:45 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                              2020-09-09 15:36:29 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                               2020-09-23 16:43:01 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                2020-10-31 18:36:11 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                 2020-11-24 15:31:23 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                  2020-11-30 11:33:36 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                   2020-11-30 14:12:42 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                    2020-12-01 02:46:55 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                     2020-12-01 05:43:08 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                      2020-12-01 06:10:13 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                       2020-12-03 01:19:43 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                        2020-12-03 04:30:08 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                         2020-12-03 07:12:53 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                          2020-12-04 01:25:43 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                           2020-12-04 18:40:31 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                            2020-12-04 19:54:15 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                        2020-12-03 19:46:09 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>                                                                         2020-12-04 05:37:12 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                          2020-12-04 19:28:26 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                           2020-12-05 01:30:50 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                            2020-12-11 18:17:48 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>                                                                             2020-12-11 20:27:03 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                              2020-12-12 00:16:34 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                              2020-12-12 08:20:35 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> 📎                                                                               2020-12-12 19:45:26 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                2020-12-12 20:20:17 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                2020-12-14 04:33:28 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                2020-12-15 00:14:18 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                 2020-12-15 10:34:35 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                                                 2020-12-15 23:58:37 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                2021-01-18 05:18:44 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                 2021-01-18 08:37:57 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                  2021-01-18 15:57:04 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                                                  2021-01-20 11:53:10 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                   2021-01-20 15:47:07 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                    2021-01-20 15:54:50 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                     2021-01-20 18:08:11 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                                                      2021-01-20 18:10:14 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                       2021-01-20 18:34:39 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                        2021-01-21 01:41:46 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                         2021-01-21 14:06:06 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                                                          2021-01-21 20:48:08 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                           2021-01-21 21:26:51 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                            2021-01-22 14:07:02 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                             2021-01-25 08:07:29 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                              2021-01-25 12:58:49 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                              2021-01-25 20:11:38 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                               2021-01-26 06:58:32 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                                                2021-01-26 22:00:50 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                                 2021-01-27 03:14:33 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                  2021-01-27 21:19:06 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                                   2021-01-27 21:35:03 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                                   2021-01-27 21:36:58 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                                    2021-01-28 11:42:40 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                                                                     2021-01-29 17:56:47 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                                      2021-01-30 02:23:01 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                       2021-02-01 15:28:57 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                                        2021-02-01 15:47:14 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                                        2021-02-02 01:32:19 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                         2021-02-03 06:37:39 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                                                          2021-02-03 06:53:42 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                                           2021-02-03 10:54:42 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                            2021-02-04 06:38:39 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                             2021-02-15 02:10:50 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                                              2021-02-15 02:58:02 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                          2021-02-03 10:35:26 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                                                                           2021-02-03 11:01:29 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                                           2021-04-19 22:22:41 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                                            2021-04-19 23:22:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                             2021-04-20 14:59:32 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                                                              2021-04-20 15:03:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                                                               2021-04-20 22:49:59 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                                                2021-04-21 14:32:40 from Andrew Dunstan <andrew(at)dunslane(dot)net>                                                                               2020-12-16 00:45:17 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                2020-12-16 01:01:11 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                 2020-12-22 06:47:57 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                                  2020-12-22 08:32:05 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                   2020-12-22 09:57:41 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                                    2020-12-22 21:15:37 from Justin Pryzby <pryzby(at)telsasoft(dot)com> 📎                                                                                     2020-12-22 23:22:19 from Zhihong Yu <zyu(at)yugabyte(dot)com>                                                                                      2020-12-23 05:22:00 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                       2020-12-23 16:12:11 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                                                     2020-12-23 07:38:18 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                                      2020-12-23 16:30:35 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru>                                                                                       2021-01-13 08:22:49 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                        2021-01-13 11:34:40 from Michael Paquier <michael(at)paquier(dot)xyz> 📎                                                                                         2021-01-13 13:39:40 from Alexey Kondratov <a(dot)kondratov(at)postgrespro(dot)ru> 📎                                                                                          2021-01-14 05:18:45 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                           2021-01-18 05:12:29 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                      2020-12-23 22:22:05 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                       2020-12-23 22:47:49 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                        2020-12-24 00:14:18 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                                                                         2020-12-24 01:07:54 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                                                                                          2020-12-24 01:50:34 from Michael Paquier <michael(at)paquier(dot)xyz>                                                                                           2020-12-24 02:18:33 from Michael Paquier <michael(at)paquier(dot)xyz>
Lists:	pgsql-hackers

In response to

• Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly at 2020-12-23 22:47:49 from Justin Pryzby

Responses

• Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly at 2020-12-24 01:07:54 from Justin Pryzby

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Bharath Rupireddy	2020-12-24 00:18:42	Re: New Table Access Methods for Multi and Single Inserts
Previous Message	Fabien COELHO	2020-12-24 00:06:37	timestamp bogus parser?