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

From David G. Johnston
Subject Re: Vacuuming TOAST after pg_restore
Date
Msg-id CAKFQuwaLguQ-onVD0L7jodX6DweEq5FE5AngCfqSDxzbWFTMww@mail.gmail.com
Whole thread Raw
In response to Vacuuming TOAST after pg_restore  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Vacuuming TOAST after pg_restore
List pgsql-admin
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.

David J.

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Vacuuming TOAST after pg_restore
Next
From: Ron Johnson
Date:
Subject: Re: Vacuuming TOAST after pg_restore