> SSD's actually vary quite a bit with typical postgres benchmark workloads. >
You mean various SSDs from different vendors? Or are you saying the same SSD model might vary in performance from drive to drive? > 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). > What feature does an SSD need to have to insure that sync'd data is indeed written to the SSD in the case of power loss? > > > 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! > >
