X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1294BD1B50B for ; Fri, 12 Sep 2003 21:38:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 62692-03 for ; Fri, 12 Sep 2003 18:38:28 -0300 (ADT) Received: from news.hub.org (unknown [64.117.224.194]) by svr1.postgresql.org (Postfix) with ESMTP id 13240D1B51F for ; Fri, 12 Sep 2003 18:38:26 -0300 (ADT) Received: from news.hub.org (host-64-117-224-194.altec1.com [64.117.224.194] (may be forged)) by news.hub.org (8.12.9/8.12.9) with ESMTP id h8CLcPsl036310 for ; Fri, 12 Sep 2003 21:38:25 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h8CLA1jI030442 for pgsql-performance@postgresql.org; Fri, 12 Sep 2003 21:10:01 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: best arrangement of 3 disks for (insert) performance - Dell Date: Fri, 12 Sep 2003 16:47:22 -0400 Organization: Hub.Org Networking Services Lines: 39 Message-ID: <60fzj1raxx.fsf@dev6.int.libertyrms.info> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Rational FORTRAN, linux) Cancel-Lock: sha1:Qqnh0qmJIZWj0Vf00WS509rMApk= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/211 X-Sequence-Number: 3577 TDyson@sybex.com ("Thom Dyson") writes: > The Dell PERC controllers have a very strong reputation for terrible > performance. If you search the archives of the Dell Linux Power > Edge list (dell.com/linux), you will find many, many people who get > better performance from software RAID, rather than the hw RAID on > the PERC. Having said that, the 3/SC might be one of the better > PERC controllers. I would spend and hour or two and benchmark hw > vs. sw before I committed to either one. I can't agree with that. 1. If you search the archives for messages dated a couple of years ago, you can find lots of messages indicating terrible performance. Drivers are not cast in concrete; there has been a LOT of change to them since then. 2. The second MAJOR merit to hardware RAID is the ability to hot-swap drives. Software RAID doesn't help with that at all. 3. The _immense_ performance improvement that can be gotten out of these controllers comes from having fsync() turn into a near no-op since changes can be committed to the 128K battery-backed cache REALLY QUICKLY. That is something you should avoid doing with software RAID in any case where you actually care about your data. That third part is where Big Wins come. It is the very same sort of "big win from cacheing" that we saw, years ago, when we improved system performance _immensely_ by adding a mere 16 bytes of cache by buying serial controller cards with cacheing UUARTs. It is akin to the way SCSI controllers got pretty big performance improvements by adding 256 bytes of tagged command cache. -- output = ("cbbrowne" "@" "libertyrms.info") Christopher Browne (416) 646 3304 x124 (land)