From owner-freebsd-performance@FreeBSD.ORG Thu Aug 28 16:22:05 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 6E7F416A4BF for ; Thu, 28 Aug 2003 16:22:05 -0700 (PDT) Received: from flake.decibel.org (flake.decibel.org [66.143.173.58]) by mx1.FreeBSD.org (Postfix) with SMTP id 26AD543FF2 for ; Thu, 28 Aug 2003 16:22:00 -0700 (PDT) (envelope-from decibel@decibel.org) Received: (qmail 48019 invoked by uid 1001); 28 Aug 2003 23:21:55 -0000 Date: Thu, 28 Aug 2003 18:21:55 -0500 From: "Jim C. Nasby" To: Sean Chittenden Message-ID: <20030828232155.GM28207@nasby.net> References: <20030827060644.GA9321@HAL9000.homeunix.com> <20030827174448.GB72378@perrin.nxad.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030827174448.GB72378@perrin.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: David Schultz cc: Robert Watson cc: freebsd-performance@FreeBSD.ORG cc: Bill Moran Subject: Re: Performance tests I did with FreeBSD, Linux and PostgreSQL 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: Thu, 28 Aug 2003 23:22:05 -0000 Please do NOT commit this unless it accompanies a major version change! PGSQL goes to extremes to ensure that you only have to dump/reload on major version changes (ie: 7.2.x to 7.3.x), and it'd be really bad to surprise people with this. I think it would also be a very good idea to see what happens if you try and open a database with 8K pages using pgsql compiled for 16K pages. If it doesn't detect the error, I don't think it's worth doing this; it just seems too risky; though adding a config option to the port makefile would be a good alternative in that case. On Wed, Aug 27, 2003 at 10:44:48AM -0700, Sean Chittenden wrote: > Hrm, that sounds like a good idea to me. The appropriate patch is > included (src/include/pg_config_manual.h). I'll bounce this by the > PostgreSQL guys to see what their reaction is, but I'm inclined to > include this patch in the postgresql-devel port for now, and if things > go well there, possibly in the main postgresql7 port (pending > feedback). I haven't ever played with this setting before and would > welcome feedback from anyone who has (rergardless of their > results). -sc > > PS You have to re-initdb/reload your data after applying this patch > because the size of data on disk has changed. > > -- > Sean Chittenden > Index: src/include/pg_config_manual.h > =================================================================== > RCS file: /home/ncvs/pgsql/pgsql-server/src/include/pg_config_manual.h,v > retrieving revision 1.5 > diff -u -r1.5 pg_config_manual.h > --- src/include/pg_config_manual.h 4 Aug 2003 00:43:29 -0000 1.5 > +++ src/include/pg_config_manual.h 27 Aug 2003 17:40:12 -0000 > @@ -23,7 +23,7 @@ > * > * Changing BLCKSZ requires an initdb. > */ > -#define BLCKSZ 8192 > +#define BLCKSZ 16384 > > /* > * RELSEG_SIZE is the maximum number of blocks allowed in one disk > _______________________________________________ > freebsd-database@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-database > To unsubscribe, send any mail to "freebsd-database-unsubscribe@freebsd.org" -- 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?"