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

From: Scott Carey <scott(at)richrelevance(dot)com>
To: Michael March <mmarch(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD
Date: 2010-08-08 06:36:25
Message-ID: BAE01AAD-6C69-48C7-BD2E-77E463D49903@richrelevance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

SSD's actually vary quite a bit with typical postgres benchmark workloads. Many of them also do not guarantee data that has been sync'd will not be lost if power fails (most hard drives with a sane OS and file system do).

On Aug 7, 2010, at 4:47 PM, Michael March 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(at)gmail(dot)com<mailto:mmarch(at)gmail(dot)com>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Carey 2010-08-08 06:46:49 Re: Advice configuring ServeRAID 8k for performance
Previous Message Michael March 2010-08-07 23:47:55 Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD