Postgres Pro
Downloads
Home   >   mailing lists

Re: Faster pg_resore with autovacuum off? - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Faster pg_resore with autovacuum off?
Date
Msg-id CANzqJaDeGexERYQSwYdQMaBQ9jzenH7jeJC_7Td2DcXaP8smWA@mail.gmail.com
Whole thread Raw
In response to Faster pg_resore with autovacuum off?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Wells Oliver
Date:
Subject: Faster pg_resore with autovacuum off?
Next
From: akshay polji
Date:
Subject: Re: DR setup in RHOS