On Mon, 2021-03-29 at 10:33 +0200, Luca Ferrari wrote: > Another thing that comes into my mind as a doubt is: why are all > databases becoming old? I mean, I'm provoking activity _only_ on > testdb, therefore other database such as template1 are not doing > anything.
That one I can answer. If there is no activity on a database, its "datfrozenxid" stays the same. So, as transaction IDs are consumed, it is getting older automatically. That means that even inactive databases will receive an anti-wraparound vacuum occasionally. But that should not have to do anything except advance "datfrozenxid". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
