Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD

[Michael March <mmarch@xxxxxxxxx>]

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 <mmarch@xxxxxxxxx> 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@xxxxxxxxx

--
<admiral>

Michael F. March ----- mmarch@xxxxxxxxx