agora inbox for pgsql-hackers@postgresql.org
help / color / mirror / Atom feedFrom: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Antonin Houska <ah@cybertec.at>
Cc: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Srinath Reddy Sadipiralla <srinath2133@gmail.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Robert Treat <rob@xzilla.net>
Subject: Re: Adding REPACK [concurrently]
Date: Tue, 5 May 2026 17:02:39 +0200
Message-ID: <afoF8ypBbknkp8_b@alvherre.pgsql> (raw)
In-Reply-To: <27869.1777985266@localhost>
On 2026-May-05, Antonin Houska wrote:
> However, I failed to notice that COMMIT record of
> a transaction listed in the xl_running_xacts WAL record is not guaranteed to
> follow the xl_running_xacts record in WAL. In other words, even if
> xl_running_xacts is created before a COMMIT record of the contained
> transaction, it may end up at higher LSN in WAL. So the cleanup I relied on
> might not take place.
That's pretty bad news.
> I've got no good idea how to fix that. Not sure I'm able to pursue the
> "database-specific snapshots" feature now.
It appears that the only reasonable course of action at this point is to
revert 0d3dba38c777.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
view thread (415+ messages) latest in thread
Message-ID: <afoF8ypBbknkp8_b@alvherre.pgsql>
Permalink: ../afoF8ypBbknkp8_b@alvherre.pgsql/
Also on: postgresql.org/message-id/afoF8ypBbknkp8_b@alvherre.pgsql
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: alvherre@alvh.no-ip.org, ah@cybertec.at, mihailnikalayeu@gmail.com, amit.kapila16@gmail.com, andres@anarazel.de, srinath2133@gmail.com, boekewurm+postgres@gmail.com, pgsql-hackers@lists.postgresql.org, rob@xzilla.net
Subject: Re: Adding REPACK [concurrently]
In-Reply-To: <afoF8ypBbknkp8_b@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox