From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
---|---|
To: | Tomas Vondra <tv(at)fuzzy(dot)cz> |
Cc: | KONDO Mitsumasa <kondo(dot)mitsumasa(at)lab(dot)ntt(dot)co(dot)jp>, DFE <mimmopasticcio(at)gmail(dot)com>, Niels Kristian Schjødt <nielskristian(at)autouncle(dot)com>, "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Optimal settings for RAID controller - optimized for writes |
Date: | 2014-02-19 15:13:17 |
Message-ID: | CAHyXU0x6koA5UwHqNpJOP09DFvJsp73Rar-3gkbz1UjbYRQCtg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, Feb 18, 2014 at 2:41 PM, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:
> On 18.2.2014 02:23, KONDO Mitsumasa wrote:
>> Hi,
>>
>> I don't have PERC H710 raid controller, but I think he would like to
>> know raid striping/chunk size or read/write cache ratio in
>> writeback-cache setting is the best. I'd like to know it, too:)
>
> We do have dozens of H710 controllers, but not with SSDs. I've been
> unable to find reliable answers how it handles TRIM, and how that works
> with wearout reporting (using SMART).
AFAIK (I haven't looked for a few months), they don't support TRIM.
The only hardware RAID vendor that has even basic TRIM support Intel
and that's no accident; I have a theory that enterprise storage
vendors are deliberately holding back SSD: SSD (at least, the newer,
better ones) destroy the business model for "enterprise storage
equipment" in a large percentage of applications. A 2u server with,
say, 10 s3700 drives gives *far* superior performance to most SANs
that cost under 100k$. For about 1/10th of the price.
If you have a server that is i/o constrained as opposed to storage
constrained (AKA: a database) hard drives make zero economic sense.
If your vendor is jerking you around by charging large multiples of
market rates for storage and/or disallowing drives that actually
perform well in their storage gear, choose a new vendor. And consider
using software raid.
merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2014-02-19 18:09:05 | Re: Optimal settings for RAID controller - optimized for writes |
Previous Message | KONDO Mitsumasa | 2014-02-19 02:45:32 | Re: Optimal settings for RAID controller - optimized for writes |