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 A7185D1B4A2 for ; Mon, 26 Jul 2004 11:16:33 -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 07675-08 for ; Mon, 26 Jul 2004 14:16:41 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id E6B0AD1B4FC for ; Mon, 26 Jul 2004 11:16:29 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i6QEGYqb072707 for ; Mon, 26 Jul 2004 14:16:34 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i6QE1RjQ069860 for pgsql-performance@postgresql.org; Mon, 26 Jul 2004 14:01:27 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.performance Subject: Re: hardware raid suggestions Date: Mon, 26 Jul 2004 16:01:15 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 40 Message-ID: <41050EAB.6060901@bigfoot.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Brian Hirt User-Agent: Mozilla Thunderbird 0.7.1 (Windows/20040626) X-Accept-Language: en-us, en In-Reply-To: X-Enigmail-Version: 0.84.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime To: pgsql-performance@postgresql.org 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/168 X-Sequence-Number: 7559 Brian Hirt wrote: > I've been using the adaptec ZCR raid cards in our servers for a while > now, mostly small systems with 3 or 6 disks, and we've been very happy > with them. However, we're building a new DB machine with 14 U320 15K > SCA drives, and we've run into a performance bottlenkeck with the ZCR > card where it just won't scale well. Without going into too many > details, we've tested RAID5, RAID10 and RAID50 on pretty much every > array size from 4-14 disks (raid 50 tests used more drives), using JFS, > reiserfs and EXT3. With every different configuration, performance > didn't improve after array size became greater than 6 disks.. We used > various benchmarks, including pgbench with scale factors of 10, 100, > 1000, 5000 and clients of 10, 15, 30 and 45. We've done many other > tests and monitoring tools, and we've come to the conclusion that the > ZCR is the problem. > > 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? > Did you consider the option of use an external storage array ? We are using the dell emc CX600 http://www.dell.com/downloads/emea/products/pvaul/en/Dell_EMC_cx600_specs.pdf and I'm forgotting to have a disk behind... Regards Gaetano Mendola