Re: SSD database benchmarks - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: SSD database benchmarks
Date
Msg-id b42b73150804291627o368e737eg6ff3dbf8ac081fc8@mail.gmail.com
Whole thread Raw
In response to SSD database benchmarks  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
On Tue, Apr 29, 2008 at 2:55 PM, Greg Smith <gsmith@gregsmith.com> wrote:
> This is the best write-up I've seen yet on quantifying what SSDs are good
> and bad at in a database context:
>
>  http://www.bigdbahead.com/?p=37
>
>  --
>  * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

here is another really informative article (pdf)
http://www.storagesearch.com/easyco-flashperformance-art.pdf.

The conclusions are different...they claim it's hard to make good use
of ssd advantages if you do any random writing at all.  Of course,
they are also developing an automagical solution to the problem.  The
information is good though...it's certainly worth a read.  The problem
is probably solvable.

merlin

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: SSD database benchmarks
Next
From: Len Shapiro
Date:
Subject: Understanding histograms