Re: [PERFORM] Backup taking long time !!!
| От | Vladimir Borodin |
|---|---|
| Тема | Re: [PERFORM] Backup taking long time !!! |
| Дата | |
| Msg-id | 17D95770-42B6-4FF5-80FF-465C77119A27@simply.name обсуждение исходный текст |
| Ответ на | [PERFORM] Backup taking long time !!! (Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>) |
| Ответы |
Re: [PERFORM] Backup taking long time !!!
|
| Список | pgsql-performance |
20 янв. 2017 г., в 18:06, Stephen Frost <sfrost@snowman.net> написал(а):
Right, without incremental or compressed backups, you'd have to have
room for 7 full copies of your database. Have you looked at what your
incrementals would be like with file-level incrementals and compression?
Most of our DBs can’t use partitioning over time-series fields, so we have a lot of datafiles in which only a few pages have been modified. So file-level increments didn’t really work for us. And we didn’t use compression in barman before patching it because single-threaded compression sucks.
How are you testing your backups..? Do you have page-level checksums
enabled on your database?
pgbackrest recently added the ability to
check PG page-level checksums during a backup and report issues.
Sounds interesting, should take a look.
В списке pgsql-performance по дате отправления: