Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 535E064FCEF for ; Tue, 4 Nov 2008 11:48:43 -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 37399-04 for ; Tue, 4 Nov 2008 11:48:42 -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 34F6C64FCBF for ; Tue, 4 Nov 2008 11:48:41 -0400 (AST) Received: from edge04.upc.biz ([192.168.13.239]) by viefep13-int.chello.at (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20081104154839.QDJW18816.viefep13-int.chello.at@edge04.upc.biz>; Tue, 4 Nov 2008 16:48:39 +0100 Received: from [192.168.1.103] ([89.134.230.13]) by edge04.upc.biz with edge id b3od1a01u0Hzgy1043oeyX; Tue, 04 Nov 2008 16:48:39 +0100 X-SourceIP: 89.134.230.13 Message-ID: <49106ED5.10805@shopzeus.com> Date: Tue, 04 Nov 2008 16:48:37 +0100 From: Laszlo Nagy User-Agent: Thunderbird 2.0.0.17 (X11/20080925) MIME-Version: 1.0 To: Tom Lane , pgsql-admin@postgresql.org Subject: Re: rebellious postgres process References: <490FFCF4.2050500@shopzeus.com> <16117.1225804625@sss.pgh.pa.us> In-Reply-To: <16117.1225804625@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200811/24 X-Sequence-Number: 30678 Tom Lane wrote: > Huh, that's weird. We've fixed some bugs in the past that led the stats > collector to consume excessive CPU --- but that was all pre-8.3. > The server was rebooting intermittently, so we replaced the RAM (we got a kernel page fault). But it was a week ago. The server is now stable. But is it possible that somehow the file system became inconsistent, and that is causing an infinite loop in the stats collector? Just guessing.