As a postscript to these tests.. I just tried the 500GB Monentus XT hybrid SSD/HDD drive. I had this fantasy that it would at least do better than the 7200 rpm desktop drive.
Oh lord, my gut was wrong. The performance was inconsistent and never over 2/3rds the performance of the slowest desktop drive. On Sat, Aug 7, 2010 at 4:47 PM, Michael March <mma...@gmail.com> 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! > > -- > mma...@gmail.com > -- <admiral> Michael F. March ----- mma...@gmail.com
