Re: Enable data checksums by default

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Enable data checksums by default
Дата
Msg-id 20190329141014.GJ1954@paquier.xyz
обсуждение исходный текст
Ответ на Re: Enable data checksums by default  (Bernd Helmle <mailings@oopsware.de>)
Ответы Re: Enable data checksums by default
Список pgsql-hackers
On Fri, Mar 29, 2019 at 11:16:11AM +0100, Bernd Helmle wrote:
> So between ~7% to 18% impact with checksums in this specific case here.

I can't really believe that many people set up shared_buffers at 128kB
which would cause such a large number of page evictions, but I can
believe that many users have shared_buffers set to its default value
and that we are going to get complains about "performance drop after
upgrade to v12" if we switch data checksums to on by default.
--
Michael

Вложения

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pgsql: Improve autovacuum logging for aggressive andanti-wraparound ru
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: table_privileges view always show object owner as a grantor