Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CBB0164FEC1 for ; Fri, 19 Dec 2008 09:13:48 -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 72487-09 for ; Fri, 19 Dec 2008 09:13:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from shopzeus.com (135-shost.hostoffice.hu [195.228.74.135]) by mail.postgresql.org (Postfix) with ESMTP id 9B1BA64FDA2 for ; Fri, 19 Dec 2008 09:13:43 -0400 (AST) Received: from [192.168.1.104] (localhost [127.0.0.1]) by shopzeus.com (Postfix) with ESMTP id 7B8B9392429; Fri, 19 Dec 2008 08:12:33 -0500 (EST) Message-ID: <494B9E02.5060904@shopzeus.com> Date: Fri, 19 Dec 2008 14:13:38 +0100 From: Laszlo Nagy User-Agent: Thunderbird 2.0.0.18 (X11/20081125) MIME-Version: 1.0 To: Alvaro Herrera , pgsql-admin@postgresql.org Subject: Re: rebellious pg stats collector (reopened case) References: <49479876.8040607@shopzeus.com> <20081216134542.GH4741@alvh.no-ip.org> <494B614C.5060808@shopzeus.com> <20081219130446.GC4278@alvh.no-ip.org> In-Reply-To: <20081219130446.GC4278@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.125 tagged_above=0 required=5 tests=DNS_FROM_RFC_BOGUSMX=2.125 X-Spam-Level: ** X-Archive-Number: 200812/159 X-Sequence-Number: 30992 > It was 78816 and you traced 78815? Are you sure the process with 24h of > CPU was pgstat? > I'm sorry that was a typo. Of course I traced the good process (proof is that at the end it renamed a file to "global/pgstat.stat". And yes, "top" showed 24H in the TIME column and 99% in the WCPU column. Also this process used 50-90% of disk I/O continuously, slowing down the computer. I'm sure that it will happen again, then I'm going to post another trace (and make sure that I trace the good process). Best, Laszlo