On Mon, Mar 29, 2021 at 11:14 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote: > > 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". Thanks, but this is exactly my point: since inactive databases are getting older, why it appears to me that autovacuum is not freezing them? I mean, in my experiment age( datfrozenzid) reports the same age for every database, even the inactive ones. And since there were inactive databases, I was expecting emergency autovacuum to be able to run and freeze them. Or am I wrong? Luca
