Re: Vacuuming TOAST after pg_restore

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Mon, Dec 18, 2023 at 3:26 PM Ron Johnson <ronljohnsonjr@xxxxxxxxx> 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.