From: David Brain <dbrain@bandwidth.com>
To: Bill Moran <wmoran@collaborativefusion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Potential memory usage issue [resolved]
Date: Thu, 22 Mar 2007 14:20:44 -0400
Message-ID: <4602C8FC.7050501@bandwidth.com> (raw)
In-Reply-To: <20070322130335.e142faed.wmoran@collaborativefusion.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dbrain@bandwidth.com, wmoran@collaborativefusion.com
Subject: Re: Potential memory usage issue [resolved]
In-Reply-To: <4602C8FC.7050501@bandwidth.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox