From: Robert Treat <xzilla@users.sourceforge.net>
To: Hilary Forbes <hforbes@dmr.co.uk>
Cc: pgsql-performance@postgresql.org
Subject: Re: Version 7 question
Date: 01 Jul 2003 08:52:26 -0400
Message-ID: <1057063946.24304.377.camel@camel> (raw)
In-Reply-To: <5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk>
References: <5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk>
On Tue, 2003-07-01 at 08:10, Hilary Forbes wrote:
> I'm just trying to improve performance on version 7 before doing some
tests and hopefully upgrading to 7.3.
>
> At the moment we have
> B=64 (no of shared buffers)
> N=32 (no of connections)
> in postmaster.opt which I take it is the equivalent of the new
postgresql.conf file.
>
> From all that is being written about later versions I suspect that
>this is far too low. Would I be fairly safe in making the no of shared
>buffers larger?
yes, I'd say start with about 25% of RAM, then adjust from there. If 25%
takes you over your SHMMAX then start at your SHMMAX.
>Also is there an equivalent of effective_cache_size that I can set for
>version 7?
>
If by 7 your mean 7.0.x then I don't believe so, been awhile though, I
could be wrong. IMHO no amount of tuning you can do in 7.0 would be as
effective as an upgrade, after setting your shared buffers up, I'd put
your efforts into upgrading. (Note Beta test for 7.4 starts in 2 weeks)
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
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: xzilla@users.sourceforge.net, hforbes@dmr.co.uk
Subject: Re: Version 7 question
In-Reply-To: <1057063946.24304.377.camel@camel>
References: <5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk> <1057063946.24304.377.camel@camel>
* 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