Le sam. 7 mai 2022 à 15:27, Hasan Marzooq <engr.naqvi@xxxxxxxxx> 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.
