Re: how to clean dropped column in pg_attribute

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: how to clean dropped column in pg_attribute
Дата
Msg-id 20200908094917.GA11563@depesz.com
обсуждение исходный текст
Ответ на how to clean dropped column in pg_attribute  (ZongtianHou <zongtianhou@icloud.com>)
Ответы Re: how to clean dropped column in pg_attribute  (ZongtianHou <zongtianhou@icloud.com>)
Список pgsql-admin
On Tue, Sep 08, 2020 at 05:38:24PM +0800, ZongtianHou wrote:
> I found dropped columns still exist in pg_attribute table. In the
> below example I drop c2 column and vacuum (full) this table and
> pg_attribute, it still exist (the last row). how can I clean it away? 

Unfortunately only by copying the table aside, and then renaming new
table.

But - the dropped attribute will not sure any disk space, as long as you
ran some vacuums.

Best regards,

depesz




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

Предыдущее
От: ZongtianHou
Дата:
Сообщение: how to clean dropped column in pg_attribute
Следующее
От: ZongtianHou
Дата:
Сообщение: Re: how to clean dropped column in pg_attribute