Skip to content

Commit e946cc6

Browse files
committed
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 (834a6da). 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)
1 parent 28dea94 commit e946cc6

File tree

1 file changed

+2
-7
lines changed

1 file changed

+2
-7
lines changed

doc/src/sgml/ref/create_table.sgml

Lines changed: 2 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -994,9 +994,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
994994
Custom <xref linkend="guc-autovacuum-freeze-max-age"> parameter. Note that
995995
autovacuum will ignore attempts to set a per-table
996996
<literal>autovacuum_freeze_max_age</> larger than the system-wide setting
997-
(it can only be set smaller). Note that while you can set
998-
<literal>autovacuum_freeze_max_age</> very small, or even zero, this is
999-
usually unwise since it will force frequent vacuuming.
997+
(it can only be set smaller).
1000998
</para>
1001999
</listitem>
10021000
</varlistentry>
@@ -1030,10 +1028,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
10301028
Custom <xref linkend="guc-autovacuum-multixact-freeze-max-age"> parameter. Note
10311029
that autovacuum will ignore attempts to set a per-table
10321030
<literal>autovacuum_multixact_freeze_max_age</> larger than the
1033-
system-wide setting (it can only be set smaller). Note that while you
1034-
can set <literal>autovacuum_multixact_freeze_max_age</> very small,
1035-
or even zero, this is usually unwise since it will force frequent
1036-
vacuuming.
1031+
system-wide setting (it can only be set smaller).
10371032
</para>
10381033
</listitem>
10391034
</varlistentry>

0 commit comments

Comments
 (0)