Opinions on SSDs

From: "David F(dot) Skoll" <dfs(at)roaringpenguin(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Opinions on SSDs
Date: 2013-08-12 15:28:33
Message-ID: 20130812112833.65a97285@hydrogen.roaringpenguin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

We run a fairly write-intensive workload and are looking at upgrading
our Pg servers. (PostgreSQL 9.1; no practical way to upgrade to 9.2 for
a while because we use what's packaged with Debian.)

I'm considering the following configuration:

Dual 4-core Intel CPU (E5620 at 2.4GHz)

192GB of RAM

Sixteen 240GB Intel SSD 520 series drives arranged using Linux
RAID-10. The RAID 10 array will use eight mirrored stripes using the
"offset-copies" RAID10 scheme.

Questions:

1) Has anyone had experience with Intel 520 SSDs? Are they reliable?
When they fail, do they fail nicely (ie, failure detected and bad drive
removed from RAID array) or horribly (data silently corrupted...) ?

2) Is this RAID arrangement sensible? I've seen reports where some
people keep the pg_xlog directory on a separate RAID array, but I
don't really see the advantage with SSDs.

3) Our current workload peaks at about 5000 transactions per second;
you can assume about one-third to one-half of those are writes. Do
you think we can get away with 16 10Krpm SATA drives instead of the
SSDs?

Regards,

David.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2013-08-12 15:33:04 Re: Opinions on SSDs
Previous Message Albe Laurenz 2013-08-12 07:15:06 Re: Retrieve rows that have specific value in any of columns.