Skip to content

Commit 56805a4

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 f9bb9c0 commit 56805a4

File tree

1 file changed

+2
-7
lines changed

1 file changed

+2
-7
lines changed

doc/src/sgml/ref/create_table.sgml

+2-7
Original file line numberDiff line numberDiff line change
@@ -1009,9 +1009,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
10091009
Custom <xref linkend="guc-autovacuum-freeze-max-age"> parameter. Note that
10101010
autovacuum will ignore attempts to set a per-table
10111011
<literal>autovacuum_freeze_max_age</> larger than the system-wide setting
1012-
(it can only be set smaller). Note that while you can set
1013-
<literal>autovacuum_freeze_max_age</> very small, or even zero, this is
1014-
usually unwise since it will force frequent vacuuming.
1012+
(it can only be set smaller).
10151013
</para>
10161014
</listitem>
10171015
</varlistentry>
@@ -1045,10 +1043,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
10451043
Custom <xref linkend="guc-autovacuum-multixact-freeze-max-age"> parameter. Note
10461044
that autovacuum will ignore attempts to set a per-table
10471045
<literal>autovacuum_multixact_freeze_max_age</> larger than the
1048-
system-wide setting (it can only be set smaller). Note that while you
1049-
can set <literal>autovacuum_multixact_freeze_max_age</> very small,
1050-
or even zero, this is usually unwise since it will force frequent
1051-
vacuuming.
1046+
system-wide setting (it can only be set smaller).
10521047
</para>
10531048
</listitem>
10541049
</varlistentry>

0 commit comments

Comments
 (0)