SSD's actually vary quite a bit with typical postgres benchmark workloads. Many of them also do not guarantee data that has been sync'd will not be lost if power fails (most hard drives with a sane OS and file system do).
On Aug 7, 2010, at 4:47 PM, Michael March wrote:
If anyone is interested I just completed a series of benchmarks of stock Postgresql running on a normal HDD vs a SSD.
If you don't want to read the post, the summary is that SSDs are 5 to 7 times faster than a 7200RPM HDD drive under a pgbench load.
http://it-blog.5amsolutions.com/2010/08/performance-of-postgresql-ssd-vs.html
Is this what everyone else is seeing?
Thanks!
--
mmarch(at)gmail(dot)com<mailto:mmarch(at)gmail(dot)com>