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 по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Re: PLPGSQL - extra column existence in trigger
Следующее
От: Sandeep Kumar Jakkaraju
Дата:
Сообщение: Re: Need to install Postgres Version 14 in Linux server with Client and migration steps.