Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sbLr9-00Fxxe-Ty
	for pgsql-general@arkaria.postgresql.org; Tue, 06 Aug 2024 15:12:11 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sbLr8-000kAy-Ax
	for pgsql-general@arkaria.postgresql.org; Tue, 06 Aug 2024 15:12:10 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <brunogiovs@gmail.com>)
	id 1sbLr7-000k7w-VZ
	for pgsql-general@lists.postgresql.org; Tue, 06 Aug 2024 15:12:09 +0000
Received: from mail-oa1-x34.google.com ([2001:4860:4864:20::34])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <brunogiovs@gmail.com>)
	id 1sbLr5-003OdN-Mc
	for pgsql-general@lists.postgresql.org; Tue, 06 Aug 2024 15:12:08 +0000
Received: by mail-oa1-x34.google.com with SMTP id 586e51a60fabf-25e3bc751daso414354fac.3
        for <pgsql-general@lists.postgresql.org>; Tue, 06 Aug 2024 08:12:07 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1722957127; x=1723561927; darn=lists.postgresql.org;
        h=to:subject:message-id:date:from:mime-version:from:to:cc:subject
         :date:message-id:reply-to;
        bh=Nx3sVITIK+57Y7R/JvMal0eick0ausQm2CJ4eC8jP4g=;
        b=ZoCdfura51yK6fYrI9lTPLt/U0z4PGvlN+rM0RlK75/YVVBUezL0iPbAgda9SqxHYc
         gEXhxMaFlnDyW4zTI2XcMwMafbaQhoAvJaaNixEJeA67qqOCuQ7a31jjlL5jbCbB5wuK
         ArxRd/PrLTEJyxoP9xg5JaDOXs0VVSpaz74065N7dREHsvCvqUboDnNGzY9qbdDBaIqR
         qOkwcgzl2XUDky6c9K1+tK7HCIGmf84qQU3epYHGtJl9t1Fm+tP+Dqtf+1TzhT5kMPD4
         qZJAPE7Nx7NeGs6mWLyoOsVWXI0UJIGpwOeo5nV/aGKJ15qe6v2piWsLkTMxyaee+UY8
         7HMg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1722957127; x=1723561927;
        h=to:subject:message-id:date:from:mime-version:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=Nx3sVITIK+57Y7R/JvMal0eick0ausQm2CJ4eC8jP4g=;
        b=ricDZ2fVeDAWrzPNOCJYu1XUU+dRorW7ClugXTgishmhyCnP9Xf2RB1hZdaApGCngp
         9aQT3jxfV2ofLQ7/RgQJMJoskClasxWY8XG5Pr1co/irozkUf97ccHMC5Wec3ggSDs3g
         Asw8JZ8JK4Nf1j/VUMr4qldm6ZCJvZ34HZNXe5VIo4q+qQeIVdcqCT0xEYSvNCE9CT6D
         8FuuKp0d7RKKltsXJ7YGRDCbQD4gloOjcsiaPduTAi0786hHXDkDNG8O9DrqEbFh8VPR
         yu5kO0c7312Lpq33m1ARK+57cuiegwRQ3hAnRgBDUFdVrUFFF9yI1fsqGpBzu5rl86Xl
         +tAg==
X-Gm-Message-State: AOJu0YywtvQHS3EieHitkdKZSfrFLcgcdy+qY+yQn7Km/W+x/bKB1s1m
	BST0nXWzTzyLAtWvCc2pTH+u9ku8aJKnSrdTk1Yl/rr1eNHB+c8u9cZcUgcrDmH8WsiMr8g3dhV
	ZR8kFjuvwNbVPqiCZR4gPTtq622rgIpFDMY4=
X-Google-Smtp-Source: AGHT+IGjpD9LYrZo850FzadkCEwkpZnoNG9tEiaSNbwKFnFkP8E21ED7O1DDPxpRshhS5+22HJsZlSztmkXv4GA2g5k=
X-Received: by 2002:a05:6870:6390:b0:25e:1610:9705 with SMTP id
 586e51a60fabf-26891a7eb06mr19575758fac.2.1722957126608; Tue, 06 Aug 2024
 08:12:06 -0700 (PDT)
MIME-Version: 1.0
From: bruno vieira da silva <brunogiovs@gmail.com>
Date: Tue, 6 Aug 2024 11:11:55 -0400
Message-ID: <CAB+Nuk8y88kvoRHsfN2Pjed9o_iM+9FbveU=4P8G0EQbzFP+qw@mail.gmail.com>
Subject: data checksums
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007eafc8061f0537a0"
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/CAB%2BNuk8y88kvoRHsfN2Pjed9o_iM%2B9FbveU%3D4P8G0EQbzFP%2Bqw%40mail.gmail.com>
Precedence: bulk

--0000000000007eafc8061f0537a0
Content-Type: text/plain; charset="UTF-8"

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?

Thanks
-- 
Bruno Vieira da Silva

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

<div dir=3D"ltr">Hello.<div><div>I&#39;ve been dealing with some database c=
orruption events, so i&#39;ve been wondering to enable data checksums on my=
 deployments.=C2=A0</div><div><br></div><div>so my question is why data che=
cksums aren&#39;t enabled by default on pg? the pg doc=C2=A0</div><div>ment=
ions a considerable performance penality, how considerable it is?</div><div=
><br></div><div>Thanks<div><span class=3D"gmail_signature_prefix">-- </span=
><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_sig=
nature"><div dir=3D"ltr">Bruno Vieira da Silva<br></div></div></div></div><=
/div></div>

--0000000000007eafc8061f0537a0--