The GucContext of log_autovacuum is PGC_BACKEND in the CVS HEAD, but should it be PGC_SIGHUP? We cannot modify the variable on-the-fly because the parameter is used only by autovacuum worker processes. The similar variables, like autovacuum_vacuum_scale_factor, are defined as PGC_SIGHUP.
Index: src/backend/utils/misc/guc.c =================================================================== --- src/backend/utils/misc/guc.c (head) +++ src/backend/utils/misc/guc.c (working copy) @@ -1552,7 +1552,7 @@ }, { - {"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)."), Regards, --- ITAGAKI Takahiro NTT Open Source Software Center ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org