On Sat, Jul 27, 2024 at 10: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 100% disagree with this: autovacuum is not necessary during pg_restore (presuming there's only one database in the instance).
Heck, it might not even be vital if you carefully monitor the other databases in the instance.
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.
You can't forget to enable autovacuum when it's in the same script as the pg_restore.