Content-Length: 267401 | pFad | http://github.com/postgrespro/postgres/commit/05ce730978c9ee2d48599ffeaada98f69bd3be42

FC doc: improve text around consistency of statistics values · postgrespro/postgres@05ce730 · GitHub
Skip to content

Commit 05ce730

Browse files
committed
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
1 parent eb544d7 commit 05ce730

File tree

1 file changed

+3
-4
lines changed

1 file changed

+3
-4
lines changed

doc/src/sgml/maintenance.sgml

Lines changed: 3 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -924,10 +924,9 @@ vacuum insert threshold = vacuum base insert threshold + vacuum insert scale fac
924924
<xref linkend="reloption-autovacuum-freeze-min-age"/> as this may allow
925925
tuples to be frozen by earlier vacuums. The number of obsolete tuples and
926926
the number of inserted tuples are obtained from the cumulative statistics system;
927-
it is a semi-accurate count updated by each <command>UPDATE</command>,
928-
<command>DELETE</command> and <command>INSERT</command> operation. (It is
929-
only semi-accurate because some information might be lost under heavy
930-
load.) If the <structfield>relfrozenxid</structfield> value of the table
927+
it is an eventually-consistent count updated by each <command>UPDATE</command>,
928+
<command>DELETE</command> and <command>INSERT</command> operation.
929+
If the <structfield>relfrozenxid</structfield> value of the table
931930
is more than <varname>vacuum_freeze_table_age</varname> transactions old,
932931
an aggressive vacuum is performed to freeze old tuples and advance
933932
<structfield>relfrozenxid</structfield>; otherwise, only pages that have been modified

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/05ce730978c9ee2d48599ffeaada98f69bd3be42

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy