X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 721563AB3F1 for ; Wed, 15 Dec 2004 03:35:11 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 85610-05 for ; Wed, 15 Dec 2004 03:34:57 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id 16BC83AB3C6 for ; Wed, 15 Dec 2004 03:34:58 +0000 (GMT) Received: from [192.168.0.100] (c-24-5-74-176.client.comcast.net[24.5.74.176]) by comcast.net (sccrmhc12) with ESMTP id <2004121503345501200ifdv7e>; Wed, 15 Dec 2004 03:34:56 +0000 Message-ID: <41BFB085.6010102@talisys.com> Date: Tue, 14 Dec 2004 19:33:25 -0800 From: William Yu User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Iain Cc: pgsql-admin@postgresql.org Subject: Re: Tyan Thunder MB for postgres server References: <021a01c4e0dc$774d0620$7201a8c0@mst1x5r347kymb> <41BDB10A.6000200@did-it.com> <00bf01c4e17c$db69e100$7201a8c0@mst1x5r347kymb> <1103038201.22049.14.camel@state.g2switchworks.com> <000b01c4e24a$43deaae0$7201a8c0@mst1x5r347kymb> In-Reply-To: <000b01c4e24a$43deaae0$7201a8c0@mst1x5r347kymb> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/132 X-Sequence-Number: 15718 Iain wrote: > Thanks to all for your feedback on this. > > I'm looking forward to getting my hands on the system. > > It seems that the battery backed cache is an important factor, though I > havn't found any information specifically concerning this on the tyan > site. I can't tell if it's an option or standard with the integrated > SCSI controller. RAID may be an option with your motherboard. LSI Logic has a MegaRAID 320-0 which interfaces with integrated MB SCSI. http://www.lsilogic.com/products/megaraid/scsi_320_0.html They don't list any Tyan's as "certified" so I dunno. Perhaps you should look into a Tyan w/o integrated SCSI and just get the MegaRAID 320-1 or 320-2 to avoid any possible issues. > I don't have much experience with building this kind of server (i'm more > on the development side) but I know basically what I want and that is > RAID 0+1 and battery backed cache. The target OS is RHEL ES 3 (AMD64 > platform) and I guess that it doesn't matter if the RAID is hardware or > software (or a combination of both?) but if you think I've missed > anything, please let me know. Hardware RAID + battery lets you turn write caching on. For a DB with lots of updates, it can make a big difference.