Re: Version 7 question

Hi Hillary,

I'd suggest around 1000 to 2000 shared buffers and bump your max connections
to at least 64.

Make sure you're kernel allowed enough shared memory for the above (2000 *
8k = 16MB)

Chris

----- Original Message -----
From: "Hilary Forbes" <hforbes(at)dmr(dot)co(dot)uk>
To: <pgsql-performance(at)postgresql(dot)org>
Sent: Tuesday, July 01, 2003 8:10 PM
Subject: [PERFORM] Version 7 question

> 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? Also is there an equivalent of effective_cache_size that I can set
for version 7?
>
> Many thanks in advance
> Hilary
>
>
>
>
> Hilary Forbes
> -------------
> DMR Computer Limited: http://www.dmr.co.uk/
> Direct line: 01689 889950
> Switchboard: (44) 1689 860000 Fax: (44) 1689 860330
> E-mail: hforbes(at)dmr(dot)co(dot)uk
>
> **********************************************************
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>