X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A0640D1B184 for ; Thu, 15 Jul 2004 23:55:45 -0300 (ADT) 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 97690-01 for ; Fri, 16 Jul 2004 02:55:45 +0000 (GMT) Received: from davinci.ethosmedia.com (server226.ethosmedia.com [209.128.84.226]) by svr1.postgresql.org (Postfix) with ESMTP id 8C90FD1B1C7 for ; Thu, 15 Jul 2004 23:55:39 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 5770287 for pgsql-performance@postgresql.org; Thu, 15 Jul 2004 19:56:54 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Subject: Re: hardware raid suggestions Date: Thu, 15 Jul 2004 19:55:29 -0700 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200407151955.29586.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/104 X-Sequence-Number: 7495 Brian, > We're looking into getting an Adaptec 2200S or the Megaraid 320 2x > which have better processors, and hopefully better performance. We > feel that the use of the AIC7930 as the CPU on the ZCR just doesn't > cut it and a faster raid controller would work better. Does anyone out > there have any experience with these cards with postgresql and linux? > If so, would you be willing to share your experiences and possibly give > a recommendation? Yes, my experience with adaptecs has been universally bad. I just really don't think that "the SCSI-2 card company" is up to making high-end raid cards. MegaRaid is generally positively reviewed in a lot of places. Be careful to order the battery back-up at the same time as the Raid card; the batteries have the annoying habit of going off the market for months at a time. You should also consider looking into driver issues. In general, the RAID card drivers distributed for Linux simply aren't as good as those the same companies write for Windows or Unix. That may be your issue with the ZCR, as well as CPU. Oh, and don't bother with the upgrade if you're not getting battery backup. You need it. -- Josh Berkus Aglio Database Solutions San Francisco