| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Vacuuming TOAST after pg_restore |
| Date: | 2023-12-19 07:18:38 |
| Message-ID: | c0f5e164089553e82d7297e22bd6efdf8bf01346.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, 2023-12-18 at 17:26 -0500, Ron Johnson 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)?
You don't have to do that at all, autovacuum will do it for you (ANALYZE if the
tables contain more than 50 rows, and VACUUM if they contain more than 1000 rows).
It just takes some more time to let autovacuum do it.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lejeczek | 2023-12-19 07:59:25 | highest timeline xxx of the primary is behind recovery timeline - backup of the underlying filesystem |
| Previous Message | David G. Johnston | 2023-12-19 00:56:49 | Re: Vacuuming TOAST after pg_restore |