diff options
Diffstat (limited to 'src/backend/utils')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 13 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 5 |
2 files changed, 16 insertions, 2 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 83ea00c568a..b9643a734d3 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.385 2007/04/16 18:29:55 alvherre Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.386 2007/04/18 16:44:18 alvherre Exp $ * *-------------------------------------------------------------------- */ @@ -1506,6 +1506,17 @@ static struct config_int ConfigureNamesInt[] = }, { + {"log_autovacuum", PGC_BACKEND, 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)."), + GUC_UNIT_MS + }, + &Log_autovacuum, + -1, -1, INT_MAX / 1000, NULL, NULL + }, + + { {"bgwriter_delay", PGC_SIGHUP, RESOURCES, gettext_noop("Background writer sleep time between rounds."), NULL, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index bc5b642d029..e7d8e41b0e1 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -376,8 +376,11 @@ #autovacuum = on # enable autovacuum subprocess? # 'on' requires stats_start_collector # and stats_row_level to also be on -#autovacuum_max_workers = 3 # max # of autovacuum subprocesses +#autovacuum_max_workers = 3 # max # of autovacuum subprocesses #autovacuum_naptime = 1min # time between autovacuum runs +#log_autovacuum = -1 # -1 is disabled, 0 logs all actions + # and their durations, > 0 logs only + # actions running at least N msec. #autovacuum_vacuum_threshold = 500 # min # of tuple updates before # vacuum #autovacuum_analyze_threshold = 250 # min # of tuple updates before |