Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 04D5E632C4E for ; Tue, 2 Mar 2010 20:36:48 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 58119-06 for ; Wed, 3 Mar 2010 00:36:30 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 37215632BD2 for ; Tue, 2 Mar 2010 20:36:37 -0400 (AST) Received: by wya21 with SMTP id 21so476595wya.19 for ; Tue, 02 Mar 2010 16:36:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=sqbE89bDSpzp2+ToCtJ2Min1+0+n1JSIJBbbwB+rKy4=; b=qhoyHH5gBDiQEkfA1kSSf6NZpe5jsWWBsJ0sAblOMhrG8tIFNl8jaNEAbUxg5DaL1h 7ufSsiuh9oalKiWIxGZES5Hd4mgeeas0yH8osUPiBZfveElDhCzhE6E1vccjLYyJnoDX jlDxyIdCF6h7A6DnzwZt7ycDHraeirsbKP0Cg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=auxJvfcfrtcpLnjYF0m3GkTcdDFtj3purxn14ONzDfz9JLENnthSelxbvAmzbmdiWx KbkVVtEkppBzb0lMR2Ot/x5+cBdCaRw8AKeIS+X1Ny0L+GgV84IzHpzIKaqjAJwaN9BY SgOKDMx58rVufdwesbI8w1rUmfnlMmpSa8c+4= MIME-Version: 1.0 Received: by 10.216.89.9 with SMTP id b9mr1055201wef.61.1267576595502; Tue, 02 Mar 2010 16:36:35 -0800 (PST) In-Reply-To: <4B8DA5DF.8060501@2ndquadrant.com> References: <4B8DA5DF.8060501@2ndquadrant.com> Date: Tue, 2 Mar 2010 17:36:35 -0700 Message-ID: Subject: Re: 10K vs 15k rpm for analytics From: Scott Marlowe To: Greg Smith Cc: david@lang.hm, Francisco Reyes , Pgsql performance Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.031 tagged_above=-10 required=5 tests=AWL=-1.032, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/46 X-Sequence-Number: 37871 On Tue, Mar 2, 2010 at 4:57 PM, Greg Smith wrote: > Scott Marlowe wrote: >> >> True, I just looked at the Hitachi 7200 RPM 2TB Ultrastar and it lists >> and average throughput of 134 Megabytes/second which is quite good. >> > > Yeah, but have you tracked the reliability of any of the 2TB drives out > there right now? =A0They're terrible. =A0I wouldn't deploy anything more = than a > 1TB drive right now in a server, everything with a higher capacity is sti= ll > on the "too new to be stable yet" side of the fence to me. We've had REAL good luck with the WD green and black drives. Out of about 35 or so drives we've had two failures in the last year, one of each black and green. The Seagate SATA drives have been horrific for us, with a 30% failure rate in the last 8 or so months. We only have something like 10 of the Seagates, so the sample's not as big as the WDs. Note that we only use the supposed "enterprise" class drives from each manufacturer. We just got a shipment of 8 1.5TB Seagates so I'll keep you informed of the failure rate of those drives. Wouldn't be surprised to see 1 or 2 die in the first few months tho.