From 48f7e6439568e5d665f622e2973becc50a86b64a Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 24 Sep 2007 03:12:23 +0000 Subject: Simplify and rename some GUC variables, per various recent discussions: * stats_start_collector goes away; we always start the collector process, unless prevented by a problem with setting up the stats UDP socket. * stats_reset_on_server_start goes away; it seems useless in view of the availability of pg_stat_reset(). * stats_block_level and stats_row_level are merged into a single variable "track_counts", which controls all reports sent to the collector process. * stats_command_string is renamed to track_activities. * log_autovacuum is renamed to log_autovacuum_min_duration to better reflect its meaning. The log_autovacuum change is not a compatibility issue since it didn't exist before 8.3 anyway. The other changes need to be release-noted. --- src/backend/utils/misc/postgresql.conf.sample | 19 +++++++------------ 1 file changed, 7 insertions(+), 12 deletions(-) (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 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 -- cgit v1.2.3