Re: Howto Increased performace ?

От: Ragnar Hafstað
Тема: Re: Howto Increased performace ?
Дата: ,
Msg-id: 1103902772.4447.5.camel@localhost.localdomain
(см: обсуждение, исходный текст)
Ответ на: Howto Increased performace ?  ("Amrit Angsusingh")
Список: pgsql-performance

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

Howto Increased performace ?  ("Amrit Angsusingh", )
 Re: Howto Increased performace ?  (Ragnar Hafstað, )
 Re: Howto Increased performace ?  ("Iain", )
 Re: Howto Increased performace ?  ("Iain", )
  Re: Howto Increased performace ?  (Cosimo Streppone, )
 Re: Howto Increased performace ?  (Ragnar Hafstað, )
 Re: Howto Increased performace ?  ("Iain", )
 Re: Howto Increased performace ?  ("Iain", )
 Re: Howto Increased performace ?  ("Iain", )

On Tue, 2004-12-21 at 16:31 +0700, Amrit Angsusingh wrote:
> I used postgresql 7.3.2-1 with RH 9 on a mechine of 2 Xeon 3.0 Ghz and ram
> of 4 Gb. Since 1 1/2 yr. when I started to use the database server after
> optimizing the postgresql.conf everything went fine until a couple of
> weeks ago , my database grew up to 3.5 Gb and there were more than 140
> concurent connections.
...
> shared_buffers = 250000
this is much higher than usually adviced on this list.
try to reduce this to 25000

> effective_cache_size = 5000
and increase this instead, to say, 50000


gnari




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

От: Ragnar Hafstað
Дата:
Сообщение: Re: Speed in V8.0
От: "Iain"
Дата:
Сообщение: Re: Howto Increased performace ?