diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-04-18 16:44:18 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-04-18 16:44:18 +0000 |
| commit | ef23a77441b94d1e2fde3f359d2e49703c70c9ca (patch) | |
| tree | e603a32544b9c491293a2e3eab25b02fef4fc895 /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 432ea3cffdfc49eeaf11f9ef31970c69ec38cd63 (diff) | |
| download | postgresql-ef23a77441b94d1e2fde3f359d2e49703c70c9ca.tar.gz postgresql-ef23a77441b94d1e2fde3f359d2e49703c70c9ca.zip | |
Enable configurable log of autovacuum actions. Initial patch from Simon
Riggs, additional code and docs by me. Per discussion.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 5 |
1 files changed, 4 insertions, 1 deletions
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 |