Skip site navigation (1) Skip section navigation (2)

Re: SSD + RAID

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
Cc: Arjen van der Meijden <acmmailing(at)tweakers(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: SSD + RAID
Date: 2010-02-23 01:39:33
Message-ID: 4B8331D5.7000802@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-performance
Mark Mielke wrote:
> I had read the above when posted, and then looked up SRAM. SRAM seems 
> to suggest it will hold the data even after power loss, but only for a 
> period of time. As long as power can restore within a few minutes, it 
> seemed like this would be ok?

The normal type of RAM everyone uses is DRAM, which requires constrant 
"refresh" cycles to keep it working and is pretty power hungry as a 
result.  Power gone, data gone an instant later.

There is also Non-volatile SRAM that includes an integrated battery ( 
http://www.maxim-ic.com/quick_view2.cfm/qv_pk/2648 is a typical 
example), and that sort of design can be used to build the sort of 
battery-backed caches that RAID controllers provide.  If Intel's drives 
were built using a NV-SRAM implementation, I'd be a happy owner of one 
instead of a constant critic of their drives.

But regular old SRAM is still completely volatile and loses its contents 
very quickly after power fails.  I doubt you'd even get minutes of time 
before it's gone.  The ease at which data loss failures with these Intel 
drives continue to be duplicated in the field says their design isn't 
anywhere near good enough to be considered non-volatile.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com   www.2ndQuadrant.us


In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2010-02-23 02:21:40
Subject: Re: SSD + RAID
Previous:From: Greg SmithDate: 2010-02-23 01:14:47
Subject: Re: SSD + RAID

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group