News for hackers. Stuff that matters.
Re:PostgreSQL 15 by jtc331 on Thursday October 13, 2022 @12:12PM (#33192995)
Isn’t keeping a logical slot alive holding a snapshot?
Re:PostgreSQL 15 by anarazel on Thursday October 13, 2022 @12:33PM (#33193312)
Not normally, no. A real snapshot is held during the initial creation of the logical slot. After that the slot's "catalog xmin" prevents old catalog (but not user table!) row versions from being removed, but that's somewhat different from a snapshot.
Re:PostgreSQL 15 by jeltz on Thursday October 13, 2022 @03:09PM (#33195151)
Exactly. We had to disable some cron jobs which abuse temporary tables (and functions!) to avoid catalog bloat but there were no long lived snapshots on the master during the upgrade.