X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5BC4153B51 for ; Thu, 14 Apr 2005 19:43:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56609-08 for ; Thu, 14 Apr 2005 22:43:17 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by svr1.postgresql.org (Postfix) with ESMTP id C88A45360A for ; Thu, 14 Apr 2005 19:43:16 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so627532wri for ; Thu, 14 Apr 2005 15:43:19 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EbBT0WSTTrBpOUquZL9Gi6+rELA49umY2m1fYwoFxGi9sKTN2VLoCmeduE46hejdiugbC2XCZnenomO2/VLe9Or0qHHEXxkZjg/KDOP3UnGPaWRGzF7zHSGx1vhgJUiCGTskTdOLPcCEQU8y2/ugdagZgaMcgFqZ80ddERhOqyw= Received: by 10.54.38.70 with SMTP id l70mr477270wrl; Thu, 14 Apr 2005 15:43:19 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Thu, 14 Apr 2005 15:43:18 -0700 (PDT) Message-ID: <33c6269f05041415435ed69ca5@mail.gmail.com> Date: Thu, 14 Apr 2005 18:43:18 -0400 From: Alex Turner Reply-To: Alex Turner To: Dave Held Subject: Re: Intel SRCS16 SATA raid? Cc: pgsql-performance@postgresql.org In-Reply-To: <49E94D0CFCD4DB43AFBA928DDD20C8F9026184AF@asg002.asg.local> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <49E94D0CFCD4DB43AFBA928DDD20C8F9026184AF@asg002.asg.local> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.273 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/321 X-Sequence-Number: 11718 Just to clarify these are tests from http://www.storagereview.com, not my own. I guess they couldn't get number for those parts. I think everyone understands that a 0ms seek time impossible, and indicates a missing data point. Thanks, Alex Turner netEconomist On 4/14/05, Dave Held wrote: > > -----Original Message----- > > From: Alex Turner [mailto:armtuk@gmail.com] > > Sent: Thursday, April 14, 2005 12:14 PM > > To: Richard_D_Levine@raytheon.com > > Cc: Greg Stark; pgsql-performance@postgresql.org; > > pgsql-performance-owner@postgresql.org > > Subject: Re: [PERFORM] Intel SRCS16 SATA raid? > > > > > > I have put together a little head to head performance of a 15k SCSI, > > 10k SCSI 10K SATA w/TCQ, 10K SATA wo/TCQ and 7.2K SATA drive > > comparison at storage review > > > > http://www.storagereview.com/php/benchmark/compare_rtg_2001.ph > > p?typeID=3D10&testbedID=3D3&osID=3D4&raidconfigID=3D1&numDrives=3D1&dev= I > > D_0=3D232&devID_1=3D40&devID_2=3D259&devID_3=3D267&devID_4=3D261&devID_= 5 > > =3D248&devCnt=3D6 > > > > It does illustrate some of the weaknesses of SATA drives, but all in > > all the Raptor drives put on a good show. > > [...] >=20 > I think it's a little misleading that your tests show 0ms seek times > for some of the write tests. The environmental test also selects a > missing data point as the winner. Besides that, it seems to me that > seek time is one of the most important features for a DB server, which > means that the SCSI drives are the clear winners and the non-WD SATA > drives are the embarrassing losers. Transfer rate is import, but > perhaps less so because DBs tend to read/write small blocks rather > than large files. On the server suite, which seems to me to be the > most relevant for DBs, the Atlas 15k spanks the other drives by a > fairly large margin (especially the lesser SATA drives). When you > ignore the "consumer app" benchmarks, I wouldn't be so confident in > saying that the Raptors "put on a good show". >=20 > __ > David B. Held > Software Engineer/Array Services Group > 200 14th Ave. East, Sartell, MN 56377 > 320.534.3637 320.253.7800 800.752.8129 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend >