From owner-cvs-all@FreeBSD.ORG Wed Oct 1 00:26:32 2003 Return-Path: Delivered-To: cvs-all@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id CBB7016A4B3; Wed, 1 Oct 2003 00:26:32 -0700 (PDT) Received: from perrin.nxad.com (internal.nxad.com [69.1.70.251]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2D9F243FDF; Wed, 1 Oct 2003 00:26:32 -0700 (PDT) (envelope-from sean@nxad.com) Received: by perrin.nxad.com (Postfix, from userid 1001) id 95B392106D; Wed, 1 Oct 2003 00:26:31 -0700 (PDT) Date: Wed, 1 Oct 2003 00:26:31 -0700 From: Sean Chittenden To: ports-committers@FreeBSD.org, cvs-ports@FreeBSD.org, cvs-all@FreeBSD.org Message-ID: <20031001072631.GA64328@perrin.nxad.com> References: <200310010721.h917LfPe069496@repoman.freebsd.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200310010721.h917LfPe069496@repoman.freebsd.org> 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: databases@freebsd.org Subject: Re: cvs commit: ports/databases/postgresql-devel Makefile distinfo pkg-message pkg-plist X-BeenThere: cvs-all@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: CVS commit messages for the entire tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 01 Oct 2003 07:26:33 -0000 > seanc 2003/10/01 00:21:41 PDT > > FreeBSD ports repository > > Modified files: > databases/postgresql-devel Makefile distinfo pkg-message > pkg-plist > Log: > Update to the latest snapshot for 7.4beta3. Mostly bug fixes, but the > most significant change is the ability to change PostgreSQL's block size > with the nob: WITH_PGBLOCKSIZE=("16K"|"32K"). Release notes: > > http://developer.postgresql.org/docs/postgres/release.html#RELEASE-DEVEL For those with hardware and testing time to burn, I'm particularly interested in knowing if someone notices one of these sizes performs better form them or not. Some have found the bigger block sizes to speed up some types of work loads anywhere from 10-25%, others have found no difference. Any data that people have on this would be of interest to me and I would greatly appreciate hearing about anyones results. Please note that changing block sizes should be done with care and will result in the need to dump/initdb/reload and can create incompatibilities between databases/postgresql-devel and databases/postgresql7. -sc -- Sean Chittenden