public inbox for [email protected]help / color / mirror / Atom feed
Vacuuming System DBs like postgres, template1 3+ messages / 3 participants [nested] [flat]
* Vacuuming System DBs like postgres, template1 @ 2025-08-04 03:45 OMPRAKASH SAHU <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: OMPRAKASH SAHU @ 2025-08-04 03:45 UTC (permalink / raw) To: [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Vacuuming System DBs like postgres, template1 @ 2025-08-04 04:47 David G. Johnston <[email protected]> parent: OMPRAKASH SAHU <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: David G. Johnston @ 2025-08-04 04:47 UTC (permalink / raw) To: OMPRAKASH SAHU <[email protected]>; +Cc: [email protected] On Sun, Aug 3, 2025 at 8:45 PM OMPRAKASH SAHU <[email protected]> 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. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Vacuuming System DBs like postgres, template1 @ 2025-08-04 05:53 Ron Johnson <[email protected]> parent: David G. Johnston <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Ron Johnson @ 2025-08-04 05:53 UTC (permalink / raw) To: Pgsql-admin <[email protected]> On Mon, Aug 4, 2025 at 12:48 AM David G. Johnston < [email protected]> wrote: > On Sun, Aug 3, 2025 at 8:45 PM OMPRAKASH SAHU <[email protected]> > 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! ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-08-04 05:53 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-08-04 03:45 Vacuuming System DBs like postgres, template1 OMPRAKASH SAHU <[email protected]> 2025-08-04 04:47 ` David G. Johnston <[email protected]> 2025-08-04 05:53 ` Ron Johnson <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox