pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
Date: Tue, 10 Jun 2003 21:26:49 +0530
Message-ID: <3EE64D19.30310.9E8DA9@localhost> (raw)
In-Reply-To: <200306100846.21875.josh@agliodbs.com>
References: <EFF9ABB64B24D511A75C0002A5512D5C01911DE4@LEWEXCH>

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.




view thread (13+ messages)  latest in thread

Message-ID: <3EE64D19.30310.9E8DA9@localhost>
Permalink:  ../3EE64D19.30310.9E8DA9@localhost/
Also on:    postgresql.org/message-id/3EE64D19.30310.9E8DA9@localhost

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: shridhar_daithankar@persistent.co.in
  Subject: Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning
  In-Reply-To: <3EE64D19.30310.9E8DA9@localhost>
  References: <EFF9ABB64B24D511A75C0002A5512D5C01911DE4@LEWEXCH> <3EE64D19.30310.9E8DA9@localhost>

* 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