Re: pg_dump: VACUUM and REINDEXING

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: pg_dump: VACUUM and REINDEXING
Дата
Msg-id CAECtzeV1+iimVbSYkN32xQ5AFQOEZFj4phmMqFefuYsb4ZtDwA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump: VACUUM and REINDEXING  (Hasan Marzooq <engr.naqvi@gmail.com>)
Список pgsql-general
Дерево обсуждения
Le sam. 7 mai 2022 à 15:27, Hasan Marzooq <engr.naqvi@gmail.com> a écrit :
Hello!

Thanks Guillaume and Ron!

I understand REINDEXING is not required, and as Guillaume highlighted, vacuum will still be needed after pg_restore. 

Is it ok to perform a "standard" vacuum or do we need a "FULL" vacuum after pg_restore?


You don't need VACUUM FULL.
 
Also, I think finding tables which have dead rows and then performing vacuum on those tables only to save some time/processing here.


Finding dead rows in a table is interesting, but not right after a pg_restore. pg_dump only dumps live tuples, so there won't be any dead rows right after pg_restore.


--
Guillaume.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: PLPGSQL - extra column existence in trigger
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: The P0004 assert_failure exception assert_failure exception seems to be unhandleable