diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-19 01:51:22 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-19 01:51:22 +0000 |
| commit | b13c9686d08411a284afeb881b49d7955761d8cb (patch) | |
| tree | ec956d8cc1a3176b73b064d711ce5ccda547e23b /src/backend/utils/misc/postgresql.conf.sample | |
| parent | 6075feed40804a963f9a7c041e7d157a86cc758d (diff) | |
Take the statistics collector out of the loop for monitoring backends'
current commands; instead, store current-status information in shared
memory. This substantially reduces the overhead of stats_command_string
and also ensures that pg_stat_activity is fully up to date at all times.
Per my recent proposal.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index ee5adaa2ff2..26b2be6d6ef 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -320,21 +320,21 @@ # RUNTIME STATISTICS #--------------------------------------------------------------------------- -# - Statistics Monitoring - - -#log_parser_stats = off -#log_planner_stats = off -#log_executor_stats = off -#log_statement_stats = off - # - Query/Index Statistics Collector - -#stats_start_collector = on #stats_command_string = off +#stats_start_collector = on # needed for block or row stats #stats_block_level = off #stats_row_level = off #stats_reset_on_server_start = off +# - Statistics Monitoring - + +#log_parser_stats = off +#log_planner_stats = off +#log_executor_stats = off +#log_statement_stats = off + #--------------------------------------------------------------------------- # AUTOVACUUM PARAMETERS |