От: Hilary Forbes
Тема: Version 7 question
Дата: ,
(см: обсуждение, исходный текст)
Ответы: Re: Version 7 question  ("Michael Mattox")
Re: Version 7 question  (Robert Treat)
Список: pgsql-performance

Скрыть дерево обсуждения

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

Many thanks in advance

Hilary Forbes
DMR Computer Limited:   http://www.dmr.co.uk/
Direct line:  01689 889950
Switchboard:  (44) 1689 860000  Fax: (44) 1689 860330


В списке pgsql-performance по дате сообщения:

От: Howard Oblowitz
Сообщение: Effective Cache Size
От: "scott.marlowe"
Сообщение: Re: Version 7 question