Re: [PERFORM] Backup taking long time !!!

Поиск
Список
Период
Сортировка
От Torsten Zuehlsdorff
Тема Re: [PERFORM] Backup taking long time !!!
Дата
Msg-id c22085f2-b218-5270-1ca9-9288313049ff@toco-domains.de
обсуждение исходный текст
Ответ на Re: [PERFORM] Backup taking long time !!!  (Vladimir Borodin <root@simply.name>)
Ответы Re: [PERFORM] Backup taking long time !!!  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-performance
Hello,

>>> Increments in pgbackrest are done on file level which is not really
>>> efficient. We have done parallelism, compression and page-level
>>> increments (9.3+) in barman fork [1], but unfortunately guys from
>>> 2ndquadrant-it don’t hurry to work on it.
>>
>> We're looking at page-level incremental backup in pgbackrest also.  For
>> larger systems, we've not heard too much complaining about it being
>> file-based though, which is why it hasn't been a priority.  Of course,
>> the OP is on 9.1 too, so.
>
> Well, we have forked barman and made everything from the above just
> because we needed ~ 2 PB of disk space for storing backups for our ~ 300
> TB of data. (Our recovery window is 7 days) And on 5 TB database it took
> a lot of time to make/restore a backup.

I just have around 11 TB but switched to ZFS based backups only. I'm
using snapshots therefore which gives some flexibility. I can rolback
them, i can just clone it and work with a full copy as a different
cluster (and just the differences are stored) and i can send them
incrementally to other servers. This is very fine for my use cases but
it doesn't fit everything of course.

Greetings,
Torsten


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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [PERFORM] Backup taking long time !!!
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: [PERFORM] optimizing immutable vs. stable function calls?