Message-ID: <4602C8FC.7050501@bandwidth.com>
Date: Thu, 22 Mar 2007 14:20:44 -0400
From: David Brain <dbrain@bandwidth.com>
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: Bill Moran <wmoran@collaborativefusion.com>
CC: pgsql-performance@postgresql.org
Subject: Re: Potential memory usage issue [resolved]
References: <460271B9.8050600@bandwidth.com>
	<20070322085037.54780906.wmoran@collaborativefusion.com>
	<46027F65.9080909@bandwidth.com>
	<20070322091700.9d1553e6.wmoran@collaborativefusion.com>
	<4602AF1E.8000601@bandwidth.com>
	<20070322130335.e142faed.wmoran@collaborativefusion.com>
In-Reply-To: <20070322130335.e142faed.wmoran@collaborativefusion.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thanks Bill for the explanation - that really helped me out considerably.

What this showed me was that there were only 1024 buffers configured. 
I'm not quite clear as to how this happened as the postgresql.conf files 
on both systems have the shared_buffers set to ~50000.  However it looks 
as though the system start script was passing in -B 1024 to postmaster 
which was overriding the postgresql.conf settings.

The really odd thing is that that the db start script is also the same 
on both systems, so there some other difference there that I need to 
track down.  However removing the -B 1024 allowed the settings to revert 
to the file specified values.

So now I'm back to using ~50k buffers again and things are running a 
little more swiftly, and according to pg_buffercache I'm using 49151 of 
them (-:

Thanks again to those who helped me track this down.

David.


-- 
David Brain - bandwidth.com
dbrain@bandwidth.com