I have my shared buffers at 8192 and my effective cache at 64000 (which is 500 megs). Depends a lot on how much RAM you have. I have 1.5 gigs and I've been asking my boss for another 512megs for over a month now. I have no idea if my buffers are too high/low.
Michael > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Hilary > Forbes > Sent: Tuesday, July 01, 2003 2:10 PM > To: [EMAIL PROTECTED] > 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