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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > ********************************************************** > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
