From owner-freebsd-performance@FreeBSD.ORG Wed Oct 1 00:46:27 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 3F84F16A4B3; Wed, 1 Oct 2003 00:46:27 -0700 (PDT) Received: from perrin.nxad.com (internal.nxad.com [69.1.70.251]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3D90643FDF; Wed, 1 Oct 2003 00:46:26 -0700 (PDT) (envelope-from sean@nxad.com) Received: by perrin.nxad.com (Postfix, from userid 1001) id B24012107F; Wed, 1 Oct 2003 00:46:25 -0700 (PDT) Date: Wed, 1 Oct 2003 00:46:25 -0700 From: Sean Chittenden To: database@FreeBSD.org Message-ID: <20031001074625.GB64328@perrin.nxad.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="/04w6evG8XlLl3ft" Content-Disposition: inline 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: performance@FreeBSD.org Subject: [seanc@FreeBSD.org: Re: cvs commit: ports/databases/postgresql-devel Makefile distinfo pkg-message pkg-plist] 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: Wed, 01 Oct 2003 07:46:27 -0000 --/04w6evG8XlLl3ft Content-Type: text/plain; charset=us-ascii Content-Disposition: inline FWIW, I just updated postgresql-devel to the latest snapshot and as promised, I added the _ability_ to change postgresql-devel's block sizes to 16K or 32K. The default block size still remains at 8K. If you have hardware and testing time to burn, I'd be interested in anyone's results if someone decides to perform any kind of benchmarking with differing block sizes. 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. Info that's helpful include what version FreeBSD, file system info, UFS block sizes as well as PG block sizes, and basic info about your app that you used to test (50/50 read writes, 40/60, etc). Please note that changing block sizes should be done with care and will result in the need to dump/initdb/reload, and adjustment of postgresql.conf values (ex: effective_cache_size) that depend on 8K block sizes. Playing with PG's block sizes will create incompatibilities between databases/postgresql-devel and databases/postgresql7 if the block sizes differ. You have been warned. If you have any questions about this, please take up such discussions on the database@ list. -sc PS Valid values for WITH_PGBLOCKSIZE are "16K" or "32K" -- Sean Chittenden --/04w6evG8XlLl3ft Content-Type: message/rfc822 Content-Disposition: inline Return-Path: X-Original-To: sean@chittenden.org Delivered-To: sean@perrin.nxad.com Received: from mx2.freebsd.org (mx2.freebsd.org [216.136.204.119]) by perrin.nxad.com (Postfix) with ESMTP id B12612106D for ; Wed, 1 Oct 2003 00:27:24 -0700 (PDT) Received: from hub.freebsd.org (hub.freebsd.org [216.136.204.18]) by mx2.freebsd.org (Postfix) with ESMTP id F266A56019 for ; Wed, 1 Oct 2003 00:27:10 -0700 (PDT) (envelope-from owner-ports-committers@FreeBSD.org) Received: by hub.freebsd.org (Postfix) id C0B4216A4E6; Wed, 1 Oct 2003 00:27:06 -0700 (PDT) Delivered-To: seanc@freebsd.org Received: by hub.freebsd.org (Postfix, from userid 538) id 86FF616A4DF; Wed, 1 Oct 2003 00:27:05 -0700 (PDT) Delivered-To: ports-committers@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 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> 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 Sender: owner-ports-committers@FreeBSD.org Precedence: bulk X-Loop: FreeBSD.ORG > 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 --/04w6evG8XlLl3ft--