Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5D6959FBA3C for ; Wed, 25 Jul 2007 00:25:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 49674-10 for ; Wed, 25 Jul 2007 00:25:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id BF8389FB963 for ; Wed, 25 Jul 2007 00:25:08 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6P3P6oF000123; Tue, 24 Jul 2007 23:25:06 -0400 (EDT) To: Karl Denninger cc: Merlin Moncure , pgsql-performance@postgresql.org Subject: Re: Performance issue with 8.2.3 - "C" application In-reply-to: <46A6C080.10204@denninger.net> References: <46A6A549.1040606@denninger.net> <29633.1185331558@sss.pgh.pa.us> <46A6BBB1.1020502@denninger.net> <46A6C080.10204@denninger.net> Comments: In-reply-to Karl Denninger message dated "Tue, 24 Jul 2007 22:16:16 -0500" Date: Tue, 24 Jul 2007 23:25:06 -0400 Message-ID: <122.1185333906@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/331 X-Sequence-Number: 26015 Karl Denninger writes: > Hmmmmm..... now that's interesting. Stats collector IS accumulating > quite a bit of runtime..... me thinks its time to go grab 8.2.4. I think Merlin might have nailed it --- the "stats collector bug" is that it tries to write out the stats file way more often than it should. So any excessive userland CPU time you see is just the tip of the iceberg compared to the system and I/O costs incurred. regards, tom lane