Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 5BAA12E0040 for ; Tue, 29 Apr 2008 20:27:25 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03643-09 for ; Tue, 29 Apr 2008 20:27:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158]) by developer.postgresql.org (Postfix) with ESMTP id DF4042E002D for ; Tue, 29 Apr 2008 20:27:21 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id l27so38383fgb.23 for ; Tue, 29 Apr 2008 16:27:20 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=oCvatsPWCWAtTrjKC3Uccl1+0JFB5KT2aL3TOI+gDUk=; b=Zau135fdVO15V42CoXZbzjOEOtEgMSJb+bVox4Q8lUL//ya1y+CB4Wtg9Y73/h/haa28DjoBc1DeAV0voe0whjeb4oLoaEBUTRaOojbaOmYOcQ2TDgAOIDourFJYvBWdWAAMyVNqFr3h0D58n1/tGVGnCYZMiOhGgyC3OcJaM1I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=s3Wk6G3c+osoZI+WZ+5CwVc340rdcqcIEYvHTOkFtvw4q9GrmEXVXyIt3WLxAjiI47BdLh/AzePriT44K4jh9vsfbP6vfRve65IGOwrzWmKvtKv4Tnk+7GnCqqH90fJ0EEt3J4XPyCXddHmFw4qFRhUPCqxZ/aPGQKnfaAVrFzA= Received: by 10.82.182.1 with SMTP id e1mr966buf.89.1209511640138; Tue, 29 Apr 2008 16:27:20 -0700 (PDT) Received: by 10.82.145.1 with HTTP; Tue, 29 Apr 2008 16:27:20 -0700 (PDT) Message-ID: Date: Tue, 29 Apr 2008 19:27:20 -0400 From: "Merlin Moncure" To: "Greg Smith" Subject: Re: SSD database benchmarks Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/452 X-Sequence-Number: 29945 On Tue, Apr 29, 2008 at 2:55 PM, Greg Smith 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