On Mon, 2021-03-29 at 16:58 +0200, Luca Ferrari 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?
I didn't follow the rest of the thread, but autovacuum should handle those databases and advance their "datfrozenxid". Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
