stats collector process high CPU utilization

From: Benjamin Minshall <minshall(at)intellicon(dot)biz>
To: pgsql-performance(at)postgresql(dot)org
Subject: stats collector process high CPU utilization
Date: 2007-02-08 16:48:01
Message-ID: 45CB5441.1040707@intellicon.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)intellicon(dot)biz>
Senior Developer -- Intellicon, Inc.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Stosberg 2007-02-08 17:11:25 Re: Speed up this query
Previous Message Mark Stosberg 2007-02-07 21:30:16 tip: faster sorting for proximity queries by using cube_distance()