From ef23a77441b94d1e2fde3f359d2e49703c70c9ca Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Wed, 18 Apr 2007 16:44:18 +0000 Subject: Enable configurable log of autovacuum actions. Initial patch from Simon Riggs, additional code and docs by me. Per discussion. --- src/backend/utils/misc/postgresql.conf.sample | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') 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 -- cgit v1.2.3