VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instance

From: Gabriel Guillem Barceló Soteras <gbarcelo(at)parlamentib(dot)es>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instance
Date: 2026-01-13 08:19:02
Message-ID: DU0PR08MB79216D7A1EBC77E66899D508A68EA@DU0PR08MB7921.eurprd08.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
We have a healthy PostgreSQL 15 instance (installed from the official Postgres repository) running on Red Hat 9. It serves several databases for internal SMB applications. The environment is stable—apps perform well, disk usage 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 maintenance operations, or the last run was 30–200 days ago. These databases have very few deletions, and many tables show no growth at all—typical for 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’re also monitoring table bloat, which is currently under 1%, suggesting that manual intervention may not be necessary and that autovacuum is doing its job when needed.

Thanks for your insights!

-----

Gabriel

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Paul Smith* 2026-01-13 09:39:23 Re: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instance
Previous Message Ron Johnson 2026-01-09 17:53:51 Re: Better way to monitor for failed replication?