From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
---|---|
To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Faster pg_resore with autovacuum off? |
Date: | 2024-07-28 12:34:16 |
Message-ID: | 567d7f791c4ac691a3f941f08cf30b5c277dddb9.camel@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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. 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).
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, and
a restore is not among them.
> Heck, it might not even be vital if you carefully monitor the other databases
> in the instance.
?
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2024-07-28 12:35:35 | Re: Stream pg_dumpall directly from CentOS7 to Red Hat server |
Previous Message | Ron Johnson | 2024-07-28 12:33:28 | Re: Stream pg_dumpall directly from CentOS7 to Red Hat server |