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 77EE5540A0 for ; Fri, 15 Apr 2005 12:02:12 -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 44766-02 for ; Fri, 15 Apr 2005 15:02:00 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203]) by svr1.postgresql.org (Postfix) with ESMTP id 85BE45409D for ; Fri, 15 Apr 2005 12:01:59 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so812985wri for ; Fri, 15 Apr 2005 08:01:56 -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=W5A/jNdxjHf7R1S9xsm5mc0VV4Y4NzkTLN/KeRYQUS9sD7/gJ0bAfnolrEX2wQ0YKKodWzmiFY+UEckPORI/G2Sa8byZp/KQT5GPp6psfxGdbK6ebtwFlmykej2RLGWwFMnvUyG6XpqurFtKfRrZPu7cWpxSnKdXGwSOsZGkY5I= Received: by 10.54.16.68 with SMTP id 68mr759444wrp; Fri, 15 Apr 2005 08:01:56 -0700 (PDT) Received: by 10.54.86.16 with HTTP; Fri, 15 Apr 2005 08:01:56 -0700 (PDT) Message-ID: <33c6269f050415080159674ca4@mail.gmail.com> Date: Fri, 15 Apr 2005 11:01:56 -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: <49E94D0CFCD4DB43AFBA928DDD20C8F9026184B3@asg002.asg.local> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <49E94D0CFCD4DB43AFBA928DDD20C8F9026184B3@asg002.asg.local> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.274 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/348 X-Sequence-Number: 11745 The original thread was how much can I get for $7k You can't fit a 15k RPM SCSI solution into $7K ;) Some of us are on a budg= et! 10k RPM SATA drives give acceptable performance at a good price, thats really the point here. I have never really argued that SATA is going to match SCSI performance on multidrive arrays for IO/sec. But it's all about the benjamins baby. If I told my boss we need $25k for a database machine, he'd tell me that was impossible, and I have $5k to do it.=20 If I tell him $7k - he will swallow that. We don't _need_ the amazing performance of a 15k RPM drive config. Our biggest hit is reads, so we can buy 3xSATA machines and load balance. It's all about the application, and buying what is appropriate. I don't buy a Corvette if all I need is a malibu. Alex Turner netEconomist On 4/15/05, Dave Held wrote: > > -----Original Message----- > > From: Alex Turner [mailto:armtuk@gmail.com] > > Sent: Thursday, April 14, 2005 6:15 PM > > To: Dave Held > > Cc: pgsql-performance@postgresql.org > > Subject: Re: [PERFORM] Intel SRCS16 SATA raid? > > > > Looking at the numbers, the raptor with TCQ enabled was close or > > beat the Atlas III 10k drive on most benchmarks. >=20 > And I would be willing to bet that the Atlas 10k is not using the > same generation of technology as the Raptors. >=20 > > Naturaly a 15k drive is going to be faster in many areas, but it > > is also much more expensive. It was only 44% better on the server > > tests than the raptor with TCQ, but it costs nearly 300% more ($538 > > cdw.com, $180 newegg.com). >=20 > State that in terms of cars. Would you be willing to pay 300% more > for a car that is 44% faster than your competitor's? Of course you > would, because we all recognize that the cost of speed/performance > does not scale linearly. Naturally, you buy the best speed that you > can afford, but when it comes to hard drives, the only major feature > whose price tends to scale anywhere close to linearly is capacity. >=20 > > Note also that the 15k drive was the only drive that kept up with > > the raptor on raw transfer speed, which is going to matter for WAL. >=20 > So get a Raptor for your WAL partition. ;) >=20 > > [...] > > The Raptor drives can be had for as little as $180/ea, which is > > quite a good price point considering they can keep up with their > > SCSI 10k RPM counterparts on almost all tests with NCQ enabled > > (Note that 3ware controllers _don't_ support NCQ, although they > > claim their HBA based queueing is 95% as good as NCQ on the drive). >=20 > Just keep in mind the points made by the Seagate article. You're > buying much more than just performance for that $500+. You're also > buying vibrational tolerance, high MTBF, better internal > environmental controls, and a pretty significant margin on seek time, > which is probably your most important feature for disks storing tables. > An interesting test would be to stick several drives in a cabinet and > graph how performance is affected at the different price points/ > technologies/number of drives. >=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 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >