Re: Solid State Drives with PG

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@2ndQuadrant.com   www.2ndQuadrant.us