Vacuuming TOAST after pg_restore

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Vacuuming TOAST after pg_restore
Date: 2023-12-18 22:26:00
Message-ID: CANzqJaD+KQU7PmaX72DsVhZ0kC=NfENC1ZAh+32ZbrH_frpE3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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)?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2023-12-18 22:40:38 Re: Vacuuming TOAST after pg_restore
Previous Message Wetmore, Matthew (CTR) 2023-12-18 19:32:46 Guidance required to summarize the migration breaking changes between PG versions