On 5/6/22 21:35, Hasan Marzooq wrote:
Hello!
I've some questions around Backup & Restore.
1: Is it necessary to perform a VACUUM and REINDEXING operation after restoring the dump from Postgres 9.6 to Postgres 13? The dump size could be 1/2 TB to 1 TB.
Perform VACUUM after there have been many updates and deletes. There have been zero updates and deleted after pg_restore; therefore,
no need to vacuum.
pg_restore loads all tables and then builds all indices. Thus,
no need to reindex.
2: Also, are there any other operations that are recommended to perform after pg_restore?
ANALYZE all tables.
https://www.postgresql.org/docs/13/app-vacuumdb.htmlvacuumdb --dbname=whatever --jobs=`nproc` --analyze-only
3: What is the minimum required disk space if taking a dump on the same machine where the source database exists? Is it the "size of the current data folder x 2"?
Probably much less, but maybe (if, for example, you store lots of images (JPEG, TIFF, PDF, etc) in bytea columns.
Whatever you do, make sure to run pg_dump with these options:
--format=directory --jobs=`nproc`https://www.postgresql.org/docs/13/app-pgdump.html--
Angular momentum makes the world go 'round.