From: Wes Vaske (wvaske) <wvaske@micron.com>
To: Merlin Moncure <mmoncure@gmail.com>
Cc: Pietro Pugni <pietro.pugni@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
Date: Tue, 21 Feb 2017 21:50:23 +0000
Message-ID: <8517c06a97b747409c756d8188a3d1ee@bowex17a.micron.com> (raw)
In-Reply-To: <CAHyXU0wYB-Cg02u_wRYL4QN0SU=Hr1xYUYv_1fLPob0--TcNgQ@mail.gmail.com>
References: <DEBA08E2-240E-4332-8318-391097B613D0@gmail.com>
<CAHyXU0x4cbFus3cJ+oTi5_FgWHc7ChWM2jtHDBYBwivfYXVppA@mail.gmail.com>
<85c31c1250404e10985fe0baf943ef38@bowex17a.micron.com>
<CAHyXU0wYB-Cg02u_wRYL4QN0SU=Hr1xYUYv_1fLPob0--TcNgQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
> I'm curious what the entry point is for micron models are capacitor enabled...
The 5100 is the entry SATA drive with full power loss protection.
http://www.anandtech.com/show/10886/micron-announces-5100-series-enterprise-sata-ssds-with-3d-tlc-na...
Fun Fact: 3D TLC can give better endurance than planar MLC. http://www.chipworks.com/about-chipworks/overview/blog/intelmicron-detail-their-3d-nand-iedm
My understanding (and I’m not a process or electrical engineer) is that the 3D cell size is significantly larger than what was being used for planar (Samsung’s 3D is reportedly a ~40nm class device vs our most recent planar which is 16nm). This results in many more electrons per cell which provides better endurance.
Wes Vaske
From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Merlin Moncure
Sent: Tuesday, February 21, 2017 2:02 PM
To: Wes Vaske (wvaske) <wvaske@micron.com>
Cc: Pietro Pugni <pietro.pugni@gmail.com>; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Suggestions for a HBA controller (6 x SSDs + madam RAID10)
On Tue, Feb 21, 2017 at 1:40 PM, Wes Vaske (wvaske) <wvaske@micron.com<mailto:wvaske@micron.com>> wrote:
- HW RAID can give better performance if your drives do not have a capacitor backed cache (like the MX300) AND the controller has a battery backed cache. *Consumer drives can often get better performance from HW RAID*. (otherwise MDADM has been faster in all of my testing)
I stopped recommending non-capacitor drives a long time ago for databases. A capacitor is basically a battery that operates on the drive itself and is not subject to chemical failure. Also, drives without capacitors tend not (in my direct experience) to be suitable for database use in any scenario where write performance matters. There are capacitor equipped drives that give excellent performance for around .60$/gb. I'm curious what the entry point is for micron models are capacitor enabled...
MLC solid state drives are essentially raid systems already with very complex tradeoffs engineered into the controller itself -- hw raid controllers are redundant systems and their price and added latency to filesystem calls is not warranted. I guess in theory a SSD specialized raid controller could cooperate with the drives and do things like manage wear leveling across multiple devices but AFAIK no such product exists (note: I haven't looked lately).
merlin
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: wvaske@micron.com, mmoncure@gmail.com, pietro.pugni@gmail.com
Subject: Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10)
In-Reply-To: <8517c06a97b747409c756d8188a3d1ee@bowex17a.micron.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