Re: How to reclaim the space of dropped columns of a table?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to reclaim the space of dropped columns of a table?
Дата
Msg-id CAKFQuwZyx+UkVecbcAH_Z7Q-aUgxpFvNCS=WCCc5bJ79WRF-vA@mail.gmail.com
обсуждение исходный текст
Ответ на How to reclaim the space of dropped columns of a table?  (Paul Guo <pguo@pivotal.io>)
Ответы Re: How to reclaim the space of dropped columns of a table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Дерево обсуждения
On Mon, Jul 15, 2019 at 8:42 AM Paul Guo <pguo@pivotal.io> wrote:
This seems to a bit vague for users (how to rewrite but keep the table definition) and it seems to still keep the dropped columns (though with null). Isn't it better to leave the functionality to command like 'vacuum full' to completely remove the dropped columns (i.e. no dropped columns in pg_attributes and no null values for dropped columns for a table)?

Probably.  But it doesn't seem worth the effort to accomplish.  The amount of data involved (and VACUUM FULL does perform the table rewrite described) to represent the missing column is minimal.

David J.

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

Предыдущее
От: Paul Guo
Дата:
Сообщение: How to reclaim the space of dropped columns of a table?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Change ereport level for QueuePartitionConstraintValidation