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.96) (envelope-from ) id 1vR6BX-006Uw0-2B for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Dec 2025 10:03:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vR6BW-0025Qd-1K for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Dec 2025 10:03:38 +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.96) (envelope-from ) id 1vR6BW-0025QV-0N for pgsql-hackers@lists.postgresql.org; Thu, 04 Dec 2025 10:03:38 +0000 Received: from mail-qk1-x735.google.com ([2607:f8b0:4864:20::735]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vR6BT-0035ES-2N for pgsql-hackers@lists.postgresql.org; Thu, 04 Dec 2025 10:03:37 +0000 Received: by mail-qk1-x735.google.com with SMTP id af79cd13be357-8b1bb9c3c04so15622185a.3 for ; Thu, 04 Dec 2025 02:03:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764842615; x=1765447415; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=joJWBoao97ERyPiSKRbC/SokC1Dx6XPoHA/srgsqu+U=; b=ftj+k+Jv+RYUSKggMn4Yo877Hw0XqyhtkFyuDXnOXlMkqigBIypIJAa+QnAskac6fk ZJ/DT5cRrG/G3dpgUCOWTgknmhdfMbdYF4egfTIEnMpuicfHj6nuxL0W2To8UWDpTiBL 095odubMRSRENvexXMy15fvCUiXeaxL0ssPNBdPtuozX4b30IVJK/QFtCXjGmAMxhzMN jI8Cal1zJMLIbxwZFigqhXZv2MZfAZnf88Ixk29W1oOPiqLAVqfsJDJJxpLWX8H+bQQa ERzdCwooQ0jj+hf/SXfPe9A2WMCXiEsvHjg9aFF0iK4jo1VN0CnlQtDYMx/1EMfdFwUp xF+w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764842615; x=1765447415; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=joJWBoao97ERyPiSKRbC/SokC1Dx6XPoHA/srgsqu+U=; b=SYRuAo8CkjgCMW6FnFf0PUGecQBwwl554x29GuS5MkNHwKBNVSeQ/8wGFT3OHZLCW7 JEiVANih6JGczMiUckuW37YE5Ywi+GNOpNOUynvJ5M7YoXrB9zseIPEvVB1RwBuNv24N oR++2Vp5iiw9OEelRd1G5RazXGDm7VbEZHQp0IWnkCuRhs5dLQd9Cfhn9+CEfm3gpdwR kVuIR5ivFO0vS1A7bg/SuWTEquwCGl6K0h513gW0njfDh2o7ooSuw28y5sucHupTiulz sPgOXSzj7HlDoq+4G30rMljKPsco26DQJVbdZ+SIxPJeXdciMEAcGRC8te60Hk+VNHgC N6VQ== X-Forwarded-Encrypted: i=1; AJvYcCXnjmSgsdNV/5NyrT5PAT796IbRuJrhUTaRYfeozU2BKDwGssk3yO48zhtItC+pxWJwqC6w25Zts1QOHp6g@lists.postgresql.org X-Gm-Message-State: AOJu0YwA+F16ND/adlXjEBeeLeH59GSDF2eGIj388MDTSEUzohM3w8Im JWfPKfvh6eJWyf3T6hwOm8+58P/HfBjjJbe+rtQOUgnmmR/VvQk4sViPraUfT+qDbv5lPCuTJkH 14aIt9frzUeyKXaROh+1BNlrUyxStuh4= X-Gm-Gg: ASbGnctJXtp1trriAgEaGv+fAgD6s9y3JMRnf3CKvbb0kJXeaqKT8huUHX2uD3azce6 K53USIbeCdmllsfwFksrY/d1StRgbKj79Jck396TeiT5SGs7KPjy99RvCJ/aeN7girSlevNOfA/ clnFoGoGI2JD93oeDB9fKtxQ6OUARdhAO+taaD5G6lkXsiTlF0qYq+eZaa9yhwrBMfCV7opcOhB Gn7nFMRSbVjTWpSv4nhApuu4pW6onXqCeB5qhHcmx3EQ88T2V+SCv2evSI9zkRXkZ/ZXw== X-Google-Smtp-Source: AGHT+IHFzgDnYPptEgZqCvyjkGuURgbzXQKMd5OZYkKyqHiS4YZebQ7dT45o9cAK1GMB7TyjKQThGU1o52VH4zkNf/U= X-Received: by 2002:ac8:5aca:0:b0:4ed:6862:cdd0 with SMTP id d75a77b69052e-4f01b3c6537mr51443841cf.10.1764842615556; Thu, 04 Dec 2025 02:03:35 -0800 (PST) MIME-Version: 1.0 References: <36531c0e-292c-409d-bbc7-a252cf6e910a@iki.fi> <54aa8f65-f0e4-4464-b543-e0399c1cab1e@iki.fi> <4a9dda70-0af7-41a4-9636-b168f2fc48ef@iki.fi> <46cc45e9-fddd-44bc-bcb3-96889aafd921@iki.fi> <6c298bc4-7029-4c1d-bf16-3e094842ce32@iki.fi> <9ee6324a-44fc-42fb-bf8e-7c3b53395588@iki.fi> <52227f05-51aa-40c4-8f83-9c79fff16175@iki.fi> <5c4b2864-3baf-4ebc-8405-280fc1a1c8a9@iki.fi> In-Reply-To: <5c4b2864-3baf-4ebc-8405-280fc1a1c8a9@iki.fi> From: Maxim Orlov Date: Thu, 4 Dec 2025 13:03:23 +0300 X-Gm-Features: AWmQ_blUqzcpOS2v_6mgvDFDWsqhHamAfiBVdS07v_OSyJg0QLb_xibDvgYcy5U Message-ID: Subject: Re: POC: make mxidoff 64 bits To: Heikki Linnakangas Cc: Alexander Korotkov , Alvaro Herrera , wenhui qiu , Postgres hackers , Ashutosh Bapat Content-Type: multipart/alternative; boundary="0000000000002f4e4406451d7164" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002f4e4406451d7164 Content-Type: text/plain; charset="UTF-8" On Wed, 3 Dec 2025 at 15:04, Heikki Linnakangas wrote: > > There are plenty of such critical bytes in the system where a single bit > flip renders the whole block unreadable. Actually, if we had checksums > on SLRU pages, a single bit flip anywhere in the page would make the > checksum fail and render the block unreadable. > > Correct. However, my concern about the lack of checksums for SLRU wasn't about data loss and the impossibility of recovering it, but about the impossibility of detecting the error. But it is how it is for now. -- Best regards, Maxim Orlov. --0000000000002f4e4406451d7164 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Wed, 3 Dec 2= 025 at 15:04, Heikki Linnakangas <hli= nnaka@iki.fi> wrote:

There are plenty of such critical bytes in the system where a single bit flip renders the whole block unreadable. Actually, if we had checksums
on SLRU pages, a single bit flip anywhere in the page would make the
checksum fail and render the block unreadable.

Cor= rect. However, my concern about the lack of checksums for SLRU wasn'tabout data loss and the impossibility of recovering it, but about the
= impossibility of detecting the error.=C2=A0 But it is how it is for now.

--
Best regards,
Maxim Orlov.
--0000000000002f4e4406451d7164--