Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 633591337B8A for ; Mon, 7 Feb 2011 18:59:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 16983-02 for ; Mon, 7 Feb 2011 22:59:02 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail149046.authsmtp.co.uk (outmail149046.authsmtp.co.uk [62.13.149.46]) by mail.postgresql.org (Postfix) with ESMTP id 81B0C1337B54 for ; Mon, 7 Feb 2011 18:59:00 -0400 (AST) Received: from mail-c194.authsmtp.com (mail-c194.authsmtp.com [62.13.128.121]) by punt12.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p17Mwxis055951; Mon, 7 Feb 2011 22:58:59 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p17Mworl080155; Mon, 7 Feb 2011 22:58:51 GMT Message-ID: <4D507920.2030909@agliodbs.com> Date: Mon, 07 Feb 2011 14:58:40 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: =?UTF-8?B?Q8OpZHJpYyBWaWxsZW1haW4=?= CC: pgsql-performance@postgresql.org Subject: Re: Write-heavy pg_stats_collector on mostly idle server References: <4D4C4E15.20401@agliodbs.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: d4d206ee-330d-11e0-80b9-0022640b883e X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQL c1ACcR19PVdbHwkA AnYJWV5RWFd0WC1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoABt8 QUFcDhl6dwRDfTBy Z0BgECRfCEZ6cxMo X01XFTkbZGY1aH0X UBJRagNUcgFMeh8X Ylh8AT1vNG8XDRoV JSEUBRUEdQpFKThY BwEAJEwDCV4EKSUg TgwZKj4oGUkITDk0 NVQhLBYZG10NNlR6 MFclVBoDPgUMBxc2 X-Authentic-SMTP: 61633136333939.1015:706 X-AuthFastPath: 0 (Was 255) X-AuthVirus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201102/289 X-Sequence-Number: 42427 >> Anyone seen anything like this before? >> > > it is the expected behavior, IIRC OK. It just seems kind of pathological for stats file writing to be 10X the volume of data writing. I see why it's happening, but I think it's something we should fix. -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com