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)
