stats collector process high CPU utilization - Mailing list pgsql-performance

From Benjamin Minshall
Subject stats collector process high CPU utilization
Date
Msg-id 45CB5441.1040707@intellicon.biz
Whole thread Raw
Responses Re: stats collector process high CPU utilization  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Greetings,

Since upgrading to 8.2.3 yesterday, the stats collector process has had
very high CPU utilization; it is consuming roughly 80-90% of one CPU.
The server seems a lot more sluggish than it was before.  Is this normal
operation for 8.2 or something I should look into correcting?

stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
stats_reset_on_server_start = false

--
Benjamin Minshall <minshall@intellicon.biz>
Senior Developer -- Intellicon, Inc.

Attachment

pgsql-performance by date:

Previous
From: Mark Stosberg
Date:
Subject: tip: faster sorting for proximity queries by using cube_distance()
Next
From: Mark Stosberg
Date:
Subject: Re: Speed up this query