On Mon, Mar 29, 2021 at 11:14 AM Laurenz Albe <laurenz.albe@cybertec.at> 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