Support specify tablespace for each merged/split partition

Поиск
Список
Период
Сортировка
От Junwang Zhao
Тема Support specify tablespace for each merged/split partition
Дата
Msg-id CAEG8a3KkzOqHushYhkMEpVvGiahLRPyEQu7VetUyMdbo30v+4w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Support specify tablespace for each merged/split partition
Список pgsql-hackers
In [1], it is suggested that it might be a good idea to support
specifying the tablespace for each merged/split partition.

We can do the following after this feature is supported:

CREATE TABLESPACE tblspc LOCATION '/tmp/tblspc';
CREATE TABLE t (i int PRIMARY KEY) PARTITION BY RANGE (i);
CREATE TABLE tp_0_1 PARTITION OF t FOR VALUES FROM (0) TO (1);
CREATE TABLE tp_1_2 PARTITION OF t FOR VALUES FROM (1) TO (2);

ALTER TABLE t MERGE PARTITIONS (tp_0_1, tp_1_2) INTO tp_0_2 TABLESPACE tblspc;

ALTER TABLE t SPLIT PARTITION tp_0_2 INTO
    (PARTITION tp_0_1 FOR VALUES FROM (0) TO (1) TABLESPACE tblspc,
    PARTITION tp_1_2 FOR VALUES FROM (1) TO (2));

[1] https://www.postgresql.org/message-id/abaf390b-3320-40a5-8815-ef476db5cfe7@oss.nttdata.com

-- 
Regards
Junwang Zhao

Вложения

В списке pgsql-hackers по дате отправления: