From owner-freebsd-database@FreeBSD.ORG Tue Jul 22 23:23:07 2003 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7BC8637B401; Tue, 22 Jul 2003 23:23:07 -0700 (PDT) Received: from bluejay.mail.pas.earthlink.net (bluejay.mail.pas.earthlink.net [207.217.120.218]) by mx1.FreeBSD.org (Postfix) with ESMTP id BA7BB43F3F; Tue, 22 Jul 2003 23:23:06 -0700 (PDT) (envelope-from tlambert2@mindspring.com) Received: from user-2ivfkao.dialup.mindspring.com ([165.247.209.88] helo=mindspring.com) by bluejay.mail.pas.earthlink.net with asmtp (SSLv3:RC4-MD5:128) (Exim 3.33 #1) id 19fD1i-0001ya-00; Tue, 22 Jul 2003 23:23:03 -0700 Message-ID: <3F1E297E.70962D97@mindspring.com> Date: Tue, 22 Jul 2003 23:21:50 -0700 From: Terry Lambert X-Mailer: Mozilla 4.79 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: Christopher Weimann References: <200307191818.13516.paul@pathiakis.com> <20030720110939.GN24507@perrin.int.nxad.com> <20030720164237.GC55392@nasby.net> <20030722143449.B10666@smtp.k12us.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-ELNK-Trace: b1a02af9316fbb217a47c185c03b154d40683398e744b8a45cc5ac0d552399a086f2d627dc4ddc34350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c cc: Sean Chittenden cc: freebsd-database@freebsd.org cc: freebsd-performance@freebsd.org cc: Paul Pathiakis Subject: Re: Tuning for PostGreSQL Database X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 23 Jul 2003 06:23:07 -0000 Christopher Weimann wrote: > On Sun 07/20/2003-01:53:39PM -0700, Sean Chittenden wrote: > > You might want to get in the habit of using sysctl for getting that > > kind of info. `sysctl -d vfs.bufspace` > > I'm confused. Everything I have ever read about FreeBSD indicates > that it uses all free ram for the disk cache. FreeBSD uses all unwired free memory for caching. Wired free memory has, by definition, been committed to a type-stable zone, and is therefore unavailable for reallocation, since it may have been (probably *has* been) fragmented into sub-page-size fragments that cannot be recoelesced into pages, even if they are all free, so that they can be given back to the system. There are some types of kernel allocations that are recoverable (e.g. buffer cache entries/VM), but most allocations use the zone allocator, and once it owns a page's soul, that page belongs to it forever. You should read Matt Dillon's excellent VM articles in the Blue Prints column at http://www.daemonnews.org/ for more information. -- Terry