MIME-Version: 1.0
References: <CAB+Nuk8y88kvoRHsfN2Pjed9o_iM+9FbveU=4P8G0EQbzFP+qw@mail.gmail.com>
In-Reply-To: <CAB+Nuk8y88kvoRHsfN2Pjed9o_iM+9FbveU=4P8G0EQbzFP+qw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 6 Aug 2024 12:25:15 -0400
Message-ID: <CANzqJaDruMZaom0ZCvum=r_b9Z-Sri7SqbGfEpqxOyCH0x-K9w@mail.gmail.com>
Subject: Re: data checksums
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b98c01061f063daa"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDruMZaom0ZCvum%3Dr_b9Z-Sri7SqbGfEpqxOyCH0x-K9w%40mail.gmail.com>
Precedence: bulk

--000000000000b98c01061f063daa
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Aug 6, 2024 at 11:12=E2=80=AFAM bruno vieira da silva <brunogiovs@g=
mail.com>
wrote:

> Hello.
> I've been dealing with some database corruption events, so i've been
> wondering to enable data checksums on my deployments.
>
> so my question is why data checksums aren't enabled by default on pg? the
> pg doc
> mentions a considerable performance penality, how considerable it is?
>

I'm going to hazard a guess that the relevant line from the docs were
written many many years ago, back when servers were much slower.

We certainly didn't notice any speed degradation when going from PG 9.6.24
to PG 14.12.  Or... we just use enough hardware and flash-only SAN disks to
make the overhead minuscule.

--=20
Death to America, and butter sauce.
Iraq lobster!

--000000000000b98c01061f063daa
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Aug 6, 2024 at 11:12=E2=80=AFAM b=
runo vieira da silva &lt;<a href=3D"mailto:brunogiovs@gmail.com">brunogiovs=
@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hello.<div><div>I&#39=
;ve been dealing with some database corruption events, so i&#39;ve been won=
dering to enable data checksums on my deployments.=C2=A0</div><div><br></di=
v><div>so my question is why data checksums aren&#39;t enabled by default o=
n pg? the pg doc=C2=A0</div><div>mentions a considerable performance penali=
ty, how considerable it is?</div></div></div></blockquote><div>=C2=A0</div>=
</div><div>I&#39;m going to hazard a guess that the relevant line from the =
docs were written many many years ago, back when servers were much slower.<=
/div><div><br></div><div>We certainly didn&#39;t notice any speed degradati=
on when going from PG 9.6.24 to PG 14.12.=C2=A0 Or... we just use enough ha=
rdware and flash-only SAN disks to make the overhead minuscule.</div><div><=
br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"l=
tr" class=3D"gmail_signature"><div dir=3D"ltr">Death to America, and butter=
 sauce.<div>Iraq lobster!</div></div></div></div>

--000000000000b98c01061f063daa--