Postgres Pro
Downloads
Home   >   mailing lists

Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD - Mailing list pgsql-performance

From Michael March
Subject Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Date
Msg-id AANLkTi=uNPBFeo5OOmp4Z5TPQms83hs=qYcQA_-4typs@mail.gmail.com
Whole thread Raw
In response to Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Michael March <mmarch@gmail.com>)
List pgsql-performance
Tree view
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@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.


Is this what everyone else is seeing?

Thanks!




--
<admiral>

Michael F. March ----- mmarch@gmail.com

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Next
From: "Kevin Grittner"
Date:
Subject: Re: Very bad plan when using VIEW and IN (SELECT...*)