Thread

  1. Re: clog segment truncation

    Matheus Alcantara <matheusssilv97@gmail.com> — 2025-11-10T13:43:47Z

    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