Re: Vacuuming System DBs like postgres, template1

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: OMPRAKASH SAHU <sahuop2121(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Vacuuming System DBs like postgres, template1
Date: 2025-08-04 04:47:48
Message-ID: CAKFQuwafDdAKdYTWq_aC_=yXgUydCA__Aiim16C=ZT7Cr+M-vg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Aug 3, 2025 at 8:45 PM OMPRAKASH SAHU <sahuop2121(at)gmail(dot)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.

David J.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mahesh Shetty 2025-08-04 05:25:00 Indexing Strategy for Partitioned Table in PostgreSQL 15.13
Previous Message OMPRAKASH SAHU 2025-08-04 03:45:08 Vacuuming System DBs like postgres, template1