Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael March
Subject Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Date
Msg-id AANLkTikXLYc32Jyr5Fb8VeVNt6R86mCcF+0CkTHALd8W@mail.gmail.com
Whole thread Raw
Responses Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Scott Carey <scott@richrelevance.com>)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Yeb Havinga <yebhavinga@gmail.com>)
Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD  (Michael March <mmarch@gmail.com>)
List pgsql-performance
Tree view
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!

pgsql-performance by date:

Previous
From: Justin Pitts
Date:
Subject: Re: Advice configuring ServeRAID 8k for performance
Next
From: Scott Carey
Date:
Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD