| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | Fernando Hevia <fhevia(at)ip-tel(dot)com(dot)ar> |
| Cc: | 'Laszlo Nagy' <gandalf(at)shopzeus(dot)com>, 'pgsql-performance' <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: SSD + RAID |
| Date: | 2009-11-13 21:09:59 |
| Message-ID: | 4AFDCB27.6010903@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)2ndQuadrant(dot)com www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenny Gorman | 2009-11-13 21:35:57 | Re: SSD + RAID |
| Previous Message | Merlin Moncure | 2009-11-13 21:09:18 | Re: SSD + RAID |