X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ADE3C11F660E for ; Thu, 27 Apr 2006 15:44:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 11093-06 for ; Thu, 27 Apr 2006 15:43:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from galaxy.systems.pipex.net (galaxy.systems.pipex.net [62.241.162.31]) by postgresql.org (Postfix) with ESMTP id 3D74C11F60E3 for ; Thu, 27 Apr 2006 15:43:47 -0300 (ADT) Received: from flange.edesix.com (81-86-64-236.dsl.pipex.com [81.86.64.236]) by galaxy.systems.pipex.net (Postfix) with ESMTP id B198EE000434 for ; Thu, 27 Apr 2006 19:43:44 +0100 (BST) Received: from host86-131-245-51.range86-131.btcentralplus.com ([86.131.245.51] helo=[192.168.101.208]) by flange.edesix.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.50) id 1FZBSp-0001fq-NJ for pgsql-admin@postgresql.org; Thu, 27 Apr 2006 19:43:43 +0100 Message-ID: <445110EA.9050703@edesix.com> Date: Thu, 27 Apr 2006 19:43:54 +0100 From: Robin Iddon User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: New system recommendations References: <8511B4970E0D124898E973DF496F9B432515CF@stash.stackdump.local> <1146160194.23538.313.camel@state.g2switchworks.com> In-Reply-To: <1146160194.23538.313.camel@state.g2switchworks.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/312 X-Sequence-Number: 21481 > Anytime you're looking at a high write load on a database (not just > PostgreSQL) you should be looking at a hardware RAID controller with > battery backed cache and RAID 1 or RAID 1+0. > We recently benchmarked the latest and greatest PCI-X SATA mega raid controller (with NCQ support, so approaching SCSI performance) and we found it was no faster than running s/w RAID-1 on a dual-core P4 with the 2.6 series kernel. It would no doubt offer an advantage on running RAID-5 or any other RAID scheme that required XOR computation, but we don't want to use RAID-5. However we did not fit the Transportable Battery Backup Unit and so we didn't measure the benefit of early commit to the cache (fsync() returns early, data is written to disk later, battery keeps data safe in the meanwhile). I plan on repeating the experiment again later on in May once we have a TBBU and will post the results here if anyone is interested. Best wishes, Robin