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 AABDBD1B4EB for ; Fri, 12 Sep 2003 19:03:49 +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 37447-08 for ; Fri, 12 Sep 2003 16:03:19 -0300 (ADT) Received: from lorax.kciLink.com (lorax.kciLink.com [206.112.95.1]) by svr1.postgresql.org (Postfix) with ESMTP id 070AFD1B4E7 for ; Fri, 12 Sep 2003 16:03:17 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id 90DEB3EC2 for ; Fri, 12 Sep 2003 15:03:18 -0400 (EDT) Received: from lorax.kciLink.com ([127.0.0.1]) by localhost (lorax.kciLink.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 38441-02-2 for ; Fri, 12 Sep 2003 15:03:08 -0400 (EDT) Received: from lorax.kciLink.com (localhost [127.0.0.1]) by lorax.kciLink.com (Postfix) with ESMTP id 037493E9D for ; Fri, 12 Sep 2003 15:03:07 -0400 (EDT) Received: (from news@localhost) by lorax.kciLink.com (8.12.8p1/8.12.8/Submit) id h8CJ37WO018998 for pgsql-performance@postgresql.org; Fri, 12 Sep 2003 15:03:07 -0400 (EDT) To: pgsql-performance@postgresql.org Path: not-for-mail From: Vivek Khera Newsgroups: ml.postgres.performance Subject: Re: software vs hw hard on linux Date: Fri, 12 Sep 2003 15:03:07 -0400 Organization: Khera Communications, Inc., Rockville, MD Lines: 26 Message-ID: References: <20030912144924.GB26895@neteconomist.com> NNTP-Posting-Host: yertle.kcilink.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: lorax.kciLink.com 1063393387 1178 216.194.193.105 (12 Sep 2003 19:03:07 GMT) X-Complaints-To: daemon@kciLink.com NNTP-Posting-Date: Fri, 12 Sep 2003 19:03:07 +0000 (UTC) User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Portable Code, berkeley-unix) Cancel-Lock: sha1:4ayc6uHNANc/Ws/bHKvPFRAxpCw= X-Virus-Scanned: by amavisd-new at kciLink.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/207 X-Sequence-Number: 3573 >>>>> "a" == aturner writes: a> you need a good size cache too. If you don't have it, RAID 5 a> performance will suck big time. If you need speed, RAID 10 seems a> to be the only way to go, but of course that means you are gonna a> spend $$s on drives and chasis. I wish someone would start a I disagree on your RAID level assertions. Check back about 10 or 15 days on this list for some numbers I posted on restore times for a 20+ GB database with different RAID levels. RAID5 came out fastest compared with RAID10 and RAID50 across 14 disks. On my 5 disk system, I run RAID10 plus a spare in preference to RAID5 as it is faster for that. So the answer is "it depends". ;-) Both systems use SCSI hardware RAID controllers, one is LSI and the other Adaptec, all hardware from Dell. But if you're budget limited, spend every last penny you have on the fastest disks you can get, and then boost memory. Any current CPU will be more than enough for Postgres. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@kciLink.com Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/