diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-09-24 03:12:23 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-09-24 03:12:23 +0000 |
| commit | 48f7e6439568e5d665f622e2973becc50a86b64a (patch) | |
| tree | 61e36a6230783a6e8374e72b247fb3597f4d5a3f /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 02138357ffc8c41a3d646035368712a5394f1f5f (diff) | |
| download | postgresql-48f7e6439568e5d665f622e2973becc50a86b64a.tar.gz postgresql-48f7e6439568e5d665f622e2973becc50a86b64a.zip | |
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.
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 |