From owner-freebsd-performance@FreeBSD.ORG Sun Jul 20 09:42:44 2003 Return-Path: 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 0CB7C37B401 for ; Sun, 20 Jul 2003 09:42:44 -0700 (PDT) Received: from flake.decibel.org (flake.decibel.org [66.143.173.58]) by mx1.FreeBSD.org (Postfix) with SMTP id D21BB43FAF for ; Sun, 20 Jul 2003 09:42:42 -0700 (PDT) (envelope-from decibel@decibel.org) Received: (qmail 15151 invoked by uid 1001); 20 Jul 2003 16:42:37 -0000 Date: Sun, 20 Jul 2003 11:42:37 -0500 From: "Jim C. Nasby" To: Sean Chittenden Message-ID: <20030720164237.GC55392@nasby.net> References: <200307191818.13516.paul@pathiakis.com> <20030720110939.GN24507@perrin.int.nxad.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030720110939.GN24507@perrin.int.nxad.com> User-Agent: Mutt/1.4.1i X-Operating-System: FreeBSD 4.8-RELEASE i386 X-Distributed: Join the Effort! http://www.distributed.net cc: freebsd-database@freebsd.org cc: freebsd-performance@freebsd.org cc: Paul Pathiakis Subject: Re: Tuning for PostGreSQL Database X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 20 Jul 2003 16:42:44 -0000 On Sun, Jul 20, 2003 at 04:09:39AM -0700, Sean Chittenden wrote: > > Are there optimal parameters for sizing on the disk > > throughput? > > Increase your file system cache. How? I've been wondering if there's a way to do this, and all the settings I've played with seem to have no effect; it just sits at 199BUF according to top. -- Jim C. Nasby, Database Consultant jim@nasby.net Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"