Date: Wed, 1 Oct 2003 00:26:31 -0700 From: Sean Chittenden <seanc@FreeBSD.org> To: ports-committers@FreeBSD.org, cvs-ports@FreeBSD.org, cvs-all@FreeBSD.org Cc: databases@freebsd.org Subject: Re: cvs commit: ports/databases/postgresql-devel Makefile distinfo pkg-message pkg-plist Message-ID: <20031001072631.GA64328@perrin.nxad.com> In-Reply-To: <200310010721.h917LfPe069496@repoman.freebsd.org> References: <200310010721.h917LfPe069496@repoman.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20031001072631.GA64328>