Re: Faster pg_resore with autovacuum off?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

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@xxxxxxxxx> 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.

--
[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux