diff options
| author | Bruce Momjian <bruce@momjian.us> | 2023-10-27 21:24:55 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2023-10-27 21:24:55 -0400 |
| commit | 05ce730978c9ee2d48599ffeaada98f69bd3be42 (patch) | |
| tree | 4daf4893aabebf9cc55402f24cecc7f2939fd031 | |
| parent | eb544d7fd966ce8718573ffeb17dfe6d0952e642 (diff) | |
| download | postgresql-05ce730978c9ee2d48599ffeaada98f69bd3be42.tar.gz postgresql-05ce730978c9ee2d48599ffeaada98f69bd3be42.zip | |
doc: improve text around consistency of statistics values
Discussion: https://postgr.es/m/CAKFQuwZ4CXtTyR19vFbd9WwmW-4BvgAenmF2CfUpx0LWwRPGYg@mail.gmail.com
Author: David G. Johnston
Backpatch-through: master
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index 9389eef973d..2bfa05b8bc0 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -924,10 +924,9 @@ vacuum insert threshold = vacuum base insert threshold + vacuum insert scale fac <xref linkend="reloption-autovacuum-freeze-min-age"/> as this may allow tuples to be frozen by earlier vacuums. The number of obsolete tuples and the number of inserted tuples are obtained from the cumulative statistics system; - it is a semi-accurate count updated by each <command>UPDATE</command>, - <command>DELETE</command> and <command>INSERT</command> operation. (It is - only semi-accurate because some information might be lost under heavy - load.) If the <structfield>relfrozenxid</structfield> value of the table + it is an eventually-consistent count updated by each <command>UPDATE</command>, + <command>DELETE</command> and <command>INSERT</command> operation. + If the <structfield>relfrozenxid</structfield> value of the table is more than <varname>vacuum_freeze_table_age</varname> transactions old, an aggressive vacuum is performed to freeze old tuples and advance <structfield>relfrozenxid</structfield>; otherwise, only pages that have been modified |