Re: Vacuuming System DBs like postgres, template1
| От | Ron Johnson |
|---|---|
| Тема | Re: Vacuuming System DBs like postgres, template1 |
| Дата | |
| Msg-id | CANzqJaDC0SP+u_MtXa5fxNxA=0DmAjgQzioeM6c=+WKMzjxX0w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Vacuuming System DBs like postgres, template1 ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Список | 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 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!
В списке pgsql-admin по дате отправления: