Re: Vacuuming TOAST after pg_restore
| От | Ron Johnson |
|---|---|
| Тема | Re: Vacuuming TOAST after pg_restore |
| Дата | |
| Msg-id | CANzqJaA7bHRtwr-OQQq8mRaYJEU13w1AVjd=DMtVQaideXefeQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Vacuuming TOAST after pg_restore ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: Vacuuming TOAST after pg_restore
|
| Список | pgsql-admin |
On Mon, Dec 18, 2023 at 5:41 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Dec 18, 2023 at 3:26 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:PG 14.10In 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.
В списке pgsql-admin по дате отправления: