Re: SSD Drives

From: Guy Rouillier <guy(dot)rouillier(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: SSD Drives
Date: 2014-04-03 00:24:53
Message-ID: 533CAA55.3@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We used 4x OCZ Deneva 2 in a RAID configuration. Worked well for us for
over 2 years with no hardware issues. We switched to SSD because we had
a very write-intensive application (30 million rows/day) that spinning
disks just couldn't keep up with.

On 4/2/2014 6:09 PM, Shaun Thomas wrote:
> On 04/02/2014 04:55 PM, Bret Stern wrote:
>
>> Care to share the SSD hardware you're using?
>
> We use these:
>
> http://www.fusionio.com/products/iodrive2/
>
> The older versions of these cards can read faster than a RAID-10 of
> 80x15k RPM SAS drives, based on our tests from a couple yeas ago. Writes
> aren't *quite* as fast, but still much better than even a large RAID array.
>
> They ain't cheap, though. You can expect to pay around $15k USD per TB,
> I believe. There are other similar products from other vendors which may
> have different cost/performance ratios, but I can only vouch for stuff
> I've personally tested.
>
> Our adventure with these cards was a presentation at Postgres Open in
> 2011. Slides are here:
>
> https://wiki.postgresql.org/images/c/c5/Nvram_fun_profit.pdf
>

--
Guy Rouillier

---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scot Kreienkamp 2014-04-03 00:28:28 table insert/primary key question
Previous Message Rob Sargent 2014-04-03 00:11:19 Re: COPY v. java performance comparison