Skip site navigation (1)Skip section navigation (2)
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>