pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shaun Thomas <sthomas@peak6.com>
To: Greg Smith <greg@2ndQuadrant.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Yeb Havinga <yebhavinga@gmail.com>
Cc: Florian Weimer <fweimer@bfk.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Contemplating SSD Hardware RAID
Date: Wed, 22 Jun 2011 10:50:48 -0500
Message-ID: <4E020F58.8090803@peak6.com> (raw)
In-Reply-To: <4E011871.1040603@2ndQuadrant.com>
References: <4E0015F2.9060504@drivefaster.net>
	<4E003B44.9090005@2ndQuadrant.com>
	<4E004D96.7010308@gmail.com>
	<4E004E74.5020209@gmail.com>
	<82d3i777ow.fsf@mid.bfk.de>
	<4E00B4B9.50006@2ndQuadrant.com>
	<4E00FABB.6030302@gmail.com>
	<4E00FE4B.3030204@gmail.com>
	<BANLkTi=zrKHjv1aRcgA6q_MJPNSOuJ9w=Q@mail.gmail.com>
	<BANLkTimoJGY6smRZmizkz_w6CxFH8Y0XaQ@mail.gmail.com>
	<4E011871.1040603@2ndQuadrant.com>

On 06/21/2011 05:17 PM, Greg Smith wrote:

> If they just do the same style of write cache and reliability rework
> to the enterprise line, but using better flash, I agree that the
> first really serious yet affordable product for the database market
> may finally come out of that.

After we started our research in this area and finally settled on 
FusionIO PCI cards (which survived several controlled and uncontrolled 
failures completely intact), a consultant tried telling us he could 
build us a cage of SSDs for much cheaper, and with better performance.

Once I'd stopped laughing, I quickly shooed him away. One of the reasons 
the PCI cards do so well is that they operate in a directly 
memory-addressable manner, and always include capacitors. You lose some 
overhead due to the CPU running the driver, and you can't boot off of 
them, but they're leagues ahead in terms of safety.

But like you said, they're certainly not what most people would call 
affordable. 640GB for two orders of magnitude more than an equivalent 
hard drive would cost? Ouch. Most companies are familiar---and hence 
comfortable---with RAIDs of various flavors, so they see SSD performance 
numbers and think to themselves "What if that were in a RAID?" Right 
now, drives aren't quite there yet, or the ones that are cost more than 
most want to spend.

It's a shame, really. But I'm willing to wait it out for now.

-- 
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@peak6.com

______________________________________________

See  http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email



view thread (13+ messages)

Message-ID: <4E020F58.8090803@peak6.com>
Permalink:  ../4E020F58.8090803@peak6.com/
Also on:    postgresql.org/message-id/4E020F58.8090803@peak6.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sthomas@peak6.com, greg@2ndQuadrant.com, mmoncure@gmail.com, scott.marlowe@gmail.com, yebhavinga@gmail.com, fweimer@bfk.de
  Subject: Re: Contemplating SSD Hardware RAID
  In-Reply-To: <4E020F58.8090803@peak6.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