Re: ALTER TABLE SET ACCESS METHOD on partitioned tables

Поиск
Список
Период
Сортировка
Искать
От
Justin Pryzby
Тема
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables
Дата
в 23:14:14
Msg-id
20220518231414.GN19626@telsasoft.com
Ответ на
Список
Дерево обсуждения
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Zhihong Yu <zyu@yugabyte.com>
Thanks for copying me.

I didn't look closely yet, but this comment is wrong:

+ * Since these have no storage the tablespace can be updated with a simple                                                                                                                                                        
+ * metadata only operation to update the tablespace.                                                                                                                                                                              

As I see it, AMs are a strong parallel to tablespaces.  The default tablespace
is convenient: 1) explicitly specified tablespace; 2) tablespace of parent,
partitioned table; 3) DB tablespace; 4) default_tablespace:
https://www.postgresql.org/message-id/20190423222633.GA8364%40alvherre.pgsql

It'd be convenient if AMs worked the same way (and a bit odd that they don't).
Note that in v15, pg_dump/restore now allow --no-table-am, an exact parallel to
--no-tablespace.

-- 
Justin


В списке pgsql-hackers по дате отправления
От: Zhihong Yu
Дата:
От: Tom Lane
Дата:
FAQ