From: =?Windows-1252?Q?Gabriel_Guillem_Barcel=F3_Soteras?=
	<gbarcelo@parlamentib.es>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instance
Thread-Topic: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instance
Thread-Index: AQHchGJXKjS2rQK4KU+5eKwTs92Tzg==
Date: Tue, 13 Jan 2026 08:19:02 +0000
Message-ID: 
 <DU0PR08MB79216D7A1EBC77E66899D508A68EA@DU0PR08MB7921.eurprd08.prod.outlook.com>
Accept-Language: es-ES, en-GB, en-US
Content-Language: en-GB
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?Windows-1252?Q?jP7rxLgHM2SYuSnHjDgC9V8b+5+iBkr7MhB1wNoJedV6e/YD2kdOo5lx?=
 =?Windows-1252?Q?BQgasHj65SluaO20bGP1X+zcgotpn/KhI+CnF8UauMOdRgBv94a20Qgj?=
 =?Windows-1252?Q?KnJ84eBoImK4BP8SVNuLJuKcxNchYVbQQDaV4i/3g04trtPyVqhCmL17?=
 =?Windows-1252?Q?+8f1V53r1q+sZ7yAu6s7Tib72XwCK4xcOQif7yw2+sID3dgtx5WufHca?=
 =?Windows-1252?Q?kse+P7CfWiKzFpQU4qmG9SM7f2Ep4yKcnOdWxoEV+um5lfZkcJckDB5X?=
 =?Windows-1252?Q?l0zfNYxgbJYWGbFQvrT4AFwqtFb7FB5P8ypR0dWhCLyho2wuh5eBSruy?=
 =?Windows-1252?Q?KGtthQ17Gc0W574LLcLJZUAuEcB0Xfymd9tm5oTozJF4JXnpkR1UKvYW?=
 =?Windows-1252?Q?lrtObs9s422skEmhvHNzbNwZYI4PSpP9U0C62P4MAX1awSEQiDl8nizB?=
 =?Windows-1252?Q?DmkfLxpGGw4uQg47rDANKb0IFhJAfyfUfqcYN5qkgxozn8E8B5Z/gT07?=
 =?Windows-1252?Q?fS1vP7pwsz2Ju3DYjUHXkbFa9ZzWr31qNt+yRntH9v095BJsPBnm27cK?=
 =?Windows-1252?Q?Ka6KaYzgbA7jpxTFcuhUYJt8mdBWorMb7yqsnB7yWS5Imf7qTb1Fsq7w?=
 =?Windows-1252?Q?277bhQWh5L32BuX3/OBhbFZq6s3vapvRJIUXc/U9V1ojXUoCTNB/gfJb?=
 =?Windows-1252?Q?GszBlappbg05BNo2TgDA53XzHCBQ6fCSv3gQqIOHbTwW+hf3Z/81tZMx?=
 =?Windows-1252?Q?vdoy7JkvWVDswtPQ0WtTHg2FTKBcE7ffogHJidplmlsWpN1NZxUCpOYs?=
 =?Windows-1252?Q?YAoeqaXKS2TUT9xu7Fpy9/Vnx9OAJkVXRuRPGgtOJBmtcoy3RhD+8QU+?=
 =?Windows-1252?Q?2YBm/9NKEqkBWUGZDjPfuAiqEYd/KjWm+hANAt+EOu3NoIT3tlqOgXRl?=
 =?Windows-1252?Q?qrctbKEY0P1l+EAuZ1EI6bq7nxHTW36KF5r4c4QywLWixcQgyuj0rnlk?=
 =?Windows-1252?Q?3iGpE+Wg7i0wRQPWjDblC2kXs6PRykoEJ1G18GtGP0z1/Xt+AtocWMML?=
 =?Windows-1252?Q?fJ1cQ5GDwCIlj2DNNoh/ytQpsDpsQGG0wDo+i423kawRza/RAXcnysvo?=
 =?Windows-1252?Q?+dtBAyjoENtiAVhmkZ7WmsTR1CvJsvEZ4gYl1xZyk4LhOXYQpcX1jhcz?=
 =?Windows-1252?Q?jwRdF82eULDVvbAkOXmH0mcyKE9TXUzXZeY7X+MBREZMYOTBF6cxUtKQ?=
 =?Windows-1252?Q?J9oo5JjoxNphqix8RZYdGKkqrWBmDPA70I4CPJq2TRryNQEQRZDeIq8M?=
 =?Windows-1252?Q?tkoLKAMJMQ8YEV5I3kuGTNZEVm4hNhHVwPqeMuFKRmm2GPMWeGzlGjhG?=
 =?Windows-1252?Q?qIZfqXe1SqpApaMWV0TvtnnGaZNOxKlCqde+O718iQo0qy6COZgYrAhc?=
 =?Windows-1252?Q?cF0SAd9vGNc0AxXmdmS5DG5hXQSqsrmp57VG18tH3sd/ZSbbKj477j89?=
 =?Windows-1252?Q?0t0eKvL8IshokdndKsHpSgDE9o7AYrPXRfAbVIbmDRznSgI/3yPX/qxN?=
 =?Windows-1252?Q?g65BRZyc82plzcCXWDGIW/VRfZePxWfdm4xp/IPPFztIxkEPDMgyHi58?=
 =?Windows-1252?Q?a94DjubBq7vbj1WwwIYDV2LPZETsvn6f2RVIPXtMj2XETguEcEL1V4QN?=
 =?Windows-1252?Q?38Mx5xIiKMwKp0uqbOWTFDz2E8NuY8nrDlwckGD/vx93CdA1pe/KkJzc?=
 =?Windows-1252?Q?VJBvgAixjqM9wwwmfOaOyvyG1WQgvDN2Yxdn0RchiLPjpmkIUFBVCeny?=
 =?Windows-1252?Q?bqUQB3HRufvwvwrZjpRTGjdzu6kGnd0rtx54IdolGWizVIrml9CEIfio?=
 =?Windows-1252?Q?3e8uiecmsqCcF1A4Qh5ZilRiyFkKi28ngyo=3D?=
Content-Type: multipart/alternative;
	boundary="_000_DU0PR08MB79216D7A1EBC77E66899D508A68EADU0PR08MB7921eurp_"
MIME-Version: 1.0
X-OriginatorOrg: parlamentib.es
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DU0PR08MB7921.eurprd08.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 11434f22-57d3-44c7-9f97-08de527c6912
X-MS-Exchange-CrossTenant-originalarrivaltime: 13 Jan 2026 08:19:02.5375
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: eb8f8b70-f944-47bc-a844-e35b86fd8b5f
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 EMkJJAhOLcdGdoFkkaOYqHxdDnk0K8HFCEsbcAvyOqpFo6NzmKi6Ix76B2GaSNp1naM3dWue8z7gGzL6U+4Bxw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB3PR08MB9057
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/DU0PR08MB79216D7A1EBC77E66899D508A68EA%40DU0PR08MB7921.eurprd08.prod.outlook.com>
Precedence: bulk

--_000_DU0PR08MB79216D7A1EBC77E66899D508A68EADU0PR08MB7921eurp_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi,
We have a healthy PostgreSQL 15 instance (installed from the official Postg=
res repository) running on Red Hat 9. It serves several databases for inter=
nal SMB applications. The environment is stable=97apps perform well, disk u=
sage is fine, and the system is not under heavy load.

After integrating PostgreSQL into our monitoring system, I noticed warnings=
 related to VACUUM and ANALYZE. Some tables have never undergone these main=
tenance operations, or the last run was 30=96200 days ago. These databases =
have very few deletions, and many tables show no growth at all=97typical fo=
r internal SMB apps.
I know this topic comes up often, but should I schedule a monthly VACUUM + =
ANALYZE via a cron or systemd timer, while still keeping autovacuum enabled=
?

We=92re also monitoring table bloat, which is currently under 1%, suggestin=
g that manual intervention may not be necessary and that autovacuum is doin=
g its job when needed.

Thanks for your insights!


-----

Gabriel


--_000_DU0PR08MB79216D7A1EBC77E66899D508A68EADU0PR08MB7921eurp_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
</head>
<body>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
Hi,</div>
<div style=3D"font-family: Aptos, Arial, Helvetica, sans-serif; font-size: =
12pt; color: rgb(0, 0, 0);">
We have a healthy PostgreSQL 15 instance (installed from the official Postg=
res repository) running on Red Hat 9. It serves several databases for inter=
nal SMB applications. The environment is stable=97apps perform well, disk u=
sage is fine, and the system is not
 under heavy load.</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style=3D"font-family: Aptos, Arial, Helvetica, sans-serif; font-size: =
12pt; color: rgb(0, 0, 0);">
After integrating PostgreSQL into our monitoring system, I noticed warnings=
 related to VACUUM and ANALYZE. Some tables have never undergone these main=
tenance operations, or the last run was 30=96200 days ago. These databases =
have very few deletions, and many
 tables show no growth at all=97typical for internal SMB apps.</div>
<div style=3D"font-family: Aptos, Arial, Helvetica, sans-serif; font-size: =
12pt; color: rgb(0, 0, 0);">
I know this topic comes up often, but should I schedule a monthly VACUUM + =
ANALYZE via a cron or systemd timer, while still keeping autovacuum enabled=
?</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style=3D"font-family: Aptos, Arial, Helvetica, sans-serif; font-size: =
12pt; color: rgb(0, 0, 0);">
We=92re also monitoring table bloat, which is currently under 1%, suggestin=
g that manual intervention may not be necessary and that autovacuum is doin=
g its job when needed.</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style=3D"font-family: Aptos, Arial, Helvetica, sans-serif; font-size: =
12pt; color: rgb(0, 0, 0);">
Thanks for your insights!</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div dir=3D"ltr" style=3D"font-family: Aptos, Arial, Helvetica, sans-serif;=
 font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div id=3D"ms-outlook-mobile-signature" style=3D"color: inherit; background=
-color: inherit;">
<p style=3D"margin: 0cm; font-family: Calibri, sans-serif; font-size: 11pt;=
"><span style=3D"font-family: &quot;Courier New&quot;;">-----</span></p>
<p style=3D"margin: 0cm; font-family: Calibri, sans-serif; font-size: 11pt;=
"><span style=3D"font-family: &quot;Courier New&quot;;">Gabriel&nbsp;</span=
></p>
<p style=3D"margin: 0cm; font-family: Calibri, sans-serif; font-size: 11pt;=
"><span style=3D"font-family: &quot;Courier New&quot;;"><br>
</span></p>
<p style=3D"margin: 0cm; font-family: Calibri, sans-serif; font-size: 11pt;=
">&nbsp;</p>
</div>
</body>
</html>

--_000_DU0PR08MB79216D7A1EBC77E66899D508A68EADU0PR08MB7921eurp_--