From owner-freebsd-performance@FreeBSD.ORG  Thu Aug  4 17:49:36 2005
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
X-Original-To: freebsd-performance@freebsd.org
Delivered-To: freebsd-performance@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id F24D816A41F
	for <freebsd-performance@freebsd.org>;
	Thu,  4 Aug 2005 17:49:35 +0000 (GMT)
	(envelope-from bmw@borderware.com)
Received: from mail.borderware.com (mail.borderware.com [207.236.65.231])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 797B343D45
	for <freebsd-performance@freebsd.org>;
	Thu,  4 Aug 2005 17:49:34 +0000 (GMT)
	(envelope-from bmw@borderware.com)
Message-ID: <42F25526.5030002@borderware.com>
Date: Thu, 04 Aug 2005 13:49:26 -0400
From: Bruce Walker <bmw@borderware.com>
Organization: BorderWare Technologies Inc.
User-Agent: Mozilla Thunderbird 1.0.6 (Macintosh/20050716)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Sean Chittenden <sean@gigave.com>
References: <b41c755205080410013348d0f@mail.gmail.com>
	<20050804174508.GA70123@sean.gigave.com>
In-Reply-To: <20050804174508.GA70123@sean.gigave.com>
Content-Type: multipart/mixed; boundary="------------080704000904040802050609"
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Cc: freebsd-performance@freebsd.org
Subject: Re: changing max_connections in postgresql on FreeBSD 5.4
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>,
	<mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 04 Aug 2005 17:49:36 -0000

This is a multi-part message in MIME format.
--------------080704000904040802050609
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Sean Chittenden wrote:

>>Will more RAM become available to postgresql if I change the
>>kernel-values mentioned above to half the size?
>>    
>>
>
>Yes, it will raise the in-kernel limits so that PostgreSQL can
>allocate more RAM for its user-land cache.
>
>You will probably have a better ROI in terms of performance by
>increasing the kernel's caching parameters as opposed to PostgreSQL's
>cache.  You need both, don't get me wrong, but there is lots of
>performance to be gained by increasing the amount of caching the
>kernel does.  -sc
>  
>

Any generally good rules of thumb you could share?  Which kernel caching 
are you referring to (ie disk, ...) ?

Thanks!




--------------080704000904040802050609--