From owner-freebsd-performance@FreeBSD.ORG Wed Jul 30 07:35:53 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 A72A237B401 for ; Wed, 30 Jul 2003 07:35:53 -0700 (PDT) Received: from limes.kompakt.com.pl (limes.kompakt.com.pl [195.164.48.229]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1304743F3F for ; Wed, 30 Jul 2003 07:35:51 -0700 (PDT) (envelope-from meritus@wp.pl) Received: (from root@localhost) by limes.kompakt.com.pl (8.11.6/8.11.2) id h6UDpGa07796 for freebsd-performance@freebsd.org.AVP; Wed, 30 Jul 2003 15:51:16 +0200 Received: from ryba.kompakt.pl (finis.kompakt.pl [195.164.48.227]) by limes.kompakt.com.pl (8.11.6/8.11.2) with ESMTP id h6UDpEK07788 for ; Wed, 30 Jul 2003 15:51:15 +0200 From: Piotr Organization: Rybicki To: freebsd-performance@freebsd.org Date: Wed, 30 Jul 2003 16:35:49 +0200 User-Agent: KMail/1.5.2 References: <200307191818.13516.paul@pathiakis.com> In-Reply-To: <200307191818.13516.paul@pathiakis.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Disposition: inline Message-Id: <200307301635.49791.meritus@wp.pl> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by limes.kompakt.com.pl id h6UDpEK07788 X-Mailman-Approved-At: Fri, 01 Aug 2003 23:10:23 -0700 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: Wed, 30 Jul 2003 14:35:54 -0000 Dnia nie 20. lipca 2003 00:18, Paul Pathiakis napisał: > Hi, > Are there optimal parameters for sizing on the disk throughput? That is, > newfs parameters, i-node configuration, tunefs parameters, async on the > drives, etc? (consider nothing trivial, please feel free to just lay into > this like I'm a newbie - considering my not-so-extensive experience with > PostgreSQL) About newfs parameters i suggest to use: - block size = 8 Kb - fragment size = 8 Kb Setting theese parameters on database partition should minimize filesystem overhead since PostgreSQL stores it's database data in 8Kb chunks. But actually it's just a theory. I didn't make any test to proove the benefits. Regards Piotr Rybicki