Re: Add 64-bit XIDs into PostgreSQL 15

Поиск
Список
Период
Сортировка
От Finnerty, Jim
Тема Re: Add 64-bit XIDs into PostgreSQL 15
Дата
Msg-id 9AFAF000-2E9E-443E-9EC3-7B67D6A03E5B@amazon.com
обсуждение исходный текст
Ответ на Re: Add 64-bit XIDs into PostgreSQL 15  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: Add 64-bit XIDs into PostgreSQL 15  (Justin Pryzby <pryzby@telsasoft.com>)
Re: Add 64-bit XIDs into PostgreSQL 15  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Re:    The "prepare" approach was the first tried.
    https://github.com/postgrespro/pg_pageprep
    But it appears to be very difficult and unreliable.  After investing
    many months into pg_pageprep, "double xmax" approach appears to be
    very fast to implement and reliable.

I'd still like a plan to retire the "double xmax" representation eventually.  Previously I suggested that this could be
doneas a post-process, before upgrade is complete, but that could potentially make upgrade very slow. 
 

Another way to retire the "double xmax" representation eventually could be to disallow "double xmax" pages in
subsequentmajor version upgrades (e.g. to PG16, if "double xmax" pages are introduced in PG15).  This gives the luxury
oftime after a fast upgrade to convert all pages to contain the epochs, while still providing a path to more
maintainablecode in the future.
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary processes
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Add 64-bit XIDs into PostgreSQL 15