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
