Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfGuy-0004sD-K4 for pgsql-performance@arkaria.postgresql.org; Wed, 22 May 2013 21:49:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UfGuy-0008Fo-3O for pgsql-performance@arkaria.postgresql.org; Wed, 22 May 2013 21:49:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfGux-0008Fi-AI for pgsql-performance@postgresql.org; Wed, 22 May 2013 21:49:55 +0000 Received: from mail.morefoo.com ([207.99.53.222]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UfGuq-0007mq-1A for pgsql-performance@postgresql.org; Wed, 22 May 2013 21:49:55 +0000 Received: from nac.morefoo.com (mail.morefoo.com [207.99.53.222]) by mail.morefoo.com (Postfix) with ESMTP id 569AF2DBEAF; Wed, 22 May 2013 17:49:46 -0400 (EDT) X-Virus-Scanned: amavisd-new at morefoo.com Received: from mail.morefoo.com ([207.99.53.222]) by nac.morefoo.com (nac.morefoo.com [207.99.53.222]) (amavisd-new, port 10024) with ESMTP id oEpR0iE4puJL; Wed, 22 May 2013 17:49:45 -0400 (EDT) Received: from frankentosh.sporklab.com (foon.sporktines.com [96.57.144.66]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: css@morefoo.com) by mail.morefoo.com (Postfix) with ESMTPSA id 6F0672D4806; Wed, 22 May 2013 17:49:45 -0400 (EDT) Subject: Re: Reliability with RAID 10 SSD and Streaming Replication Mime-Version: 1.0 (Apple Message framework v1085) Content-Type: text/plain; charset=windows-1252 From: CSS In-Reply-To: <519D2562.2060604@2ndQuadrant.com> Date: Wed, 22 May 2013 17:49:44 -0400 Cc: Merlin Moncure , "Joshua D. Drake" , sthomas@optionshouse.com, Tomas Vondra , pgsql-performance@postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <2DEE334A-11E2-4D28-A065-A9877B78FEC8@morefoo.com> References: <51957499.6050905@fuzzy.cz> <519991EB.8010208@2ndQuadrant.com> <519A8E29.60702@fuzzy.cz> <519C0EFD.9080002@2ndQuadrant.com> <519CF8CC.1030204@optionshouse.com> <519D0921.9080807@2ndQuadrant.com> <519D174A.4050703@commandprompt.com> <519D1CD6.2080607@2ndQuadrant.com> <519D2562.2060604@2ndQuadrant.com> To: Greg Smith X-Mailer: Apple Mail (2.1085) X-Pg-Spam-Score: -3.0 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On May 22, 2013, at 4:06 PM, Greg Smith wrote: > And there are some other products with interesting price/performance/capa= city combinations that are also sensitive to wearout. Seagate's hybrid dri= ves have turned interesting now that they cache writes safely for example. = There's no cheaper way to get 1TB with flash write speeds for small commit= s than that drive right now. (Test results on that drive coming soon, alon= g with my full DC S3700 review) I am really looking forward to that. Will you announce here or just post o= n the 2ndQuadrant blog? Another "hybrid" solution is to run ZFS on some decent hard drives and then= put the ZFS intent log on SSDs. With very synthetic benchmarks, the rando= m write performance is excellent. All of these discussions about alternate storage media are great - everyone= has different needs and there are certainly a number of deployments that c= an "get away" with spending much less money by adding some solid state stor= age. There's really an amazing number of options today=85 Thanks, Charles --=20 Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance