On 2025-Oct-20, Matheus Alcantara wrote:
> This is similar to what was already proposed at [1]. This approach was
> abandoned because a notification on the queue may block datfrozenxid
> advance and clog truncation which can cause other issues for the users [2].
Well, I think that this is the right solution for backpatching, and that
you were wrong to abandon it. You can continue to design a better
mechanism for the master branch, but in old branches we cannot really do
all those things you're proposing to do.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Cómo ponemos nuestros dedos en la arcilla del otro. Eso es la amistad; jugar
al alfarero y ver qué formas se pueden sacar del otro" (C. Halloway en
La Feria de las Tinieblas, R. Bradbury)
