Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3DE9C9FB2CB for ; Wed, 17 Oct 2007 22:34:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12912-04 for ; Wed, 17 Oct 2007 22:34:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wdscexfe02.sc.wdc.com (wdscexfe02.sc.wdc.com [129.253.170.52]) by postgresql.org (Postfix) with ESMTP id 87B4F9FA690 for ; Wed, 17 Oct 2007 22:34:09 -0300 (ADT) Received: from wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) by wdscexfe02.sc.wdc.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 17 Oct 2007 18:33:51 -0700 Received: from 129.253.107.230 ([129.253.107.230]) by wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) with Microsoft Exchange Server HTTP-DAV ; Thu, 18 Oct 2007 01:33:48 +0000 Received: from neuromancer by 129.253.105.55; 18 Oct 2007 09:33:46 +0800 Subject: Re: Shared Buffer setting in postgresql.conf From: Ow Mun Heng To: Scott Marlowe Cc: Radhika S , pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Thu, 18 Oct 2007 09:33:46 +0800 Message-Id: <1192671226.27637.8.camel@neuromancer.home.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 X-OriginalArrivalTime: 18 Oct 2007 01:33:51.0713 (UTC) FILETIME=[F03EB510:01C81126] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.761 tagged_above=0 required=5 tests=AWL=-0.196, BAYES_05=-1.11, RCVD_NUMERIC_HELO=2.067 X-Spam-Level: X-Archive-Number: 200710/214 X-Sequence-Number: 27236 On Wed, 2007-10-10 at 19:49 -0500, Scott Marlowe wrote: > On 10/10/07, Radhika S wrote: > > Thank you scott. > > > > We plan on upgrading to Postgres 8.2 very soon. > > Would it be safe to say I can make my SHARED BUFFER setting 200MB (I have > > 2GB memory ). > > The default is 24MB. > > On a dedicated db machine with 2 Gigs of ram 500Meg is fine. I run > 768 Meg shared_buffers on a machine that runs postgresql 8.2 and > apache/php and routinely have 1Gig of kernel cache on it. > > So yeah, 200M shared_buffers should be no problem. I have 768MB of ram and I'm allocatting 300MB as shared buffers.