Skip site navigation (1) Skip section navigation (2)

Re: Howto Increased performace ?

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: Amrit Angsusingh <amrit(at)spr(dot)go(dot)th>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Howto Increased performace ?
Date: 2004-12-24 15:39:32
Message-ID: 1103902772.4447.5.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-performance
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



In response to

pgsql-performance by date

Next:From: Ragnar HafstaðDate: 2004-12-24 15:45:10
Subject: Re: Speed in V8.0
Previous:From: Matt ClarkDate: 2004-12-24 14:52:11
Subject: Re: Speed in V8.0

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group