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.
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