v1-0001-Doc-fix-of-aggressive-vacuum-threshold-for-multix.patch
application/octet-stream
Filename: v1-0001-Doc-fix-of-aggressive-vacuum-threshold-for-multix.patch
Type: application/octet-stream
Part: 0
Patch
Format: format-patch
Series: patch v1-0001
Subject: Doc fix of aggressive vacuum threshold for multixact members storage.
| File | + | − |
|---|---|---|
| doc/src/sgml/maintenance.sgml | 3 | 3 |
From 76fd2c2bb3b8aa7aad6990f28f8e235ca11d7327 Mon Sep 17 00:00:00 2001
From: Alex Friedman <alexf01@gmail.com>
Date: Thu, 30 Jan 2025 17:19:07 +0200
Subject: [PATCH v1] Doc fix of aggressive vacuum threshold for multixact
members storage.
---
doc/src/sgml/maintenance.sgml | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml
index 0be90bdc7ef..0039343e7da 100644
--- a/doc/src/sgml/maintenance.sgml
+++ b/doc/src/sgml/maintenance.sgml
@@ -792,9 +792,9 @@ HINT: Execute a database-wide VACUUM in that database.
<para>
As a safety device, an aggressive vacuum scan will
occur for any table whose multixact-age is greater than <xref
- linkend="guc-autovacuum-multixact-freeze-max-age"/>. Also, if the
- storage occupied by multixacts members exceeds 2GB, aggressive vacuum
- scans will occur more often for all tables, starting with those that
+ linkend="guc-autovacuum-multixact-freeze-max-age"/>. Also, if the storage occupied
+ by multixacts members exceeds about 10GB (50% of the maximum, which is about 20GB),
+ aggressive vacuum scans will occur more often for all tables, starting with those that
have the oldest multixact-age. Both of these kinds of aggressive
scans will occur even if autovacuum is nominally disabled.
</para>
--
2.41.0