From owner-freebsd-database@FreeBSD.ORG Thu Aug 28 15:51:46 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 E5BF416A4BF for ; Thu, 28 Aug 2003 15:51:46 -0700 (PDT) Received: from perrin.nxad.com (internal.ext.nxad.com [69.1.70.251]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6722A43FF7 for ; Thu, 28 Aug 2003 15:51:46 -0700 (PDT) (envelope-from sean@nxad.com) Received: by perrin.nxad.com (Postfix, from userid 1001) id D9DC220F01; Thu, 28 Aug 2003 15:51:45 -0700 (PDT) Date: Thu, 28 Aug 2003 15:51:45 -0700 From: Sean Chittenden To: Claus Guttesen Message-ID: <20030828225145.GS83759@perrin.nxad.com> References: <20030828171955.GE83759@perrin.nxad.com> <20030828204032.97741.qmail@web14102.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030828204032.97741.qmail@web14102.mail.yahoo.com> X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ User-Agent: Mutt/1.5.4i cc: freebsd-database@freebsd.org Subject: Re: Some additional tests run on my performance testing 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: Thu, 28 Aug 2003 22:51:47 -0000 > I'm implementing postgresql 7.3.4 on FreeBSD 5.1, and decided to > place the pgsql-folder on it's own partition so it was easier to > test which blocksize to go for. > > So I newfs'ed it with 8 and 16 kb blocksize did an import of a 1.5 > GB pg-dump. Did you change the block size of PostgreSQL as well, or just of the file system? Could you try changing the block size of PostgreSQL so that it matches the block size of the FS? -sc -- Sean Chittenden