Re: SSD database benchmarks - Mailing list pgsql-performance

From Greg Smith
Subject Re: SSD database benchmarks
Date
Msg-id Pine.GSO.4.64.0804291908300.10954@westnet.com
Whole thread Raw
In response to Re: SSD database benchmarks  (Guido Neitzer <lists@event-s.net>)
List pgsql-performance
On Tue, 29 Apr 2008, Guido Neitzer wrote:

> They totally missed "mainly write" applications which most of my applications
> are.

Not totally--the very first graph shows that even on random data, 100%
write apps are 1/2 the speed of a regular hard drive.

After poking around the site a bit more they also did some tests with MFT,
some kernel software from Easy Computing that basically uses a write log
disk to improve the write situation:

http://www.bigdbahead.com/?p=44

That version also has a better summary of the results.

MFT is clearly not ready for prime time yet from the general buginess, but
as that approach matures (and more vendors do something similar in
hardware) it will be really interesting to see what happens.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-performance by date:

Previous
From: Guido Neitzer
Date:
Subject: Re: SSD database benchmarks
Next
From: "Merlin Moncure"
Date:
Subject: Re: SSD database benchmarks