From b13c9686d08411a284afeb881b49d7955761d8cb Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Mon, 19 Jun 2006 01:51:22 +0000 Subject: 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. --- src/backend/utils/misc/postgresql.conf.sample | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 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 ee5adaa2ff..26b2be6d6e 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 -- cgit v1.2.1