From owner-freebsd-stable@FreeBSD.ORG Wed May 24 20:47:48 2006 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 026F516A695 for ; Wed, 24 May 2006 20:47:48 +0000 (UTC) (envelope-from vivek@khera.org) Received: from yertle.kcilink.com (yertle.kcilink.com [65.205.34.180]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9A22743D48 for ; Wed, 24 May 2006 20:47:47 +0000 (GMT) (envelope-from vivek@khera.org) Received: from [192.168.7.103] (host-103.int.kcilink.com [192.168.7.103]) by yertle.kcilink.com (Postfix) with ESMTP id 9DCE8B826 for ; Wed, 24 May 2006 16:47:46 -0400 (EDT) Mime-Version: 1.0 (Apple Message framework v750) In-Reply-To: <200605241114.52666.kirk@strauser.com> References: <200605231531.18092.kirk@strauser.com> <42A89ED6-54B7-43EC-832B-A54F76C0D17B@khera.org> <200605241114.52666.kirk@strauser.com> Content-Type: multipart/signed; micalg=sha1; boundary=Apple-Mail-11-545257533; protocol="application/pkcs7-signature" Message-Id: From: Vivek Khera Date: Wed, 24 May 2006 16:47:45 -0400 To: FreeBSD Stable X-Mailer: Apple Mail (2.750) X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: Re: PostgreSQL uses more memory on 6.1? X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 24 May 2006 20:47:48 -0000 --Apple-Mail-11-545257533 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On May 24, 2006, at 12:14 PM, Kirk Strauser wrote: > Is any of this stuff well documented other than in NOTES? I can > see what > each setting does, but don't really have a feel for *why* I'd need to > increase a given setting, what the drawback is to increasing it, or > why it > was so low in the first place. SYSV IPC falls into the black art part of the universe, unfortunately. You really have to dig into the application (ie, postgres in this case) to determine how much of those resources it wants. > > For that matter, why does this stuff have to be manually configured? > Couldn't the kernel automatically expand a lot of these numbers as > needed? Some are only settable at boot time because they make fixed sized structures (yes, still in this day and age...) I don't know the drawbacks of making them larger than necessary, but with multi-gig RAM servers I don't worry about it too much. --Apple-Mail-11-545257533--