Merlin Moncure wrote:
So flash isn't yet a general purpose database solution, and wont be until the write performance problem is fixed in a way that doesn't compromise on volatility.
Flash drives that ship with a supercapacitor large enough to ensure orderly write cache flushing in the event of power loss seem to be the only solution anyone is making progress on for this right now. That would turn them into something even better even than the traditional approach of using regular disk with a battery-backed write caching controller. Given the relatively small write cache involved and the fast write speed, it's certainly feasible to just flush at power loss every time rather than what the BBWC products do--recover once power comes back.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
