Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nXzW4-00078b-EI for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Mar 2022 06:03:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nXzW3-00077l-BI for pgsql-hackers@arkaria.postgresql.org; Sat, 26 Mar 2022 06:03:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nXzW3-00077b-1j for pgsql-hackers@lists.postgresql.org; Sat, 26 Mar 2022 06:03:11 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nXzW0-0002Xt-Ui for pgsql-hackers@postgresql.org; Sat, 26 Mar 2022 06:03:10 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id A56315C00F2; Sat, 26 Mar 2022 02:03:06 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sat, 26 Mar 2022 02:03:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; bh=KTyzmEdjcCBGCw24sgDBri0ucI+PpHCpAWaWf0 qVvFo=; b=A+nUuciLxCPP4jXim3mYYa380QQXNs1TENs3ZPhqEoPihS5lRhnfOU ywnlp7Q4T401hFrOrewHPx8WG0KJvhBUE7VS2tyFr0FLgD2HrF5XOZ/LrH7k8KgE pyAD5ut/pmdX4xn7vZvEQAfUE6Ti3IC6fPIYiYFCpbkUGWjVc/u/77Z88X4qKSse tqBo6yI9jqezrvL00Iwitrs4oIstSZJhfEG1FTrWnZL6BobIrioW6g55OjjQ5mtl AyBvdLhgGnWi3RP9CndRYN811KQ2wglmmzu+rhlFHh1Hue7N/TR8Ok219m7ncmAv ZfJ00ekkIiHPLpyJch33u35MFHdHARkA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=KTyzmEdjcCBGCw24s gDBri0ucI+PpHCpAWaWf0qVvFo=; b=ebzSG1yGsJnR5amAt2aKKmh3iNL9M42uF pmEmgHnskKohexo5QIIsRbsJzLxAIvYc2ZetugonpaRwfNN8gR/xbB2sXdAEk7/4 15S9Sgegfl/sGkF4/IwLzNrO5uf/0miIZK8HTLKaFW2g+1wkh+7fSvIwt6O62yXj wSTzD6aT0LvtiCEhRtXW/0ItVEMJP+bTcboEBGQujSpeGkpn8IlRAih1yxDS7s/3 p20rTUECeKDf4i9IAK2wWHlySeQ94bJTCLfapNgQvH+ARVYx56n8zi1L/ijDaXhY ulBs01BQkphgDrdVAzf+FjshXABh8lZbjw2r2Dt1LV8/TBOOcAQsg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudehvddgkeelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlvdefmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 26 Mar 2022 02:03:02 -0400 (EDT) Date: Sat, 26 Mar 2022 15:03:00 +0900 From: Michael Paquier To: Tom Lane Cc: Robert Haas , Andres Freund , Daniel Gustafsson , Kyotaro Horiguchi , deniel1495@mail.ru, Ibrar Ahmed , tejeswarm@hotmail.com, hlinnaka , Masahiko Sawada , "pgsql-hackers@postgresql.org" , Daniel Wood Subject: Re: Corruption during WAL replay Message-ID: References: <3185871.1648181300@sss.pgh.pa.us> <20220325045438.enwakjqhrafzq5f2@alap3.anarazel.de> <20220325052654.3xpbmntatyofau2w@alap3.anarazel.de> <3193652.1648186725@sss.pgh.pa.us> <20220325060737.iayq5cs36jktqlag@alap3.anarazel.de> <3237467.1648216174@sss.pgh.pa.us> <3238876.1648216924@sss.pgh.pa.us> <3241547.1648218889@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="igeD1m7FmlPhMqTd" Content-Disposition: inline In-Reply-To: <3241547.1648218889@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --igeD1m7FmlPhMqTd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Mar 25, 2022 at 10:34:49AM -0400, Tom Lane wrote: > Robert Haas writes: >> On Fri, Mar 25, 2022 at 10:02 AM Tom Lane wrote: >>> Adding another 16 bits won't get you to that, sadly. Yeah, it *might* >>> extend the MTTF to more than the project's likely lifespan, but that >>> doesn't mean we couldn't get unlucky next week. >=20 >> I suspect that the number of bits Andres wants to add is no less than 48. >=20 > I dunno. Compatibility and speed concerns aside, that seems like an awful > lot of bits to be expending on every page compared to the value. Err. And there are not that many bits that could be recycled for this purpose in the current page layout, aren't there? -- Michael --igeD1m7FmlPhMqTd Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmI+rJQACgkQnvQgOdby QH3QZg//Ssca4M1xKg4EQuXznEu3QeAvIRzTviSWHzuZr0EzZxvMg2x7/0R4km/S yFqC26IX5lhMgxII7ttGz1xLIHxSBmshGGMgOEKmLS0zavg23yPeAJxNKaCoNRlc 5AIOoB7WQEuTL4TJhMFSGcRD7laV0Qai5MkFOPU1dTydAvCqnLsiBtlOyRlpKm0L Ds2wwNU6CV2TeH/gEIYr2gVBvRj4GgeYPUK5Ao5LUtVLK5CGPZDNX/UsJ2o204lX 36QZb0TCwhHNBVvoTAuhUODXplemphv1Q2CvRsamLQanhjHNNIsUKw6iJNy94JcK aOODGUNQf0ROTRya2eVx0o65zvgqnZBIhQHHMNYbCGrdIvvOCZLvfUm2NUq2nrU5 XNc8yK0W5bZ4NUzBBQzKk8Rx3+AjgeyMk9XkyY1OWDa5R3npy/YVLIgJNzKD7M2J APKPWmS/rMhLwTx5h63ItLdzw3MtHHiFHlKt0YJvfJPRYaQB9bxYkwRsJKSZzyNN zBVm8GC1yGDx6IbGI0W9Mo45SalNqpGX7oXLJQSowLcUuU7mGTFCM0Xl8t8Cx5MZ N6PRbNpJPqWG1z4daLqKkCTixcnVpLWoR+HXE+NklfpLERR6r4e0c+dVH3I4C+F/ JxcaWHb0TiycempFOsWUzWIG71fOlc3pLoWY64TTNytxGgVe6Q4= =HGCR -----END PGP SIGNATURE----- --igeD1m7FmlPhMqTd--