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 823FCD1B27A for ; Sat, 17 Jul 2004 00:20:40 -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 66551-05 for ; Sat, 17 Jul 2004 03:20:41 +0000 (GMT) Received: from redhotpenguin.com (www.redhotpenguin.com [64.127.99.50]) by svr1.postgresql.org (Postfix) with ESMTP id 53BAFD1B195 for ; Sat, 17 Jul 2004 00:20:35 -0300 (ADT) Received: (qmail 20523 invoked from network); 17 Jul 2004 03:20:40 -0000 Received: from localhost (HELO mail.redhotpenguin.com) (127.0.0.1) by localhost with SMTP; 17 Jul 2004 03:20:40 -0000 Received: from 67.116.52.35 (SquirrelMail authenticated user fred@redhotpenguin.com) by mail.redhotpenguin.com with HTTP; Fri, 16 Jul 2004 20:20:40 -0700 (PDT) Message-ID: <33676.67.116.52.35.1090034440.squirrel@mail.redhotpenguin.com> In-Reply-To: References: Date: Fri, 16 Jul 2004 20:20:40 -0700 (PDT) Subject: Re: hardware raid suggestions From: "Fred Moyer" To: "Brian Hirt" Cc: pgsql-performance@postgresql.org Reply-To: fred@redhotpenguin.com User-Agent: SquirrelMail/1.4.2-1.qvcs.1 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=PRIORITY_NO_NAME, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/112 X-Sequence-Number: 7503 > 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? I have worked with at least four major name brands of scsi and ide raid controllers and so far the one I have found to be generally the most featured and fastest is the ICP Vortex controllers (http://www.icp-vortex.com/). It is also more expensive than the others but has been worth the cost IMHO. It has a command line utility to measure disk performance and I believe the source code for it is available. I have measured over 200 MB/s reads off these controllers on 3u disk array units. I'm sure I could have gotten more with additional tuning. Fred