Re: data checksums

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: data checksums
Дата
Msg-id 15AB8DDB-7D4B-4272-801F-F5DD84E829E6@thebuild.com
обсуждение исходный текст
Ответ на data checksums  (bruno vieira da silva <brunogiovs@gmail.com>)
Ответы Re: data checksums
Re: data checksums
Список pgsql-general

> On Aug 6, 2024, at 08:11, bruno vieira da silva <brunogiovs@gmail.com> wrote:
>
> so my question is why data checksums aren't enabled by default on pg?

At this point, mostly historical reasons.  They're also superfluous if your underlying file system or storage hardware
doesstorage-level corruption checks (which most don't). 

> the pg doc
> mentions a considerable performance penality, how considerable it is?

That line is probably somewhat out of date at this point.  We haven't seen a significant slowdown in enabling them on
anymodern hardware.  I always turn them on, except on the type of filesystems/hardware mentioned above. 


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