From owner-freebsd-database@FreeBSD.ORG Thu Aug 28 16:28:12 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 098F016A4BF; Thu, 28 Aug 2003 16:28:12 -0700 (PDT) Received: from perrin.nxad.com (internal.ext.nxad.com [69.1.70.251]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6328944005; Thu, 28 Aug 2003 16:28:11 -0700 (PDT) (envelope-from sean@nxad.com) Received: by perrin.nxad.com (Postfix, from userid 1001) id C2B9421058; Thu, 28 Aug 2003 16:28:10 -0700 (PDT) Date: Thu, 28 Aug 2003 16:28:10 -0700 From: Sean Chittenden To: "Jim C. Nasby" Message-ID: <20030828232810.GU83317@perrin.nxad.com> References: <20030827060644.GA9321@HAL9000.homeunix.com> <20030827174448.GB72378@perrin.nxad.com> <20030828232155.GM28207@nasby.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030828232155.GM28207@nasby.net> 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 cc: freebsd-performance@FreeBSD.ORG cc: Robert Watson Subject: Re: Performance tests I did with FreeBSD, Linux and PostgreSQL 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 23:28:12 -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. Absolutely... I guess I posted that bit to the pgsql-hackers list. I'm pretty sure I'm going to bump things in the -devel port and am going to talk with Palle regarding this when 7.4 comes out that way it will, as you state, be along major version bumps. > 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. Talked to Tom, PostgreSQL isn't stupid and does the right thing: it bombs out before doing any work. -sc -- Sean Chittenden