Re: SSD database benchmarks

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Greg Smith" <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SSD database benchmarks
Date: 2008-04-29 23:27:20
Message-ID: b42b73150804291627o368e737eg6ff3dbf8ac081fc8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Apr 29, 2008 at 2:55 PM, Greg Smith <gsmith(at)gregsmith(dot)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(at)gregsmith(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Len Shapiro 2008-04-30 04:56:32 Understanding histograms
Previous Message Greg Smith 2008-04-29 23:26:02 Re: SSD database benchmarks