Re: how to shrink pg_attribute table in some database

Поиск
Список
Период
Сортировка
От Keith
Тема Re: how to shrink pg_attribute table in some database
Дата
Msg-id CAHw75vuFvy_Tn9ZT0zANugeJOLhrfcmxv4r+XeJV0NszVNmn5Q@mail.gmail.com
обсуждение исходный текст
Ответ на how to shrink pg_attribute table in some database  (Artem Tomyuk <admin@leboutique.com>)
Ответы Re: how to shrink pg_attribute table in some database  (Artem Tomyuk <admin@leboutique.com>)
Re: how to shrink pg_attribute table in some database  (Artem Tomyuk <admin@leboutique.com>)
Список pgsql-admin
Дерево обсуждения


On Mon, Mar 26, 2018 at 9:35 AM, Artem Tomyuk <admin@leboutique.com> wrote:
Hi, Gurus!!!!

Maybe someone knows what is the best way to shrink pg_attribute  in size? 
Maybe backup and restore of this table will sanitize "dead" records in it?
Or only full vacuum can help in this situation?

Thanks!

VACUUM FULL would be the way to go if bloat is the issue you're trying to fix. Trying to backup up & restore a single system catalog would not be recommended.

Keith

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

Предыдущее
От: Artem Tomyuk
Дата:
Сообщение: how to shrink pg_attribute table in some database
Следующее
От: Artem Tomyuk
Дата:
Сообщение: Re: how to shrink pg_attribute table in some database