Re: Howto Increased performace ?

From: Ragnar Hafstað
Subject: Re: Howto Increased performace ?
Date: ,
Msg-id: 1103902772.4447.5.camel@localhost.localdomain
(view: Whole thread, Raw)
In response to: Howto Increased performace ?  ("Amrit Angsusingh")
List: pgsql-performance

Tree view

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 by date:

From: Ragnar Hafstað
Date:
Subject: Re: Speed in V8.0
From: "Iain"
Date:
Subject: Re: Howto Increased performace ?