Re: Figuring out the correct age of datfrozenxid

On 2019-Jul-25, Yuri Niyazov wrote:

> all the tables have a very reasonable age, but the database itself still
> has an age approaching two billion. So, what do we do now?

I think vacuuming any table will update the database age.  For instance,
try creating an empty table and do "vacuum freeze" on it.

> Were we wrong to truncate and drop this unneeded table without letting
> a vacuum on it finish?

That seems an appropriate measure to have taken  You just need to have
the system figure out that it's gone.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services