Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump: VACUUM and REINDEXING - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: pg_dump: VACUUM and REINDEXING
Date
Msg-id CAECtzeV1+iimVbSYkN32xQ5AFQOEZFj4phmMqFefuYsb4ZtDwA@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump: VACUUM and REINDEXING  (Hasan Marzooq <engr.naqvi@gmail.com>)
List pgsql-general
Tree view
Le sam. 7 mai 2022 à 15:27, Hasan Marzooq <engr.naqvi@gmail.com> a écrit :
Hello!

Thanks Guillaume and Ron!

I understand REINDEXING is not required, and as Guillaume highlighted, vacuum will still be needed after pg_restore. 

Is it ok to perform a "standard" vacuum or do we need a "FULL" vacuum after pg_restore?


You don't need VACUUM FULL.
 
Also, I think finding tables which have dead rows and then performing vacuum on those tables only to save some time/processing here.


Finding dead rows in a table is interesting, but not right after a pg_restore. pg_dump only dumps live tuples, so there won't be any dead rows right after pg_restore.


--
Guillaume.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: PLPGSQL - extra column existence in trigger
Next
From: Bryn Llewellyn
Date:
Subject: The P0004 assert_failure exception assert_failure exception seems to be unhandleable