Message-ID: <567d7f791c4ac691a3f941f08cf30b5c277dddb9.camel@cybertec.at>
Subject: Re: Faster pg_resore with autovacuum off?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ron Johnson <ronljohnsonjr@gmail.com>, pgsql-admin
	 <pgsql-admin@postgresql.org>
Date: Sun, 28 Jul 2024 14:34:16 +0200
In-Reply-To: 
 <CANzqJaC7WgnV74NnLraw_2siNFa6Jkb2d+S7Y9nucAxJpZnaeA@mail.gmail.com>
References: 
	<CAOC+FBXP+xQ5fXbqpS-JTKq1D90DSxd+Vzz+UYDF0mfq1bVvRQ@mail.gmail.com>
	 <4ecf57eb54f6d457357e3882c6e9b0e6eb89aa1b.camel@cybertec.at>
	 <CANzqJaC7WgnV74NnLraw_2siNFa6Jkb2d+S7Y9nucAxJpZnaeA@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/567d7f791c4ac691a3f941f08cf30b5c277dddb9.camel%40cybertec.at>
Precedence: bulk

On Sat, 2024-07-27 at 15:48 -0400, Ron Johnson wrote:
> > If your machine is too weak to handle the combined workload of restore =
+
> > autovacuum, that might get you something.=C2=A0 Otherwise, you are just=
 cheating:
> > the restore might be faster, but the database is not usable before auto=
vacuum
> > and autoanalyze have proessed all restored tables.
>=20
> I 100% disagree with this: autovacuum is not necessary during pg_restore
> (presuming there's only one database in the instance).

It is not necessary during restore, but it is necessary if you want to use
the database after the restore.  Well, you can manually VACUUM and ANALYZE =
the
database, but why not do it automatically?

I think that there are very few good reasons to ever disable autovacuum, an=
d
a restore is not among them.

> Heck, it might not even be=C2=A0vital=C2=A0if you carefully monitor the o=
ther databases
> in the instance.

?

Yours,
Laurenz Albe