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(dot)oliver(at)gmail(dot)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.
>
> --
> Wells Oliver
> wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
>