pg_dump: VACUUM and REINDEXING

Поиск
Список
Период
Сортировка
От Hasan Marzooq
Тема pg_dump: VACUUM and REINDEXING
Дата
Msg-id CANvhf8JViXsNYOvWEecZ_3dHq4shNFeby+W7u2jerEqnD+4Gpw@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump: VACUUM and REINDEXING
Re: pg_dump: VACUUM and REINDEXING
Список pgsql-general
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.

2: Also, are there any other operations that are recommended to perform after pg_restore? 

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"?

Thanks.
Hasan



В списке pgsql-general по дате отправления:

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: How to get value wrapped in json?
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: "A transaction cannot be ended inside a block with exception handlers."