Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6D3779FB569 for ; Thu, 22 Mar 2007 13:33:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 64750-01 for ; Thu, 22 Mar 2007 13:33:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx1.bandwidth.com (nat0.bandwidth.com [216.27.14.90]) by postgresql.org (Postfix) with SMTP id 06C799FB51E for ; Thu, 22 Mar 2007 13:33:24 -0300 (ADT) Received: (qmail 28645 invoked by uid 1008); 22 Mar 2007 16:33:37 -0000 Received: from dbrain@bandwidth.com by mx1 by uid 1002 with qmail-scanner-1.20 (spamassassin: 2.63. Clear:RC:1(10.1.53.112):. Processed in 0.018666 secs); 22 Mar 2007 16:33:37 -0000 Received: from unknown (HELO ?10.1.53.112?) (10.1.53.112) by mx1.bandwidth.com with SMTP; 22 Mar 2007 16:33:36 -0000 Message-ID: <4602AF1E.8000601@bandwidth.com> Date: Thu, 22 Mar 2007 12:30:22 -0400 From: David Brain User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: Bill Moran CC: pgsql-performance@postgresql.org Subject: Re: Potential memory usage issue References: <460271B9.8050600@bandwidth.com> <20070322085037.54780906.wmoran@collaborativefusion.com> <46027F65.9080909@bandwidth.com> <20070322091700.9d1553e6.wmoran@collaborativefusion.com> In-Reply-To: <20070322091700.9d1553e6.wmoran@collaborativefusion.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/338 X-Sequence-Number: 23743 Bill Moran wrote: > > Install the pg_bufferstats contrib module and take a look at how shared > memory is being use. I like to use MRTG to graph shared buffer usage > over time, but you can just do a SELECT count(*) WHERE NOT NULL to see > how many buffers are actually in use. > Can you explain what you'd use as a diagnostic on this - I just installed the module - but I'm not entirely clear as to what the output is actually showing me and/or what would be considered good or bad. Thanks, David. -- David Brain - bandwidth.com dbrain@bandwidth.com