Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5AA842E004A for ; Tue, 29 Apr 2008 20:26:08 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 60148-02 for ; Tue, 29 Apr 2008 20:25:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by developer.postgresql.org (Postfix) with ESMTP id 47BBB2E002D for ; Tue, 29 Apr 2008 20:26:05 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m3TNQ3hI014861; Tue, 29 Apr 2008 19:26:03 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m3TNQ245014857; Tue, 29 Apr 2008 19:26:02 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Tue, 29 Apr 2008 19:26:02 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Guido Neitzer cc: PostgreSQL Performance Subject: Re: SSD database benchmarks In-Reply-To: Message-ID: References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/451 X-Sequence-Number: 29944 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