Re: pg_dump: VACUUM and REINDEXING

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: VACUUM and REINDEXING
Дата
Msg-id 3742514.1652105307@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump: VACUUM and REINDEXING  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> But from PostgreSQL v13 on, autovacuum is also triggered by INSERTs.
> So I'd say that there is nothing to do after restoring a pg_dump, except
> to wait until autovacuum is done.

You might want to do manual VACUUM ANALYZE (no need for FULL) if
you don't want to wait around for autovacuum to get to it.

            regards, tom lane



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