GucContext of log_autovacuum - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject GucContext of log_autovacuum
Date
Msg-id 20070724130000.8E1D.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
Responses Re: GucContext of log_autovacuum  ("Simon Riggs" <simon@2ndquadrant.com>)
Re: GucContext of log_autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: GucContext of log_autovacuum  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
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
whichautovacuum 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



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: autovacuum default parameters (was Re: 8.2 is 30% better in pgbench than 8.3)
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: autovacuum default parameters (was Re: 8.2 is 30% better in pgbench than 8.3)