diff options
author | Kevin Grittner <kgrittn@postgresql.org> | 2012-09-16 12:20:35 -0500 |
---|---|---|
committer | Kevin Grittner <kgrittn@postgresql.org> | 2012-09-16 12:20:35 -0500 |
commit | 5752e1bbb2d9f553fd6211fbb47ab2b240d740f0 (patch) | |
tree | 2ec59dd8bf164275fd56bb964babdcb3fcd96902 | |
parent | 87802a12d7706221a46961b1def076c5fc99e46e (diff) | |
download | postgresql-5752e1bbb2d9f553fd6211fbb47ab2b240d740f0.tar.gz postgresql-5752e1bbb2d9f553fd6211fbb47ab2b240d740f0.zip |
Fix documentation reference to maximum allowed for autovacuum_freeze_max_age.
The documentation mentioned setting autovacuum_freeze_max_age to
"its maximum allowed value of a little less than two billion".
This led to a post asking about the exact maximum allowed value,
which is precisely two billion, not "a little less".
Based on question by Radovan Jablonovsky. Backpatch to 8.3.
-rw-r--r-- | doc/src/sgml/maintenance.sgml | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index 03cc6c987a2..adb9498578a 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -450,8 +450,8 @@ will take more space, because it must store the commit status of all transactions back to the <varname>autovacuum_freeze_max_age</> horizon. The commit status uses two bits per transaction, so if - <varname>autovacuum_freeze_max_age</> is set to its maximum allowed value of - a little less than two billion, <filename>pg_clog</> can be expected to + <varname>autovacuum_freeze_max_age</> is set to its maximum allowed + value of two billion, <filename>pg_clog</> can be expected to grow to about half a gigabyte. If this is trivial compared to your total database size, setting <varname>autovacuum_freeze_max_age</> to its maximum allowed value is recommended. Otherwise, set it depending |