Re: [HACKERS] Checksums by default?

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [HACKERS] Checksums by default?
Дата
Msg-id 20170121165753.jjjozqx6k7ut26sa@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [HACKERS] Checksums by default?  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On 2017-01-22 00:41:55 +0900, Fujii Masao wrote:
> On Sun, Jan 22, 2017 at 12:18 AM, Petr Jelinek
> <petr.jelinek@2ndquadrant.com> wrote:
> > On 21/01/17 11:39, Magnus Hagander wrote:
> >> Is it time to enable checksums by default, and give initdb a switch to
> >> turn it off instead?
> >
> > I'd like to see benchmark first, both in terms of CPU and in terms of
> > produced WAL (=network traffic) given that it turns on logging of hint bits.
> 
> +1
> 
> If the performance overhead by the checksums is really negligible,
> we may be able to get rid of wal_log_hints parameter, as well.

It's not just the performance overhead, but also the volume of WAL due
to the additional FPIs...

Andres



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Checksums by default?
Следующее
От: Petr Jelinek
Дата:
Сообщение: Re: [HACKERS] Checksums by default?