v1-0001-Fix-pg_stat_autovacuum_scores-threshold-wording.patch

From b2e69e6e8afd2c94985df54bea37a346441bb3fd Mon Sep 17 00:00:00 2001
From: "Chao Li (Evan)" <lic@highgo.com>
Date: Thu, 25 Jun 2026 10:31:16 +0800
Subject: [PATCH v1] Fix pg_stat_autovacuum_scores threshold wording

The pg_stat_autovacuum_scores documentation said component scores greater
than or equal to their corresponding weight indicate that autovacuum would
vacuum or analyze the table.

However, autovacuum eligibility uses strict comparisons against the
underlying thresholds. A component score exactly equal to its weight can
therefore still have do_vacuum or do_analyze false.

Update the descriptions to say "greater than" instead.

Author: Chao Li <lic@highgo.com>
Reviewed-by:
Discussion: https://postgr.es/m/
---
 doc/src/sgml/monitoring.sgml | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index 08d5b824552..ac38220c32c 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -4594,7 +4594,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
        <structfield>xid_score</structfield> <type>double precision</type>
       </para>
       <para>
-       Transaction ID age component score.  Scores greater than or equal to
+       Transaction ID age component score.  Scores greater than
        <xref linkend="guc-autovacuum-freeze-score-weight"/> indicate that
        autovacuum would vacuum the table for transaction ID wraparound
        prevention.
@@ -4606,7 +4606,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
        <structfield>mxid_score</structfield> <type>double precision</type>
       </para>
       <para>
-       Multixact ID age component score.  Scores greater than or equal to
+       Multixact ID age component score.  Scores greater than
        <xref linkend="guc-autovacuum-multixact-freeze-score-weight"/> indicate
        that autovacuum would vacuum the table for multixact ID wraparound
        prevention.
@@ -4618,7 +4618,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
        <structfield>vacuum_score</structfield> <type>double precision</type>
       </para>
       <para>
-       Vacuum component score.  Scores greater than or equal to
+       Vacuum component score.  Scores greater than
        <xref linkend="guc-autovacuum-vacuum-score-weight"/> indicate that
        autovacuum would vacuum the table (unless autovacuum is disabled).
       </para></entry>
@@ -4629,7 +4629,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
        <structfield>vacuum_insert_score</structfield> <type>double precision</type>
       </para>
       <para>
-       Vacuum insert component score.  Scores greater than or equal to
+       Vacuum insert component score.  Scores greater than
        <xref linkend="guc-autovacuum-vacuum-insert-score-weight"/> indicate
        that autovacuum would vacuum the table (unless autovacuum is disabled).
       </para></entry>
@@ -4640,7 +4640,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
        <structfield>analyze_score</structfield> <type>double precision</type>
       </para>
       <para>
-       Analyze component score.  Scores greater than or equal to
+       Analyze component score.  Scores greater than
        <xref linkend="guc-autovacuum-analyze-score-weight"/> indicate that
        autovacuum would analyze the table (unless autovacuum is disabled).
       </para></entry>
-- 
2.50.1 (Apple Git-155)