Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 42E0A64FCBF for ; Tue, 4 Nov 2008 03:42:50 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48874-03 for ; Tue, 4 Nov 2008 03:42:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from viefep18-int.chello.at (viefep18-int.chello.at [213.46.255.22]) by mail.postgresql.org (Postfix) with ESMTP id 4316E64FC91 for ; Tue, 4 Nov 2008 03:42:48 -0400 (AST) Received: from edge01.upc.biz ([192.168.13.236]) by viefep15-int.chello.at (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20081104074246.JMZL2686.viefep15-int.chello.at@edge01.upc.biz> for ; Tue, 4 Nov 2008 08:42:46 +0100 Received: from [192.168.2.175] ([89.134.231.52]) by edge01.upc.biz with edge id avik1a05s18VCLh01vilsB; Tue, 04 Nov 2008 08:42:46 +0100 X-SourceIP: 89.134.231.52 Message-ID: <490FFCF4.2050500@shopzeus.com> Date: Tue, 04 Nov 2008 08:42:44 +0100 From: Laszlo Nagy User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: rebellious postgres process Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200811/17 X-Sequence-Number: 30671 This is what I see in "top" since two days: last pid: 95702; load averages: 2.48, 2.69, 2.75 up 3+02:08:49 10:27:58 257 processes: 3 running, 246 sleeping, 8 zombie CPU states: 15.5% user, 0.0% nice, 22.1% system, 1.3% interrupt, 61.1% idle Mem: 864M Active, 6028M Inact, 512M Wired, 254M Cache, 214M Buf, 211M Free Swap: 10G Total, 500K Used, 10G Free PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 677 pgsql 1 107 0 22396K 5460K CPU3 6 52.4H 99.02% postgres The processi is using 100% CPU for 52 hours! Here it is: %ps axl | grep 677 70 677 666 757 107 0 22396 5460 select Rs ?? 3144:50.88 postgres: stats collector process (postgres) Is this normal? Fortunately, we have more processors in this system and it is not causing slow-down. But I really need to know what is happening here. I believe it is not the way it should work. Yesterday the system was restarted suddenly, and this process might be the reason for this. After the restart, the process is doing the same thing again: PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 904 pgsql 1 105 0 22396K 5332K CPU3 3 386:05 99.22% postgres Here is some more info: Hardware: Two Quad Xeon 2.5GHz processors, 8GB RAM, RAID with 2GB cache and BBU, 10 SATA2 disks in RAID 1+0 OS: FreeBSD 7.0 amd64 Postgresql: 8.3 Databases: two bigger ones, total database size on disk is about 10GB, used mostly read-only, but some smaller tables updated frequently. I don't think that it needs stat collection continuously. Thanks, Laszlo