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
