0001-sami_doc_fix.patch
application/octet-stream
Filename: 0001-sami_doc_fix.patch
Type: application/octet-stream
Part: 0
Message:
Re: Add pg_stat_autovacuum_priority
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch 0001
Subject: sami_doc_fix
| File | + | − |
|---|---|---|
| doc/src/sgml/monitoring.sgml | 9 | 19 |
From 0fe7be2e0c4d970d0ec21af007d600c5bb94d904 Mon Sep 17 00:00:00 2001
From: Sami Imseih <samimseih@gmail.com>
Date: Sat, 4 Apr 2026 13:08:04 +0000
Subject: [PATCH 1/1] sami_doc_fix
---
doc/src/sgml/monitoring.sgml | 28 +++++++++-------------------
1 file changed, 9 insertions(+), 19 deletions(-)
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml
index 34e3051c400..47ed7768345 100644
--- a/doc/src/sgml/monitoring.sgml
+++ b/doc/src/sgml/monitoring.sgml
@@ -4522,7 +4522,9 @@ description | Waiting for a newly initialized WAL file to reach durable storage
<para>
The <structname>pg_stat_autovacuum_scores</structname> view will contain one
row for each table in the current database (including TOAST tables), showing
- the current autovacuum scores for that specific table. See
+ the current autovacuum scores for that specific table. Tables eligible for
+ autovacuum are prioritized for processing based on their score, with higher
+ scores indicating higher priority. See
<xref linkend="autovacuum-priority"/> for more information.
</para>
@@ -4574,11 +4576,7 @@ description | Waiting for a newly initialized WAL file to reach durable storage
</para>
<para>
Maximum value of all component scores. This is the value that
- autovacuum uses to sort the list of tables to process. Scores greater
- than or equal to <literal>1.0</literal> indicate the table will be
- processed (unless autovacuum is disabled and neither
- <literal>xid_score</literal> nor <literal>mxid_score</literal> are
- greater than or equal to <literal>1.0</literal>).
+ autovacuum uses to sort the list of tables to process.
</para></entry>
</row>
@@ -4587,8 +4585,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
- <literal>1.0</literal> indicate the table will be vacuumed.
+ Transaction ID age component score.
</para></entry>
</row>
@@ -4597,8 +4594,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
- <literal>1.0</literal> indicate the table will be vacuumed.
+ Multixact ID age component score.
</para></entry>
</row>
@@ -4607,9 +4603,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
- <literal>1.0</literal> indicate the table will be vacuumed (unless
- autovacuum is disabled).
+ Vacuum component score.
</para></entry>
</row>
@@ -4618,9 +4612,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
- <literal>1.0</literal> indicate the table will be vacuumed (unless
- autovacuum is disabled).
+ Vacuum insert component score.
</para></entry>
</row>
@@ -4629,9 +4621,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
- <literal>1.0</literal> indicate the table will be analyzed (unless
- autovacuum is disabled).
+ Analyze component score.
</para></entry>
</row>
</tbody>
--
2.50.1