Re: Faster pg_resore with autovacuum off?

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

 



ha, thanks, my machine is plenty strong, fit and hale, new 16 CPU/64GB RDS instance... I was just curious if there were any performance options to change during a restore for any gains. Seems like good reasons to avoid disabling autovacuum, though.

On Sat, Jul 27, 2024 at 7:27 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
On Fri, 2024-07-26 at 17:57 -0700, Wells Oliver 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.

If your machine is too weak to handle the combined workload of restore +
autovacuum, that might get you something.  Otherwise, you are just cheating:
the restore might be faster, but the database is not usable before autovacuum
and autoanalyze have proessed all restored tables.

I wouldn't recommend turning autovacuum off, because it is a dangerous thing
to do.  If you forget to enable it, your database will be in big trouble.

Yours,
Laurenz Albe


--
Wells Oliver
wells.oliver@xxxxxxxxx

[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