From owner-freebsd-database@FreeBSD.ORG Wed Oct 1 00:46:27 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 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-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: 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-- From owner-freebsd-database@FreeBSD.ORG Wed Oct 1 07:42:22 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 0741516A4B3 for ; Wed, 1 Oct 2003 07:42:22 -0700 (PDT) Received: from hotmail.com (law11-oe64.law11.hotmail.com [64.4.16.199]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4B59C43FBD for ; Wed, 1 Oct 2003 07:42:21 -0700 (PDT) (envelope-from phillipsd@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 1 Oct 2003 07:42:21 -0700 Received: from 217.43.64.95 by law11-oe64.law11.hotmail.com with DAV; Wed, 01 Oct 2003 14:42:20 +0000 X-Originating-IP: [217.43.64.95] X-Originating-Email: [phillipsd@hotmail.com] From: "Darren Phillips" To: Date: Wed, 1 Oct 2003 15:41:23 +0100 MIME-Version: 1.0 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: X-OriginalArrivalTime: 01 Oct 2003 14:42:21.0212 (UTC) FILETIME=[385CDDC0:01C3882A] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.1 Subject: Shared memory in 5.1 with sybase 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: Wed, 01 Oct 2003 14:42:22 -0000 Have installed the freely available sybase 12.5 linux edition on my 5.1 = system but get the following error messages on building a db server ... kernel Checked out license ASE_DEV kernel Adaptive Server Enterprise Developer Edition. kernel Using config area from primary master device. kernel Warning: Using default file '/usr/local/sybase12.5/dan.cfg' = since a configuration file was not specified. Specify a configuration = file name in the RUNSERVER file to avoid this message. kernel os_create_region: can't allocate 37126144 bytes kernel kbcreate: couldn't create kernel region. kernel kistartup: could not create shared memory I've trawled the web and seen other posts and suggestions to the effect = that shared memory settings can be changed. However, not for 5.1 I don't see any obviously useful options in the GENERIC/NOTES files for = kernel recompilation.=20 Any useful information/pointers would be warmly received. From owner-freebsd-database@FreeBSD.ORG Thu Oct 2 00:57:03 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 2531416A4B3 for ; Thu, 2 Oct 2003 00:57:03 -0700 (PDT) Received: from light.sdf.com (light.sdf.com [207.200.153.231]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0105A43FBD for ; Thu, 2 Oct 2003 00:57:02 -0700 (PDT) (envelope-from tom@sdf.com) Received: from tom (helo=localhost) by light.sdf.com with local-esmtp (Exim 4.22) id 1A4yKn-0005Uk-8z; Thu, 02 Oct 2003 00:57:13 -0700 Date: Thu, 2 Oct 2003 00:57:13 -0700 (PDT) From: Tom To: Darren Phillips In-Reply-To: Message-ID: <20031002005322.M82361@light.sdf.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: freebsd-database@freebsd.org Subject: Re: Shared memory in 5.1 with sybase 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, 02 Oct 2003 07:57:03 -0000 On Wed, 1 Oct 2003, Darren Phillips wrote: ... > kernel os_create_region: can't allocate 37126144 bytes > kernel kbcreate: couldn't create kernel region. > kernel kistartup: could not create shared memory > > I've trawled the web and seen other posts and suggestions to the effect > that shared memory settings can be changed. However, not for 5.1 ... I think you missed the part that shared memory settings are totally dynamic in 5.x, so there are no kernel compile options for them anymore. Actually, they were dynamic in 4.8+ as well, but the kernel compile options still exist. Now I forget which variables in the kern.ipc.* sysctl corespond to which SysV shared memory and semphore settings though... Tom