Re: Add 64-bit XIDs into PostgreSQL 15

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: Maxim Orlov <orlovmg(at)gmail(dot)com>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>, Evgeny Voropaev <evgeny(dot)voropaev(at)tantorlabs(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
Subject: Re: Add 64-bit XIDs into PostgreSQL 15
Date: 2026-02-08 01:30:41
Message-ID: CA+TgmoYEaxZE7ff7Nk_cKzqWKkEifbOFMjGHwnE_RyxSG=vHZA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Feb 7, 2026 at 5:47 PM Heikki Linnakangas <hlinnaka(at)iki(dot)fi> wrote:
> The thing I like least about this is how the upgrade works, i.e. the
> conversion code and the "double xmax" hack. This would look much nicer
> if we could start from clean slate and just add the fields we need to
> the page header. However, upgrade is important, that point has been
> discussed a lot on the list, and I don't have any better ideas. I think
> it's as good as it gets at the high level.

I don't think the page header is the right thing, because that applies
to every AM, including both table AMs and index AMs. I'd say that some
of the things we already have in the page header don't really make
sense there -- in particular, pd_prune_xid, which is heap-specific. We
can't change that at this point, but we shouldn't make it worse.

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shinya Kato 2026-02-08 09:14:37 Use pg_current_xact_id() instead of deprecated txid_current()
Previous Message Robert Haas 2026-02-08 01:27:55 Re: Add 64-bit XIDs into PostgreSQL 15