Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id BB64BB5DBC8 for ; Fri, 20 May 2011 19:38:49 -0300 (ADT) 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 78339-01 for ; Fri, 20 May 2011 22:38:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from spinlock.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id 98025B5DBC2 for ; Fri, 20 May 2011 19:38:42 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by spinlock.commandprompt.com (Postfix) with ESMTP id 49034348045 for ; Fri, 20 May 2011 15:38:42 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at commandprompt.com Received: from spinlock.commandprompt.com ([127.0.0.1]) by localhost (spinlock.commandprompt.com.commandprompt.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Uwz4tHpN8dKe for ; Fri, 20 May 2011 15:38:40 -0700 (PDT) Received: from [192.168.1.138] (71-94-253-247.dhcp.mdfd.or.charter.com [71.94.253.247]) by spinlock.commandprompt.com (Postfix) with ESMTPSA id 05C77348044 for ; Fri, 20 May 2011 15:38:39 -0700 (PDT) Message-ID: <4DD6ED6A.4050101@commandprompt.com> Date: Fri, 20 May 2011 15:38:34 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Who is causing all this i/o? References: <4DD6D9A6.1010101@emolecules.com> In-Reply-To: <4DD6D9A6.1010101@emolecules.com> 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=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201105/133 X-Sequence-Number: 37570 > The other two servers are configured identically. If I diff the > configuration files, the only difference is the IP addresses for the > "listen" section. > > Can anyone tell me what's going on? Why is pgstat.stat being rewritten > on this server constantly and not on the other two servers? Do you have something monitoring the stats of the system aggressively? (like pg_stat_user_tables?) JD > > Thanks, > Craig > > -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc - @postgresconf - 509-416-6579