MIME-Version: 1.0
From: OMPRAKASH SAHU <sahuop2121@gmail.com>
Date: Mon, 4 Aug 2025 09:15:08 +0530
Message-ID: 
 <CAOZWJqP0so=CBLXK70u1ibDnstVLmpPjv7YngNv-jxQzJLjv=w@mail.gmail.com>
Subject: Vacuuming System DBs like postgres, template1
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b40914063b81ef0f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOZWJqP0so%3DCBLXK70u1ibDnstVLmpPjv7YngNv-jxQzJLjv%3Dw%40mail.gmail.com>
Precedence: bulk

--000000000000b40914063b81ef0f
Content-Type: text/plain; charset="UTF-8"

Hi Team,

We have multitenant architecture in our postgresql servers where we have
more than 200DBs on every server.

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?

Regards,
OM

--000000000000b40914063b81ef0f
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi Team,<div dir=3D"auto"><br></div><div dir=3D"auto">We =
have multitenant architecture in our postgresql servers where we have more =
than 200DBs on every server.</div><div dir=3D"auto"><br></div><div dir=3D"a=
uto">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=C2=A0</div><div d=
ir=3D"auto"><br></div><div dir=3D"auto">So just wanted to know vacuum syste=
m dbs is required or not?</div><div dir=3D"auto"><br></div><div dir=3D"auto=
">Regards,</div><div dir=3D"auto">OM</div></div>

--000000000000b40914063b81ef0f--