Re: Vacuuming TOAST after pg_restore

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Vacuuming TOAST after pg_restore
Дата
Msg-id CAKFQuwaLguQ-onVD0L7jodX6DweEq5FE5AngCfqSDxzbWFTMww@mail.gmail.com
обсуждение исходный текст
Ответ на Vacuuming TOAST after pg_restore  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: Vacuuming TOAST after pg_restore  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-admin
On Mon, Dec 18, 2023 at 3:26 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
PG 14.10

In the immediate post-pg_restore vaccumdb, can I skip immediate vacuuming of TOAST tables?

Heck, can I skip the immediate VACUUM, and only do an ANALYZE (then go back later and VACUUM)?

There has never been directions to perform an immediate vacuum post-restore.  A restore doesn't perform deletions.  Recovering from a physical backup will benefit from whatever vacuuming the cluster needed at the time it was backed up.

David J.

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Vacuuming TOAST after pg_restore
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Vacuuming TOAST after pg_restore