> 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. 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@xxxxxxxxxxxxxx [mailto:pgsql-performance-owner@xxxxxxxxxxxxxx]
On Behalf Of Merlin Moncure On Tue, Feb 21, 2017 at 1:40 PM, Wes Vaske (wvaske) <wvaske@xxxxxxxxxx> wrote:
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 |