Message-ID: <4ecf57eb54f6d457357e3882c6e9b0e6eb89aa1b.camel@cybertec.at>
Subject: Re: Faster pg_resore with autovacuum off?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Wells Oliver <wells.oliver@gmail.com>, pgsql-admin
	 <pgsql-admin@postgresql.org>
Date: Sat, 27 Jul 2024 16:27:15 +0200
In-Reply-To: 
 <CAOC+FBXP+xQ5fXbqpS-JTKq1D90DSxd+Vzz+UYDF0mfq1bVvRQ@mail.gmail.com>
References: 
	<CAOC+FBXP+xQ5fXbqpS-JTKq1D90DSxd+Vzz+UYDF0mfq1bVvRQ@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.3 (3.52.3-1.fc40) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/4ecf57eb54f6d457357e3882c6e9b0e6eb89aa1b.camel%40cybertec.at>
Precedence: bulk

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 th=
e
> restore faster? I think I've restored and then run=C2=A0vacuumdb=C2=A0+ a=
nalyze,
> 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 autovacu=
um
and autoanalyze have proessed all restored tables.

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

Yours,
Laurenz Albe