From 10cfd6f8544ea658c3d87821ab8525296363bbdf Mon Sep 17 00:00:00 2001 From: Andres Freund Date: Mon, 5 Oct 2015 16:09:13 +0200 Subject: [PATCH] Remove outdated comment about relation level autovacuum freeze limits. The documentation for the autovacuum_multixact_freeze_max_age and autovacuum_freeze_max_age relation level parameters contained: "Note that while you can set autovacuum_multixact_freeze_max_age very small, or even zero, this is usually unwise since it will force frequent vacuuming." which hasn't been true since these options were made relation options, instead of residing in the pg_autovacuum table (834a6da4f7). Remove the outdated sentence. Even the lowered limits from 2596d70 are high enough that this doesn't warrant calling out the risk in the CREATE TABLE docs. Per discussion with Tom Lane and Alvaro Herrera Discussion: 26377.1443105453@sss.pgh.pa.us Backpatch: 9.0- (in parts) --- doc/src/sgml/ref/create_table.sgml | 9 ++------- 1 file changed, 2 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index fac7e1ec5e..a2d0b0cbe1 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1009,9 +1009,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI Custom parameter. Note that autovacuum will ignore attempts to set a per-table autovacuum_freeze_max_age larger than the system-wide setting - (it can only be set smaller). Note that while you can set - autovacuum_freeze_max_age very small, or even zero, this is - usually unwise since it will force frequent vacuuming. + (it can only be set smaller). @@ -1045,10 +1043,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI Custom parameter. Note that autovacuum will ignore attempts to set a per-table autovacuum_multixact_freeze_max_age larger than the - system-wide setting (it can only be set smaller). Note that while you - can set autovacuum_multixact_freeze_max_age very small, - or even zero, this is usually unwise since it will force frequent - vacuuming. + system-wide setting (it can only be set smaller). -- 2.40.0