| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Vacuuming System DBs like postgres, template1 |
| Date: | 2025-08-04 05:53:12 |
| Message-ID: | CANzqJaDC0SP+u_MtXa5fxNxA=0DmAjgQzioeM6c=+WKMzjxX0w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Aug 4, 2025 at 12:48 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> 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.
>
template1 needs to be regularly vacuumed?
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ramakrishna Reddy Nandyala | 2025-08-04 16:09:58 | Clearing of temp files is very slow in pg16 |
| Previous Message | David G. Johnston | 2025-08-04 05:35:13 | Re: Indexing Strategy for Partitioned Table in PostgreSQL 15.13 |