Fernando Hevia wrote:
> Shouldn't their write performance be more than a trade-off for fsync?
>
Not if you have sequential writes that are regularly fsync'd--which is
exactly how the WAL writes things out in PostgreSQL. I think there's a
potential for SSD to reach a point where they can give good performance
even with their write caches turned off. But it will require a more
robust software stack, like filesystems that really implement the write
barrier concept effectively for this use-case, for that to happen.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.com