VACUUM FULL vs backup/restore
От | David Wall |
---|---|
Тема | VACUUM FULL vs backup/restore |
Дата | |
Msg-id | 4BD74E22.3050003@computer.org обсуждение исходный текст |
Ответы |
Re: VACUUM FULL vs backup/restore
Re: VACUUM FULL vs backup/restore Re: VACUUM FULL vs backup/restore |
Список | pgsql-general |
We are copying a production database and then pairing it down dramatically (perhaps removing 99% of records, most of which are large objects). It seems my options are 1) VACUUM FULL with a reindex_db; or 2) backup, then restore. Is there anything one does better than the other? Our impression is that the backup and restore will run faster (perhaps 2 hours), whereas we have a currently running VACUUM FULL that's been running for 4.5 hours already. Anybody have any experience on this? Would a backup/restore essentially create a minimally sized database with all fresh indexes? Thanks, David
В списке pgsql-general по дате отправления: