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 F190E9DCBD7 for ; Wed, 21 Dec 2005 06:47: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 96555-06 for ; Wed, 21 Dec 2005 06:47:06 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id CF9FB9DC823 for ; Wed, 21 Dec 2005 06:47:01 -0400 (AST) Received: from 172.16.1.148 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Wed, 21 Dec 2005 05:46:55 -0500 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01HOST02.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 21 Dec 2005 05:46:55 -0500 Received: from 69.181.100.71 ([69.181.100.71]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.104]) with Microsoft Exchange Server HTTP-DAV ; Wed, 21 Dec 2005 10:46:55 +0000 User-Agent: Microsoft-Entourage/11.2.1.051004 Date: Wed, 21 Dec 2005 02:46:54 -0800 Subject: Re: SAN/NAS options From: "Luke Lonergan" To: "Charles Sprickman" , pgsql-performance@postgresql.org Message-ID: Thread-Topic: [PERFORM] SAN/NAS options Thread-Index: AcYF86fodjs1b5MoSXC3BC9Dh7/IbgAKDNoN In-Reply-To: MIME-Version: 1.0 X-OriginalArrivalTime: 21 Dec 2005 10:46:55.0634 (UTC) FILETIME=[DC49B720:01C6061B] X-WSS-ID: 6FB7ED153301229369-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.278 required=5 tests=[AWL=0.025, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.278 X-Spam-Level: * X-Archive-Number: 200512/531 X-Sequence-Number: 16352 Charles, On 12/20/05 9:58 PM, "Charles Sprickman" wrote: > You've given me a lot to go on... Now I'm going to have to do some > research as to real-world RAID controller performance. It's vexing (to > say the least) that most vendors don't supply any raw throughput or TPS > stats on this stuff... Take a look at this: http://www.wlug.org.nz/HarddiskBenchmarks > Anyhow, thanks again. You'll probably see me back here in the coming > months as I try to shake some mysql info out of my brain as our pgsql DBA > gets me up to speed on pgsql and what specifically he's doing to stress > things. Cool! BTW - based on the above benchmark page, I just immediately ordered 2 x of the Areca 1220 SATA controllers ( http://www.areca.com.tw/products/html/pcie-sata.htm) so that we can compare them to the 3Ware 9550SX that we've been using. The 3Ware controllers have been super fast on sequential access, but I'm concerned about their random IOPs. The Areca's aren't as popular, and there's consequently less volume of them, but people who use them rave about them. - Luke