Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning

On 10 Jun 2003 at 8:46, Josh Berkus wrote:

> SHARED_BUFFERS
> Sets the size of Postgres' memory buffer where queries are held before being 
> fed into the Kernel buffer of the host system.  It's very important to 
> remember that this is only a holding area, and not the total memory available 
> for the server.  As such, resist the urge to set this number to a large 
> portion of your RAM, as this will actually degrade performance on many OSes.  
> Members of the pgsql-performance mailing list have found useful values in the 
> range of 1000-6000, depending on available RAM, database size, and number of 
> concurrent queries. No one has yet reported positive results for any number 
> over 6000.

I was planning to document postgresql.conf with little hints, enough to get one 
started, drawing inspiration from lilo.conf of debian, which is beautiful to 
say the least..

I haven't find enough time to do that. But I will do it.. But I don't know all 
the parameters enough. Of course I will post a starter but any input would be 
welcome.

Point is we should be able to say RTFC rather than RTFA as that would get a DBA 
single place to look at.  I agree that no amount of simplicity is enough but 
still..:-)


Bye
 Shridhar

--
Brooke's Law:	Whenever a system becomes completely defined, some damn fool	
discovers something which either abolishes the system or	expands it beyond 
recognition.