diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 41 | ||||
| -rw-r--r-- | doc/src/sgml/maintenance.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 15 |
3 files changed, 51 insertions, 8 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 39e658b7808..0a2a8b49fdb 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -7477,17 +7477,44 @@ local0.* /var/log/postgresql </term> <listitem> <para> - Causes each action executed by autovacuum to be logged if it ran for at + Causes vacuum action executed by autovacuum to be logged if it ran for at least the specified amount of time. Setting this to zero logs - all autovacuum actions. <literal>-1</literal> disables logging autovacuum - actions. If this value is specified without units, it is taken as milliseconds. - For example, if you set this to - <literal>250ms</literal> then all automatic vacuums and analyzes that run + all vacuum actions by autovacuum. <literal>-1</literal> disables logging + vacuum actions by autovacuum. If this value is specified without units, + it is taken as milliseconds. For example, if you set this to + <literal>250ms</literal> then all automatic vacuums that run 250ms or longer will be logged. In addition, when this parameter is set to any value other than <literal>-1</literal>, a message will be - logged if an autovacuum action is skipped due to a conflicting lock or a + logged if a vacuum action by autovacuum is skipped due to a conflicting lock or a concurrently dropped relation. The default is <literal>10min</literal>. - Enabling this parameter can be helpful in tracking autovacuum activity. + Enabling this parameter can be helpful in tracking vacuum activity by autovacuum. + This parameter can only be set in the <filename>postgresql.conf</filename> + file or on the server command line; but the setting can be overridden for + individual tables by changing table storage parameters. + </para> + </listitem> + </varlistentry> + + <varlistentry id="guc-log-autoanalyze-min-duration" xreflabel="log_autoanalyze_min_duration"> + <term><varname>log_autoanalyze_min_duration</varname> (<type>integer</type>) + <indexterm> + <primary><varname>log_autoanalyze_min_duration</varname></primary> + <secondary>configuration parameter</secondary> + </indexterm> + </term> + <listitem> + <para> + Causes analyze action executed by autovacuum to be logged if it ran for at + least the specified amount of time. Setting this to zero logs + all analyze actions by autovacuum. <literal>-1</literal> disables logging + analyze actions by autovacuum. If this value is specified without units, + it is taken as milliseconds. For example, if you set this to + <literal>250ms</literal> then all automatic analyzes that run + 250ms or longer will be logged. In addition, when this parameter is + set to any value other than <literal>-1</literal>, a message will be + logged if an analyze action by autovacuum is skipped due to a conflicting lock or a + concurrently dropped relation. The default is <literal>10min</literal>. + Enabling this parameter can be helpful in tracking analyze activity by autovacuum. This parameter can only be set in the <filename>postgresql.conf</filename> file or on the server command line; but the setting can be overridden for individual tables by changing table storage parameters. diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml index e7a9f58c015..dc59c88319e 100644 --- a/doc/src/sgml/maintenance.sgml +++ b/doc/src/sgml/maintenance.sgml @@ -892,7 +892,8 @@ HINT: Execute a database-wide VACUUM in that database. the next database will be processed as soon as the first worker finishes. Each worker process will check each table within its database and execute <command>VACUUM</command> and/or <command>ANALYZE</command> as needed. - <xref linkend="guc-log-autovacuum-min-duration"/> can be set to monitor + <xref linkend="guc-log-autovacuum-min-duration"/> and + <xref linkend="guc-log-autoanalyze-min-duration"/> can be set to monitor autovacuum workers' activity. </para> diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index dc000e913c1..a157a244e4e 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1966,6 +1966,21 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM </listitem> </varlistentry> + <varlistentry id="reloption-log-autoanalyze-min-duration" xreflabel="log_autoanalyze_min_duration"> + <term><literal>log_autoanalyze_min_duration</literal> (<type>integer</type>) + <indexterm> + <primary><varname>log_autoanalyze_min_duration</varname></primary> + <secondary>storage parameter</secondary> + </indexterm> + </term> + <listitem> + <para> + Per-table value for <xref linkend="guc-log-autoanalyze-min-duration"/> + parameter. + </para> + </listitem> + </varlistentry> + <varlistentry id="reloption-vacuum-max-eager-freeze-failure-rate" xreflabel="vacuum_max_eager_freeze_failure_rate"> <term><literal>vacuum_max_eager_freeze_failure_rate</literal>, <literal>toast.vacuum_max_eager_freeze_failure_rate</literal> (<type>floating point</type>) <indexterm> |