X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0B6659DCB0F for ; Fri, 24 Feb 2006 20:07:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25810-03 for ; Fri, 24 Feb 2006 20:07:08 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id 8B8A09DCABD for ; Fri, 24 Feb 2006 20:07:03 -0400 (AST) Received: from 172.16.1.112 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Fri, 24 Feb 2006 19:06:57 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01SMTP02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 24 Feb 2006 19:06:57 -0500 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Sat, 25 Feb 2006 00:06:57 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Fri, 24 Feb 2006 16:06:57 -0800 Subject: Re: Reliability recommendations From: "Luke Lonergan" To: "Joshua D. Drake" , "Craig A. James" cc: pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] Reliability recommendations Thread-Index: AcY5Zdlzm6d/hZFPS4eebfXvfIH5OAAOYq4M In-Reply-To: <43FF403D.8090305@commandprompt.com> MIME-Version: 1.0 X-OriginalArrivalTime: 25 Feb 2006 00:06:57.0653 (UTC) FILETIME=[64924A50:01C6399F] X-WSS-ID: 6FE1402B2XS17674002-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.326 required=5 tests=[AWL=0.073, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.326 X-Spam-Level: * X-Archive-Number: 200602/395 X-Sequence-Number: 17381 Joshua, On 2/24/06 9:19 AM, "Joshua D. Drake" wrote: > This machine... if you run it in raid 5 will only get 7-9 megabytes a > second READ! performance. That is with 6 SCSI drives. > If you run it in RAID 10 you get a more reasonable 50-55 megabytes per > second. > > I don't have it sitting in front of me or I would give you an exact > model number. > > This machine also uses the serverworks chipset which is known to be a > catastrophe. I'd be more shocked if this weren't also true of nearly all SCSI HW RAID adapters of this era. If you had ordered an HP DL380 server you'd get about the same performance. BTW - I don't think there's anything reasonable about 50-55 MB/s from 6 disks, I'd put the minimum for this era machine at 5 x 30 = 150MB/s. - Luke