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