On Mon, Dec 18, 2023 at 3:26 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)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.