From: =?Windows-1252?Q?Gabriel_Guillem_Barcel=F3_Soteras?=
	<gbarcelo@parlamentib.es>
To: "rmeyer@sevroconsulting.com" <rmeyer@sevroconsulting.com>
CC: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instance
Thread-Topic: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instance
Thread-Index: AQHchGJXKjS2rQK4KU+5eKwTs92TzrVQWtAAgAABBACAAO3LUw==
Date: Wed, 14 Jan 2026 07:42:16 +0000
Message-ID: 
 <DU0PR08MB79213FAA21D2EA1C915529C2A68FA@DU0PR08MB7921.eurprd08.prod.outlook.com>
References: 
 <DU0PR08MB79216D7A1EBC77E66899D508A68EA@DU0PR08MB7921.eurprd08.prod.outlook.com>
 <002034bdb202a87b97de38648b0e35d8ac6db0ac.camel@cybertec.at>
 <0225023895511123aac84ea16daa1363@sevroconsulting.com>
In-Reply-To: <0225023895511123aac84ea16daa1363@sevroconsulting.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?aY9uRg5X7CCq/X/1OvbrjgktfkI9wUefrfSjcvRpyMD/JT0NHvrHb7MU?=
 =?Windows-1252?Q?xA0x8Igo4o9Ve8j08xboIqEu1W3sZtDxKjUojPDEtHzgRZfBTXEK7Qhz?=
 =?Windows-1252?Q?Opfg1Qn5IdKL9/8UZzcwogaRFZvHirhtQJJNMDBZ0a1Rc/V+IbmQA66m?=
 =?Windows-1252?Q?bRuExbIX34wcXYpWwlVzdIkfmf78j3Efb0FDJIg3cx81gSnvcQQGX9Wi?=
 =?Windows-1252?Q?uIYkRCPg5l7+Iz9OSuQ9UX2sO92MN7qQQ4nYKcnDYGMI6mgD0gyuXCrP?=
 =?Windows-1252?Q?BWbAXyuKD8mQNYZ2frCDkYC8MJ2pM0cUeT2Ricb0Ua3raLeSYSnxFyDC?=
 =?Windows-1252?Q?7obfZYyHTtV+c0fOfDbU5wrpH1MmGvUwoDRlY97XhIlDT7RxDAq9VNqN?=
 =?Windows-1252?Q?ahtVbBhP2exn79ocyrUCZSp6n7Hjlt6ZAIMClz6lTFzn9KhVhZ+uQq9q?=
 =?Windows-1252?Q?YkaHY0GoFb0905/orD7Mn/qC82MGbs1D9YPzFMj7kIhaAj2j69/r+Euw?=
 =?Windows-1252?Q?YXa8TTXszmfS6TOiVpCmVsZa4CesAYj6RpyumYzlhJnTHyKTRe/Xdd8y?=
 =?Windows-1252?Q?h9dknF6TP/+9bGqSPBh74SboInQBh8OONPEA1xvzrGRh0H6zNhBT/8iV?=
 =?Windows-1252?Q?BW1EY1hTF1aGXcmp+L03iVHrGhNJi7H3Y0N2XhFhQPrwEIQdb8yWDb1i?=
 =?Windows-1252?Q?PnW77jShrBjA0PLDYHuoaO5ZeeKbdoeDp79LgkTtDTa2qp0FKCR83rsG?=
 =?Windows-1252?Q?tmtTa40T0KuxWzRxWwoIF0oXNIXimz1uoQr+Awuh/JsYgjIn7MmpyTkw?=
 =?Windows-1252?Q?o2k5o6xx+eB0epqiFFUD4AgK5TubLhmSrtANsWnh9IxyO1HolIXr5xpu?=
 =?Windows-1252?Q?u+w6vhfp+CmtbtaQv+iDn2Mzw2rn5YhFIKV0wo9ErDvKBk1yD9Xwt3Dq?=
 =?Windows-1252?Q?0YNUiMJMz1V3X1HflpPBHjJTiy9x/PU+ZjPijrG0WWEc5g8YO4U/qQpR?=
 =?Windows-1252?Q?51szL72GZHHsOe1lXI9pt1SDnxX/JNNH06O4YEfBLlXobOC0QoZoJqyY?=
 =?Windows-1252?Q?AcS1VFdBrCQ5eJCWlsoofVsgVG/oHhUVkWjhEstSiaswxzFqGKwbH93A?=
 =?Windows-1252?Q?K8C5bq9V8Yc0XKS8uXX063+UD7krfObzgMjo1s07GE5kBcqwXdUCDUeR?=
 =?Windows-1252?Q?n0aNBVd/UechwOIf/ImYO6P6TMzo/5GZLBH+yU7aWWO5497kLjWhIvj/?=
 =?Windows-1252?Q?i4oYKanSACZxRYr8c8n4KT9+Ui7lgzESpqEJ5DJUxdLKbPybjabXUvED?=
 =?Windows-1252?Q?tKGz3j2H5+BJUoIPmM6rqYITy2ye8PquwWCnag1StVoLlN0S66NyIe0k?=
 =?Windows-1252?Q?aT4igjO6mysMHzM+m2DnCkJoTwPj9za65O6DQSnNkm/XhNl7Jb1+o7ly?=
 =?Windows-1252?Q?irfYPWi2RHoSYpf/akCY+LgqpR2xu/u7m7N0X23s6mWkPXASYRUYyUhf?=
 =?Windows-1252?Q?/BHogmW+Bz4QwyjNhLlWFPh2K7K8Qufg8htXm2SBwQF0Gk8oYmMKzwye?=
 =?Windows-1252?Q?a9H+RBTm/0uAwIuAbqN2CP4m6vsI8/daNKduDwbQJ5ELpT+uK/2MaDiO?=
 =?Windows-1252?Q?pdJWOOXzp/JEfR4uRXiyh52iZcTup4EEbERlFH/bgYzbH2fFnS0SYfVY?=
 =?Windows-1252?Q?pCtxTlnZOcbV/W0V8CxOj9dphLQPs5sRncUvXIaUAPOevFfBlCB5hFEu?=
 =?Windows-1252?Q?gNhrO9lEc3xy7b2kIiH8vCr3PaqN8u2vme7swQQe1niKpNcJFDEe3aEZ?=
 =?Windows-1252?Q?7dTo0Qpa3vt0zy3Dh//3M+qw6Tr1mf88Ea7Z2Gfo8NTd51D+knmKlC9q?=
 =?Windows-1252?Q?6kx/IlcLRnchX4EhYyyda6lP0aN22R+MFHM=3D?=
Content-Type: multipart/alternative;
	boundary="_000_DU0PR08MB79213FAA21D2EA1C915529C2A68FADU0PR08MB7921eurp_"
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: 
 7207af83-3fc5-4b2c-8898-08de534070a5
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Jan 2026 07:42:16.5618
 (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: 
 lfbdtKOZAKp8/4gZSU2fectucZc+EoV+HWJ1MEVQRqRKZDLsgPNfN6GrYPmii+y4yX5tVDTq6k/2H2deY3pLMA==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB3PR08MB8890
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/DU0PR08MB79213FAA21D2EA1C915529C2A68FA%40DU0PR08MB7921.eurprd08.prod.outlook.com>
Precedence: bulk

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

https://www.pgadmin.org/support/list/

Go to PGLister Management link...

From: Rich Meyer <rmeyer@sevroconsulting.com>
Date: Tuesday, 13 January 2026 at 18:30
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Gabriel Guillem Barcel=F3 Soteras <gbarcelo@parlamentib.es>, Pgsql-admi=
n <pgsql-admin@lists.postgresql.org>
Subject: Re: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 Instanc=
e


Hi, sorry about this but I cannot for the life of me unsubscribe from these=
 emails. Can anyone help?


---
Rich Meyer
Sevro Consulting
rmeyer@sevroconsulting.com<mailto:rmeyer@sevroconsulting.com>
732-991-6249


On 2026-01-13 12:26 pm, Laurenz Albe wrote:

On Tue, 2026-01-13 at 08:19 +0000, Gabriel Guillem Barcel=F3 Soteras wrote:
We have a healthy PostgreSQL 15 instance (installed from the official Postg=
res repository)
running on Red Hat 9. It serves several databases for internal SMB applicat=
ions.
The environment is stable=97apps 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=96200 days ago. These databases have very few deletions, and many ta=
bles show no growth
at all=97typical 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=92re also monitoring table bloat, which is currently under 1%, suggestin=
g that manual
intervention may not be necessary and that autovacuum is doing its job when=
 needed.

I'd call this a false positive warning from the monitoring system, and ther=
e is nothing
you have to do except to disable this test.  It is perfectly healthy for a =
table with
few updates and deletes to ve autovacuumed very rarely.

What you should monitor is

a) whether pg_stat_all.tables.n_dead_tup is much more than 0.2 * pg_class.r=
eltuples + 50
   (that would indicate that autovacuum doesn't trigger, is too slow or can=
not make any
   progress owing to long-running transactions)

b) whether age(pg_class.relfrozenxid) exceeds 300 million
   (that would indicate a problem with anti-wraparound autovacuum)

Yours,
Laurenz Albe


--_000_DU0PR08MB79213FAA21D2EA1C915529C2A68FADU0PR08MB7921eurp_
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);">
<a href=3D"https://www.pgadmin.org/support/list/" data-outlook-id=3D"68d63e=
09-82ff-4548-a70d-d3e2cebe675c">https://www.pgadmin.org/support/list/</a></=
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);">
Go to PGLister Management link...</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"mail-editor-reference-message-container" style=3D"color: inherit=
; background-color: inherit;">
<div dir=3D"ltr" class=3D"ms-outlook-mobile-reference-message skipProofing"=
></div>
<div class=3D"ms-outlook-mobile-reference-message skipProofing" style=3D"te=
xt-align: left; padding: 3pt 0in 0in; border-width: 1pt medium medium; bord=
er-style: solid none none; border-color: rgb(181, 196, 223) currentcolor cu=
rrentcolor; font-family: Aptos; font-size: 12pt; color: black;">
<b>From: </b>Rich Meyer &lt;rmeyer@sevroconsulting.com&gt;<br>
<b>Date: </b>Tuesday, 13 January 2026 at 18:30<br>
<b>To: </b>Laurenz Albe &lt;laurenz.albe@cybertec.at&gt;<br>
<b>Cc: </b>Gabriel Guillem Barcel=F3 Soteras &lt;gbarcelo@parlamentib.es&gt=
;, Pgsql-admin &lt;pgsql-admin@lists.postgresql.org&gt;<br>
<b>Subject: </b>Re: VACUUM/ANALYZE Strategy for Low-Activity PostgreSQL 15 =
Instance<br>
<br>
</div>
<p class=3D"ms-outlook-mobile-reference-message skipProofing">Hi, sorry abo=
ut this but I cannot for the life of me unsubscribe from these emails. Can =
anyone help?<br>
<br>
<br>
</p>
<div id=3D"signature" style=3D"color: inherit; background-color: inherit;">=
---<br>
<div class=3D"pre" style=3D"margin: 0px; font-family: monospace;">Rich Meye=
r<br>
Sevro Consulting<br>
<a href=3D"mailto:rmeyer@sevroconsulting.com" data-outlook-id=3D"a5659ad6-d=
05e-42b1-a4bd-e179af8ffc73">rmeyer@sevroconsulting.com</a><br>
732-991-6249</div>
</div>
<div dir=3D"ltr" class=3D"ms-outlook-mobile-reference-message skipProofing"=
><br>
</div>
<p class=3D"ms-outlook-mobile-reference-message skipProofing" id=3D"reply-i=
ntro">On 2026-01-13 12:26 pm, Laurenz Albe wrote:</p>
<blockquote style=3D"margin: 0px; padding-right: 0.4em; padding-left: 0.4em=
; border-left-width: 2px; border-left-style: solid; border-left-color: rgb(=
16, 16, 255);">
<div class=3D"pre" style=3D"margin: 0px; font-family: monospace;">On Tue, 2=
026-01-13 at 08:19 +0000, Gabriel Guillem Barcel=F3 Soteras wrote:</div>
<blockquote style=3D"margin: 0px; padding-right: 0.4em; padding-left: 0.4em=
; border-left-width: 2px; border-left-style: solid; border-left-color: rgb(=
16, 16, 255);">
<div class=3D"pre" style=3D"font-family: monospace;">We have a healthy Post=
greSQL 15 instance (installed from the official Postgres repository)<br>
running on Red Hat 9. It serves several databases for internal SMB applicat=
ions.<br>
The environment is stable=97apps perform well, disk usage is fine, and the =
system is not<br>
under heavy load.<br>
<br>
After integrating PostgreSQL into our monitoring system, I noticed warnings=
 related to VACUUM<br>
and ANALYZE. Some tables have never undergone these maintenance operations,=
 or the last run<br>
was 30=96200 days ago. These databases have very few deletions, and many ta=
bles show no growth<br>
at all=97typical for internal SMB apps.<br>
I know this topic comes up often, but should I schedule a monthly VACUUM + =
ANALYZE via a cron<br>
or systemd timer, while still keeping autovacuum enabled?<br>
<br>
We=92re also monitoring table bloat, which is currently under 1%, suggestin=
g that manual<br>
intervention may not be necessary and that autovacuum is doing its job when=
 needed.</div>
</blockquote>
<div class=3D"pre" style=3D"margin-right: 0px; margin-left: 0px; font-famil=
y: monospace;">
<br>
I'd call this a false positive warning from the monitoring system, and ther=
e is nothing<br>
you have to do except to disable this test. &nbsp;It is perfectly healthy f=
or a table with<br>
few updates and deletes to ve autovacuumed very rarely.<br>
<br>
What you should monitor is<br>
<br>
a) whether pg_stat_all.tables.n_dead_tup is much more than 0.2 * pg_class.r=
eltuples + 50<br>
&nbsp; &nbsp;(that would indicate that autovacuum doesn't trigger, is too s=
low or cannot make any<br>
&nbsp; &nbsp;progress owing to long-running transactions)<br>
<br>
b) whether age(pg_class.relfrozenxid) exceeds 300 million<br>
&nbsp; &nbsp;(that would indicate a problem with anti-wraparound autovacuum=
)<br>
<br>
Yours,<br>
Laurenz Albe<br>
<br>
<br>
</div>
</blockquote>
</div>
</body>
</html>

--_000_DU0PR08MB79213FAA21D2EA1C915529C2A68FADU0PR08MB7921eurp_--