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

Reply via email to