From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Vacuuming TOAST after pg_restore |
Date: | 2023-12-18 23:14:17 |
Message-ID: | CANzqJaA7bHRtwr-OQQq8mRaYJEU13w1AVjd=DMtVQaideXefeQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Mon, Dec 18, 2023 at 5:41 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> 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.
>
I'm sure I saw that it was recommended for the purpose of setting the FSM.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2023-12-19 00:56:49 | Re: Vacuuming TOAST after pg_restore |
Previous Message | David G. Johnston | 2023-12-18 22:40:38 | Re: Vacuuming TOAST after pg_restore |