Re: Faster pg_resore with autovacuum off?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Faster pg_resore with autovacuum off?
Дата
Msg-id CANzqJaDeGexERYQSwYdQMaBQ9jzenH7jeJC_7Td2DcXaP8smWA@mail.gmail.com
обсуждение исходный текст
Ответ на Faster pg_resore with autovacuum off?  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin
Дерево обсуждения
I found this link last year when Googling how to speed up pg_restore:
https://www.databasesoup.com/2014/09/settings-for-fast-pgrestore.html

On Fri, Jul 26, 2024 at 8:58 PM Wells Oliver <wells.oliver@gmail.com> wrote:
Maybe it's an old wives' tale, but I swear I've read a recommendation to turn autovacuum off when doing pg_restore into a new server.. Would it make the restore faster? I think I've restored and then run vacuumdb + analyze, but I wanted to check.

--

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