diff options
author | Michael Paquier <michael@paquier.xyz> | 2021-04-12 13:53:17 +0900 |
---|---|---|
committer | Michael Paquier <michael@paquier.xyz> | 2021-04-12 13:53:17 +0900 |
commit | b094063cd16d22b2f065a432580bb3568b2d8a77 (patch) | |
tree | d88b2dea59c41976ea19519149e0b3cdcb700a3a /doc/src | |
parent | 15c1a9d9cb7604472d4823f48b64cdc02c441194 (diff) | |
download | postgresql-b094063cd16d22b2f065a432580bb3568b2d8a77.tar.gz postgresql-b094063cd16d22b2f065a432580bb3568b2d8a77.zip |
Move log_autovacuum_min_duration into its correct sections
This GUC has already been classified as LOGGING_WHAT, but its location
in postgresql.conf.sample and the documentation did not reflect that, so
fix those inconsistencies.
Author: Justin Pryzby
Discussion: https://postgr.es/m/20210404012546.GK6592@telsasoft.com
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/config.sgml | 56 |
1 files changed, 28 insertions, 28 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 5bdb8650cc2..f749fe9ce7b 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -6812,6 +6812,34 @@ local0.* /var/log/postgresql </listitem> </varlistentry> + <varlistentry id="guc-log-autovacuum-min-duration" xreflabel="log_autovacuum_min_duration"> + <term><varname>log_autovacuum_min_duration</varname> (<type>integer</type>) + <indexterm> + <primary><varname>log_autovacuum_min_duration</varname></primary> + <secondary>configuration parameter</secondary> + </indexterm> + </term> + <listitem> + <para> + Causes each 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> (the default) 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 + 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 + concurrently dropped relation. Enabling this parameter can be helpful + in tracking autovacuum activity. 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-checkpoints" xreflabel="log_checkpoints"> <term><varname>log_checkpoints</varname> (<type>boolean</type>) <indexterm> @@ -7827,34 +7855,6 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv; </listitem> </varlistentry> - <varlistentry id="guc-log-autovacuum-min-duration" xreflabel="log_autovacuum_min_duration"> - <term><varname>log_autovacuum_min_duration</varname> (<type>integer</type>) - <indexterm> - <primary><varname>log_autovacuum_min_duration</varname></primary> - <secondary>configuration parameter</secondary> - </indexterm> - </term> - <listitem> - <para> - Causes each 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> (the default) 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 - 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 - concurrently dropped relation. Enabling this parameter can be helpful - in tracking autovacuum activity. 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-autovacuum-max-workers" xreflabel="autovacuum_max_workers"> <term><varname>autovacuum_max_workers</varname> (<type>integer</type>) <indexterm> |