X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 23F66D1B517 for ; Mon, 13 Oct 2003 19:10:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14772-07 for ; Mon, 13 Oct 2003 16:10:21 -0300 (ADT) Received: from perrin.nxad.com (internal.nxad.com [69.1.70.251]) by svr1.postgresql.org (Postfix) with ESMTP id 7B3EFD1B50E for ; Mon, 13 Oct 2003 16:10:22 -0300 (ADT) Received: by perrin.nxad.com (Postfix, from userid 1001) id 4AB082106B; Mon, 13 Oct 2003 12:10:23 -0700 (PDT) Date: Mon, 13 Oct 2003 12:10:23 -0700 From: Sean Chittenden To: Josh Berkus Cc: Christopher Kings-Lynne , Nick Barr , pgsql-performance@postgresql.org Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL Message-ID: <20031013191023.GB72842@perrin.nxad.com> References: <007901c38f2b$0b585590$2802a8c0@webbased10> <3F8819EF.7010004@chuckie.co.uk> <3F88BFD7.1020808@familyhealth.com.au> <200310121331.42693.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200310121331.42693.josh@agliodbs.com> 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 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/428 X-Sequence-Number: 4176 > > > PostgreSQL requires some more shared memory to cache some > > > tables, x Mb, do you want to increase your OS kernel parameters? > > > > > > Tweak shmmax and shmmall > > > > Note that this still requires a kernel recompile on FreeBSD :( > > Not our fault, now is it? This would mean that we wouldn't be able > to script for FreeBSD. Bug the FreeBSD developers. And if you do so, you're going to hear that shm* is an antiquated interface that's dated, slow, inefficient and shouldn't be used. :) Every few months one of the uber core BSD hackers threatens to rewrite that part of PG because high up in the BSD camp, it's common belief that shm* is a source of performance loss for PostgreSQL. One of these days it'll happen, probably with mmap() mmap()'ing MAP_SHARED files stored in a $PGDATA/data/shared dir as mmap() is by far and away the fastest shared memory mechanism and certainly is very widely deployed (I would be surprised if any of the supported PG platforms didn't have mmap()). -sc -- Sean Chittenden