pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: CSS <css@morefoo.com>
To: Greg Smith <greg@2ndQuadrant.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: sthomas@optionshouse.com, Tomas Vondra <tv@fuzzy.cz>
Cc: pgsql-performance@postgresql.org
Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
Date: Wed, 22 May 2013 17:49:44 -0400
Message-ID: <2DEE334A-11E2-4D28-A065-A9877B78FEC8@morefoo.com> (raw)
In-Reply-To: <519D2562.2060604@2ndQuadrant.com>
References: <CAAE-9WHMycEZOB5J6HKME5AZLEdL2hYF+FV8hzbLksJinq=EJg@mail.gmail.com>
	<51957499.6050905@fuzzy.cz>
	<519991EB.8010208@2ndQuadrant.com>
	<519A8E29.60702@fuzzy.cz>
	<CAHyXU0wvW-USgbkXAYEHLG2fHgj=UdZi1aCFoVWBMQEsOFZy+A@mail.gmail.com>
	<519C0EFD.9080002@2ndQuadrant.com>
	<CAHyXU0ymFT7Sqw77yPryGWKEpjV4Wv9Vkc21vGtPKo0GZWGg8A@mail.gmail.com>
	<519CF8CC.1030204@optionshouse.com>
	<519D0921.9080807@2ndQuadrant.com>
	<519D174A.4050703@commandprompt.com>
	<519D1CD6.2080607@2ndQuadrant.com>
	<CAHyXU0wUHDiGVWgejxsFNApiP0sUcf8eLOy1Dwy-1pboBuxLeQ@mail.gmail.com>
	<519D2562.2060604@2ndQuadrant.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On May 22, 2013, at 4:06 PM, Greg Smith wrote:

> And there are some other products with interesting price/performance/capacity combinations that are also sensitive to wearout.  Seagate's hybrid drives 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 commits than that drive right now.  (Test results on that drive coming soon, along with my full DC S3700 review)

I am really looking forward to that.  Will you announce here or just post on 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 random 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 can "get away" with spending much less money by adding some solid state storage.  There's really an amazing number of options today…

Thanks,

Charles

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (52+ messages)  latest in thread

Message-ID: <2DEE334A-11E2-4D28-A065-A9877B78FEC8@morefoo.com>
Permalink:  ../2DEE334A-11E2-4D28-A065-A9877B78FEC8@morefoo.com/
Also on:    postgresql.org/message-id/2DEE334A-11E2-4D28-A065-A9877B78FEC8@morefoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: css@morefoo.com, greg@2ndQuadrant.com, mmoncure@gmail.com, jd@commandprompt.com, tv@fuzzy.cz
  Subject: Re: Reliability with RAID 10 SSD and Streaming Replication
  In-Reply-To: <2DEE334A-11E2-4D28-A065-A9877B78FEC8@morefoo.com>
  References: <CAAE-9WHMycEZOB5J6HKME5AZLEdL2hYF+FV8hzbLksJinq=EJg@mail.gmail.com> <51957499.6050905@fuzzy.cz> <519991EB.8010208@2ndQuadrant.com> <519A8E29.60702@fuzzy.cz> <CAHyXU0wvW-USgbkXAYEHLG2fHgj=UdZi1aCFoVWBMQEsOFZy+A@mail.gmail.com> <519C0EFD.9080002@2ndQuadrant.com> <CAHyXU0ymFT7Sqw77yPryGWKEpjV4Wv9Vkc21vGtPKo0GZWGg8A@mail.gmail.com> <519CF8CC.1030204@optionshouse.com> <519D0921.9080807@2ndQuadrant.com> <519D174A.4050703@commandprompt.com> <519D1CD6.2080607@2ndQuadrant.com> <CAHyXU0wUHDiGVWgejxsFNApiP0sUcf8eLOy1Dwy-1pboBuxLeQ@mail.gmail.com> <519D2562.2060604@2ndQuadrant.com> <2DEE334A-11E2-4D28-A065-A9877B78FEC8@morefoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox