Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C59B29FB966 for ; Wed, 25 Jul 2007 00:35:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 56764-08 for ; Wed, 25 Jul 2007 00:35:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from FS.denninger.net (wsip-70-169-168-7.pn.at.cox.net [70.169.168.7]) by postgresql.org (Postfix) with ESMTP id 6225A9FB8AC for ; Wed, 25 Jul 2007 00:35:43 -0300 (ADT) Received: from [192.168.1.13] (localhost [127.0.0.1]) by FS.denninger.net (8.13.8/8.13.1) with SMTP id l6P3ZfA2068157 for ; Tue, 24 Jul 2007 22:35:42 -0500 (CDT) (envelope-from karl@denninger.net) Received: from [192.168.1.13] [192.168.1.13] by Spamblock-sys (LOCAL); Tue Jul 24 22:35:42 2007 Message-ID: <46A6C50D.1000908@denninger.net> Date: Tue, 24 Jul 2007 22:35:41 -0500 From: Karl Denninger User-Agent: Thunderbird 2.0.0.5 (Windows/20070716) MIME-Version: 1.0 To: Tom Lane CC: Merlin Moncure , pgsql-performance@postgresql.org Subject: Re: Performance issue with 8.2.3 - "C" application References: <46A6A549.1040606@denninger.net> <29633.1185331558@sss.pgh.pa.us> <46A6BBB1.1020502@denninger.net> <46A6C080.10204@denninger.net> <122.1185333906@sss.pgh.pa.us> In-Reply-To: <122.1185333906@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SPAMBLOCK-MATCH: Matched [@postgresql.org+], message ok X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/332 X-Sequence-Number: 26016 Aha! BIG difference. I won't know for sure until the biz day tomorrow but the "first blush" look is that it makes a HUGE difference in system load, and I no longer have the stats collector process on the top of the "top" list...... Karl Denninger (karl@denninger.net) http://www.denninger.net Tom Lane wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > > > %SPAMBLOCK-SYS: Matched [hub.org+], message ok > %SPAMBLOCK-SYS: Matched [@postgresql.org+], message ok