On Mon, Aug 4, 2025 at 12:48 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
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.
template1 needs to be regularly vacuumed?
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
