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
