template0 is having high age of datforzenxid

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: template0 is having high age of datforzenxid
Date: 2019-04-02 22:35:53
Message-ID: CAGoODpfKeo-kPr3M5hFbkYJu29dz_nx-rXkDyBKod7E_XVMZQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am running Postgresql 10 where I can see the template0 database is having
longest datfrozenxid:
```db_name age_of_datfrozenxid
--------------------------------------
postgres 251365
template1 234574
template0 75366462
db1 253097
db2 250649
db3 250649
db4 14641
db5 14214```

Initially I had high age for all the databases and I ran "vacuum freeze"
which brought down the age of other databases. But how can I do the same
for template0?
Please advise.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2019-04-03 00:20:36 Re: template0 is having high age of datforzenxid
Previous Message Andres Freund 2019-04-02 21:50:21 Re: New LLVM JIT Features