X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 26AB73B779F for ; Fri, 24 Dec 2004 15:38:32 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83970-02 for ; Fri, 24 Dec 2004 15:38:10 +0000 (GMT) Received: from quasar.skima.is (quasar.skima.is [212.30.200.205]) by svr1.postgresql.org (Postfix) with ESMTP id 89FBB3B7793 for ; Fri, 24 Dec 2004 15:38:12 +0000 (GMT) Received: from gnari ([157.157.180.107] [157.157.180.107]) by quasar.skima.is with ESMTP; Fri, 24 Dec 2004 15:38:12 Z Subject: Re: Howto Increased performace ? From: Ragnar =?ISO-8859-1?Q?Hafsta=F0?= To: Amrit Angsusingh Cc: pgsql-performance@postgresql.org In-Reply-To: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6> References: <2452.192.168.2.6.1103621509.squirrel@192.168.2.6> Content-Type: text/plain Date: Fri, 24 Dec 2004 15:39:32 +0000 Message-Id: <1103902772.4447.5.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/292 X-Sequence-Number: 9667 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