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