diff options
| author | Bruce Momjian <bruce@momjian.us> | 2021-07-02 18:00:30 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2021-07-02 18:00:30 -0400 |
| commit | c552e171d16e461c7af60cfe1a891c87be9cbbbf (patch) | |
| tree | 64d07960536ed81c7100ab1fa53a10d25991b275 | |
| parent | 50371df266d4c8f4faaf448cbd789d9697443952 (diff) | |
| download | postgresql-c552e171d16e461c7af60cfe1a891c87be9cbbbf.tar.gz postgresql-c552e171d16e461c7af60cfe1a891c87be9cbbbf.zip | |
docs: clarify new aggressive vacuum mode for multi-xacts
Reported-by: eric.mutta@gmail.com
Discussion: https://postgr.es/m/162395467510.686.11947486273299446208@wrigleys.postgresql.org
Backpatch-through: 14
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index 4b535809b63..998a48fc257 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -697,14 +697,14 @@ HINT: Stop the postmaster and vacuum that database in single-user mode. </para> <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"/>. Aggressive - vacuum scans will also occur progressively for all tables, starting with - those that have the oldest multixact-age, if the amount of used member - storage space exceeds the amount 50% of the addressable storage space. - Both of these kinds of aggressive scans will occur even if autovacuum is - nominally disabled. + As a safety device, an aggressive vacuum scan will + occur for any table whose multixact-age (see <xref + linkend="vacuum-for-multixact-wraparound"/>) 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 + have the oldest multixact-age. Both of these kinds of aggressive + scans will occur even if autovacuum is nominally disabled. </para> </sect3> </sect2> |