Darcy Buskermolen <darcyb(at)commandprompt(dot)com> writes:
> I'm observing high CPU usage (95%) of a 2.6GHz opteron by the stats
> collector on an 8.2.3 box  investigation has lead me to belive that the
> stats file is written a lot more often that once every 500ms  the
> following shows this behavior.

Looks like someone broke the usage of PGSTAT_STAT_INTERVAL between 8.1
and 8.2 ... it's waiting 500 microseconds, not the intended 500
milliseconds.

			regards, tom lane

In response to

• Re: Possible Bug: high CPU usage for stats collector in 8.2 at 2007-03-01 18:07:27 from Darcy Buskermolen

Responses

• Re: Possible Bug: high CPU usage for stats collector in 8.2 at 2007-03-01 20:20:05 from Andrew Dunstan
• Re: Possible Bug: high CPU usage for stats collector in 8.2 at 2007-03-02 21:41:18 from Darcy Buskermolen

pgsql-hackers by date

Next:	From: Andrew Dunstan	Date: 2007-03-01 20:08:21
	Subject: Re: Google SoC: lots of discussion, very few mentors
Previous:	From: Simon Riggs	Date: 2007-03-01 19:51:24
	Subject: Re: HOT - preliminary results