Re: Add 64-bit XIDs into PostgreSQL 15
От | Maxim Orlov |
---|---|
Тема | Re: Add 64-bit XIDs into PostgreSQL 15 |
Дата | |
Msg-id | CACG=eza44ZoJRNei7T8xxYxX3v+QfzCJg7tuVqp+Y6mTa0oxUw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Add 64-bit XIDs into PostgreSQL 15 (Maxim Orlov <orlovmg@gmail.com>) |
Список | pgsql-hackers |
Rebase @ 53eff471c69dc8b0c01
I revised parts of heap_convert.c's conversion from 32-bit to
64-bit pages.
Previously, we used a deferred full-page write to the converted pages
to reduce the impact on WAL. Leaving some converted pages in RAM
memory. This, however, may cause the incoming autovacuum (AV) to clean
transaction statuses for some pages depending on their XIDs. As a
result, we risk losing transaction statuses and encountering problems
like "could not open file pg_xact/...".
So I decided to abandon the delayed FPW of converted pages, as this
write is purely a one-time issue on the first read of the data after
the 64-bit upgrade.
64-bit pages.
Previously, we used a deferred full-page write to the converted pages
to reduce the impact on WAL. Leaving some converted pages in RAM
memory. This, however, may cause the incoming autovacuum (AV) to clean
transaction statuses for some pages depending on their XIDs. As a
result, we risk losing transaction statuses and encountering problems
like "could not open file pg_xact/...".
So I decided to abandon the delayed FPW of converted pages, as this
write is purely a one-time issue on the first read of the data after
the 64-bit upgrade.
On Tue, 15 Jul 2025 at 09:23, Maxim Orlov <orlovmg@gmail.com> wrote:
Rebase @ f5a987c0e5f6bbf0Main conflicts were:62a17a9283 Integrate FullTransactionIds deeper into two-phase code
2633dae2e4 Standardize LSN formatting by zero paddingAlso, no setting XLOG_HEAP_INIT_PAGE on empty page as discussed above added.On Mon, 7 Jul 2025 at 12:49, Yura Sokolov <y.sokolov@postgrespro.ru> wrote:> Wow, it is really great bug.It's funny that no one has actually encountered this problem in all these years. It mustbe a very rare mix of circumstances, I think.Thank you very much, everyone, for participating!--Best regards,Maxim Orlov.
--
Best regards,
Maxim Orlov.
Вложения
В списке pgsql-hackers по дате отправления: