To: Benjamin Minshall <minshall@intellicon.biz>
cc: pgsql-performance@postgresql.org
Subject: Re: stats collector process high CPU utilization 
In-reply-to: <45CB5D06.7090004@intellicon.biz> 
References: <45CB5441.1040707@intellicon.biz> <21013.1170955076@sss.pgh.pa.us>
	<45CB5D06.7090004@intellicon.biz>
Comments: In-reply-to Benjamin Minshall <minshall@intellicon.biz>
	message dated "Thu, 08 Feb 2007 12:25:26 -0500"
Date: Thu, 08 Feb 2007 13:46:31 -0500
Message-ID: <7994.1170960391@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Benjamin Minshall <minshall@intellicon.biz> writes:
> Tom Lane wrote:
>> Benjamin Minshall <minshall@intellicon.biz> writes:
>>> 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?

>> What version did you update from, and what platform is this?

> I upgraded from 8.1.5.  The system is a dual Xeon 2.4Ghz, 4Gb RAM 
> running linux kernel 2.6 series.

OK, I was trying to correlate it with post-8.2.0 patches but evidently
that's the wrong tree to bark up.  No, this isn't an expected behavior.
Is there anything unusual about your database (huge numbers of tables,
or some such)?  Can you gather some info about what it's doing?
strace'ing the stats collector might prove interesting, also if you have
built it with --enable-debug then oprofile results would be helpful.

			regards, tom lane