Re: Add 64-bit XIDs into PostgreSQL 15

Поиск
Список
Период
Сортировка
От Yura Sokolov
Тема Re: Add 64-bit XIDs into PostgreSQL 15
Дата
Msg-id d8db53f0-6343-4508-8bcc-07a878d136f6@postgrespro.ru
обсуждение исходный текст
Ответ на Re: Add 64-bit XIDs into PostgreSQL 15  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список 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 по дате отправления: