Version 7 question

From: Hilary Forbes
Subject: Version 7 question
Date: ,
Msg-id: 5.1.0.14.0.20030701125931.02040fa0@mailserver.ipl.co.uk
(view: Whole thread, Raw)
Responses: Re: Version 7 question  ("Michael Mattox")
Re: Version 7 question  (Robert Treat)
List: pgsql-performance

Tree view

Version 7 question  (Hilary Forbes, )
 Re: Version 7 question  ("Michael Mattox", )
  Re: Version 7 question  ("scott.marlowe", )
 Re: Version 7 question  (Robert Treat, )
  Re: Version 7 question  ("Michael Mattox", )
   Re: Version 7 question  (Manfred Koizar, )
 Re: Version 7 question  ("Christopher Kings-Lynne", )

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
makingthe 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:  

**********************************************************



pgsql-performance by date:

From: Howard Oblowitz
Date:
Subject: Effective Cache Size
From: "scott.marlowe"
Date:
Subject: Re: Version 7 question