Re: Add 64-bit XIDs into PostgreSQL 15 - Mailing list pgsql-hackers

From Yura Sokolov
Subject Re: Add 64-bit XIDs into PostgreSQL 15
Date
Msg-id d8db53f0-6343-4508-8bcc-07a878d136f6@postgrespro.ru
Whole thread Raw
In response to Re: Add 64-bit XIDs into PostgreSQL 15  (Andrey Borodin <x4mmm@yandex-team.ru>)
List pgsql-hackers
04.07.2025 11:31, Andrey Borodin wrote:
> 
> 
>> On 2 Jul 2025, at 18:38, Maxim Orlov <orlovmg@gmail.com> wrote:
>>
>> If you 
>> know of any real problems, please tell me
> 
> If I understood correctly, pages can differ on primary and standby. That might be problematic for WAL debug tests.

They may differ. They differ even now. It is normal.

That is why when you enable "wal_consistency_checking" (developer option,
not present in sample postgresql.conf), pages are masked: allowed to be
different pieces are zeroed (pages hint bits, tuple hint bits, space
between pd_lower and pd_upper).

Before last version, empty space between tuples with
"repair_fragmentation=false" was certainly possible source of difference
not masked by standard mask procedure. But now those holes are zeroed.

-- 
regards
Yura Sokolov aka funny-falcon



pgsql-hackers by date:

Previous
From: 邱宇航
Date:
Subject: Wrong off type in smgrfd and mdfd
Next
From: Aleksander Alekseev
Date:
Subject: Re: Remove unused wait_event_info parameter in FileStartReadV()