Re: Vacuuming System DBs like postgres, template1 - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Vacuuming System DBs like postgres, template1
Date
Msg-id CANzqJaDC0SP+u_MtXa5fxNxA=0DmAjgQzioeM6c=+WKMzjxX0w@mail.gmail.com
Whole thread Raw
In response to Re: Vacuuming System DBs like postgres, template1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
On Mon, Aug 4, 2025 at 12:48 AM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sun, Aug 3, 2025 at 8:45 PM OMPRAKASH SAHU <sahuop2121@gmail.com> 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 also 

So 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.

template1 needs to be regularly vacuumed?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Next
From: Ramakrishna Reddy Nandyala
Date:
Subject: Clearing of temp files is very slow in pg16