From a795fb21eabd5a4895317450c4c868fdc2c07448 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 10 Sep 2007 01:39:19 +0000 Subject: [PATCH] Set the correct context (PGC_SIGHUP) for log_autovacuum, per ITAGAKI Takahiro. Fix grammatical errors in its description. --- doc/src/sgml/config.sgml | 8 ++++---- src/backend/utils/misc/guc.c | 4 ++-- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 32205de9a1..e76c1f3fc9 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3406,10 +3406,10 @@ guess what - Causes actions executed by autovacuum to be logged if it ran for at - least the specified number of milliseconds. Setting this to zero prints - all action durations. Minus-one (the default) disables logging - autovacuum action durations. For example, if you set it to + Causes each action executed by autovacuum to be logged if it ran for at + least the specified number of milliseconds. Setting this to zero logs + all autovacuum actions. Minus-one (the default) disables logging + autovacuum actions. For example, if you set this to 250ms then all vacuums and analyzes that run 250ms or longer will be logged. Enabling this parameter can be helpful in tracking autovacuum activity. This setting can only be set in diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 3b9937a175..06ecb91cca 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -1573,10 +1573,10 @@ static struct config_int ConfigureNamesInt[] = }, { - {"log_autovacuum", PGC_BACKEND, LOGGING_WHAT, + {"log_autovacuum", PGC_SIGHUP, LOGGING_WHAT, gettext_noop("Sets the minimum execution time above which autovacuum actions " "will be logged."), - gettext_noop("Zero prints all actions. The default is -1 (turning this feature off)."), + gettext_noop("Zero prints all actions. The default is -1 (disabling autovacuum logging)."), GUC_UNIT_MS }, &Log_autovacuum, -- 2.39.5