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@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
