Re: SSD + RAID

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