Re: backup manifests

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: backup manifests
Дата
Msg-id 36be23f1-0bf2-b68b-efee-76d1eb729e14@pgmasters.net
обсуждение исходный текст
Ответ на Re: backup manifests  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Ответы Re: backup manifests  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 11/19/19 5:00 AM, Rushabh Lathia wrote:
> 
> My colleague Suraj did testing and noticed the performance impact
> with the checksums.   On further testing, he found that specifically with
> sha its more of performance impact.  

We have found that SHA1 adds about 3% overhead when the backup is also
compressed (gzip -6), which is what most people want to do.  This
percentage goes down even more if the backup is being transferred over a
network or to an object store such as S3.

We judged that the lower collision rate of SHA1 justified the additional
expense.

That said, making SHA256 optional seems reasonable.  We decided not to
make our SHA1 checksums optional to reduce the test matrix and because
parallelism largely addressed performance concerns.

Regards,
-- 
-David
david@pgmasters.net



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

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock(PG10.7)
Следующее
От: David Fetter
Дата:
Сообщение: Re: Invisible PROMPT2