diff options
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 19 |
1 files changed, 7 insertions, 12 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 3816210d85a..f63ba382017 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -358,15 +358,10 @@ # - Query/Index Statistics Collector - -#stats_command_string = on +#track_activities = on +#track_counts = on #update_process_title = on -#stats_start_collector = on # needed for block or row stats - # (change requires restart) -#stats_block_level = off -#stats_row_level = on -#stats_reset_on_server_start = off # (change requires restart) - # - Statistics Monitoring - @@ -381,13 +376,13 @@ #--------------------------------------------------------------------------- #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_naptime = 1min # time between autovacuum runs -#log_autovacuum = -1 # -1 is disabled, 0 logs all actions + # 'on' requires track_counts + # to also be on +#log_autovacuum_min_duration = -1 # -1 disables, 0 logs all actions # and their durations, > 0 logs only # actions running at least N msec. +#autovacuum_max_workers = 3 # max # of autovacuum subprocesses +#autovacuum_naptime = 1min # time between autovacuum runs #autovacuum_vacuum_threshold = 50 # min # of tuple updates before # vacuum #autovacuum_analyze_threshold = 50 # min # of tuple updates before |