От: Robert Treat
Тема: Re: Version 7 question
Дата: ,
Msg-id: 1057063946.24304.377.camel@camel
(см: обсуждение, исходный текст)
Ответ на: Version 7 question  (Hilary Forbes)
Ответы: Re: Version 7 question  ("Michael Mattox")
Список: 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", )

On Tue, 2003-07-01 at 08:10, Hilary Forbes wrote:
> 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?

yes, I'd say start with about 25% of RAM, then adjust from there. If 25%
takes you over your SHMMAX then start at your SHMMAX.

>Also is there an equivalent of effective_cache_size that I can set for
>version 7?

If by 7 your mean 7.0.x then I don't believe so, been awhile though, I
could be wrong.  IMHO no amount of tuning you can do in 7.0 would be as
effective as an upgrade, after setting your shared buffers up, I'd put
your efforts into upgrading. (Note Beta test for 7.4 starts in 2 weeks)

Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

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

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