Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuuming TOAST after pg_restore - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Vacuuming TOAST after pg_restore
Date
Msg-id CANzqJaA7bHRtwr-OQQq8mRaYJEU13w1AVjd=DMtVQaideXefeQ@mail.gmail.com
Whole thread Raw
In response to Re: Vacuuming TOAST after pg_restore  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Vacuuming TOAST after pg_restore
List pgsql-admin
Tree view
On Mon, Dec 18, 2023 at 5:41 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Dec 18, 2023 at 3:26 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
PG 14.10

In the immediate post-pg_restore vaccumdb, can I skip immediate vacuuming of TOAST tables?

Heck, can I skip the immediate VACUUM, and only do an ANALYZE (then go back later and VACUUM)?

There has never been directions to perform an immediate vacuum post-restore.  A restore doesn't perform deletions.  Recovering from a physical backup will benefit from whatever vacuuming the cluster needed at the time it was backed up.
 
I'm sure I saw that it was recommended for the purpose of setting the FSM.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Vacuuming TOAST after pg_restore
Next
From: "David G. Johnston"
Date:
Subject: Re: Vacuuming TOAST after pg_restore