Skip site navigation (1) Skip section navigation (2)

Re: Potential memory usage issue [resolved]

From: David Brain <dbrain(at)bandwidth(dot)com>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Potential memory usage issue [resolved]
Date: 2007-03-22 18:20:44
Message-ID: 4602C8FC.7050501@bandwidth.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)bandwidth(dot)com

In response to

pgsql-performance by date

Next:From: Craig A. JamesDate: 2007-03-22 18:21:21
Subject: Re: Performance of count(*)
Previous:From: Steve AtkinsDate: 2007-03-22 17:53:24
Subject: Re: Performance of count(*)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group