Re: data_checksums enabled by default (was: Move --data-checksums to common options in initdb --help)

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: data_checksums enabled by default (was: Move --data-checksums to common options in initdb --help)
Дата
Msg-id CAH2-Wzmxv0BOr1X2ZeS7w+30b9mV76isaXrMyYJvzCAp1k2LbQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: data_checksums enabled by default (was: Move --data-checksums to common options in initdb --help)  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
On Wed, Jan 6, 2021 at 9:55 AM Andres Freund <andres@anarazel.de> wrote:
> Vacuum performance is one of *THE* major complaints about
> postgres. Making it run slower by a lot obviously exascerbates that
> problem significantly. I think it'd be prohibitively expensive if it
> were 1.5x, not to even speak of 15x.

+1. I am *strongly* opposed to enabling checksums by default for this
reason. I think that it's a total non-starter, unless and until the
overhead can be dramatically reduced. The fact that it isn't the fault
of the checksum mechanism in some abstract sense is 100% irrelevant.

-- 
Peter Geoghegan



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: data_checksums enabled by default (was: Move --data-checksums to common options in initdb --help)
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: data_checksums enabled by default (was: Move --data-checksums to common options in initdb --help)