diff options
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 39 |
1 files changed, 38 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index e0b8a4ecaf6..7a01c63d5f0 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -985,7 +985,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI <para> Custom <xref linkend="guc-vacuum-freeze-min-age"> parameter. Note that autovacuum will ignore attempts to set a per-table - <literal>autovacuum_freeze_min_age</> larger than the half system-wide + <literal>autovacuum_freeze_min_age</> larger than half the system-wide <xref linkend="guc-autovacuum-freeze-max-age"> setting. </para> </listitem> @@ -1014,6 +1014,43 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI </listitem> </varlistentry> + <varlistentry> + <term><literal>autovacuum_multixact_freeze_min_age</literal>, <literal>toast.autovacuum_multixact_freeze_min_age</literal> (<type>integer</type>)</term> + <listitem> + <para> + Custom <xref linkend="guc-vacuum-multixact-freeze-min-age"> parameter. + Note that autovacuum will ignore attempts to set a per-table + <literal>autovacuum_multixact_freeze_min_age</> larger than half the + system-wide <xref linkend="guc-autovacuum-multixact-freeze-max-age"> + setting. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><literal>autovacuum_multixact_freeze_max_age</literal>, <literal>toast.autovacuum_multixact_freeze_max_age</literal> (<type>integer</type>)</term> + <listitem> + <para> + Custom <xref linkend="guc-autovacuum-multixact-freeze-max-age"> parameter. Note + that autovacuum will ignore attempts to set a per-table + <literal>autovacuum_multixact_freeze_max_age</> larger than the + system-wide setting (it can only be set smaller). Note that while you + can set <literal>autovacuum_multixact_freeze_max_age</> very small, + or even zero, this is usually unwise since it will force frequent + vacuuming. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><literal>autovacuum_multixact_freeze_table_age</literal>, <literal>toast.autovacuum_multixact_freeze_table_age</literal> (<type>integer</type>)</term> + <listitem> + <para> + Custom <xref linkend="guc-vacuum-multixact-freeze-table-age"> parameter. + </para> + </listitem> + </varlistentry> + </variablelist> </refsect2> |