X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A1D1047645A for ; Fri, 2 May 2003 18:11:04 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id C3507476440 for ; Fri, 2 May 2003 18:11:03 -0400 (EDT) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3004166; Fri, 02 May 2003 15:10:54 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "scott.marlowe" , Chad Thompson Subject: Re: Looking for a cheap upgrade (RAID) Date: Fri, 2 May 2003 15:10:25 -0700 User-Agent: KMail/1.4.3 Cc: pgsql-performance References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200305021510.25982.josh@agliodbs.com> X-Spam-Status: No, hits=-32.4 required=5.0 tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/12 X-Sequence-Number: 1791 Scott, > With that setup, you'd have 15 Gigs for the OS, 4 gigs for swap, and abou= t=20 > 300 gigs for the database. The nice thing about RAID 5 is that random=20 > read performance for parallel load gets better as you add drives. Write= =20 > performance gets a little better with more drives since it's likely that= =20 > the drives you're writing to aren't the same ones being read.=20=20 Yeah, but I've found with relatively few drives (such as the minimum of 3)= =20 that RAID 5 performance is considerably worse for writes than RAID 1 -- as= =20 bad as 30-40% of the speed of a raw SCSI disk. This problem goes away wit= h=20 more disks, of course. --=20 -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco