Re: clog segment truncation

Matheus Alcantara <matheusssilv97@gmail.com>

From: "Matheus Alcantara" <matheusssilv97@gmail.com>
To: "Smolkin Grigory" <smallkeen@gmail.com>, <pgsql-bugs@lists.postgresql.org>
Date: 2025-11-10T13:43:47Z
Lists: pgsql-bugs
On Mon Nov 10, 2025 at 9:29 AM -03, Smolkin Grigory wrote:
> So is it possible that either all_frozen bit was set incorrectly or wansn't
> unset when tuples were created?
> I will be happy to provide any additional information if required.
> PostgreSQL version: 15.6, data_checksums: on
>
Actually the 15.6 is quite old. I would also recommend to upgrade to the
latest 15 release which is 15.14.

I didn't find any specific release note about clog truncation but you
are missing some important fixes though.

There is this fix [1] on 15.8 but I'm not sure if it's fully related
with your issue faced here.

[1] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=c809a2b2d

-- 
Matheus Alcantara
EDB: http://www.enterprisedb.com