On Sun, Aug 3, 2025 at 8:45 PM OMPRAKASH SAHU <sahuop2121@xxxxxxxxx> wrote:
On few large DBs we run vacuum analyze manually as well, and I do see few people vacuuming the template1 db or postgres db alsoSo just wanted to know vacuum system dbs is required or not?
Pretty sure the answer is yes - though letting auto-vacuum do it is sufficient - since something has to update the catalog column that indicates the oldest transaction the database is aware of. There isn't a value for that which means "everything has been frozen" since it doesn't get updated in the normal course of activity.
David J.
