Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BA7086502D2 for ; Wed, 23 Jul 2008 16:59:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 12827-01-7 for ; Wed, 23 Jul 2008 16:59:29 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.169]) by postgresql.org (Postfix) with ESMTP id E8917650294 for ; Wed, 23 Jul 2008 16:57:35 -0300 (ADT) Received: by wf-out-1314.google.com with SMTP id 25so1977719wfc.28 for ; Wed, 23 Jul 2008 12:57:34 -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=xFV6Z5R8KOdYpGDMwF1uQdKcj1+s1GZenV7LG5VQ5Wg=; b=IYJm0Kn543Vh6Vie8FKhxRY8CUYRjO2RdesRoxIwf720BEqJSP/6zh5o+DRI4D9rY3 sVcjCnvI9VPaYnuAlb2ffr0G83JxUWlHGMcG7aMiQ+WH8d9YaJ3arNjq1yiMBaxYcr3a wenCPJJtr+cIIIkdTLYrRrX1H9fD5FRCSUMvs= 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=ID8mcARRhaMf1Yu5Zmf6Wh2KTOFTjWGAZWOEJOcblq84Xcoq/XUyalNW9CAQ+q7BV9 gblNb44S7DObDZmu8i1lP6MMbieof4z33wHPNZb5IOZQ182pr4HScN9Jp/VYUpqGfMjD JU2qQdA7vYJEjzQqugs+gE0pSOUUwOPNbVOGs= Received: by 10.142.58.5 with SMTP id g5mr62312wfa.224.1216843054517; Wed, 23 Jul 2008 12:57:34 -0700 (PDT) Received: by 10.142.242.21 with HTTP; Wed, 23 Jul 2008 12:57:34 -0700 (PDT) Message-ID: Date: Wed, 23 Jul 2008 12:57:34 -0700 From: "Jeffrey Baker" To: "Scott Marlowe" Subject: Re: Samsung 32GB SATA SSD tested Cc: "Pgsql performance" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1216771475.23796.14.camel@squeak.gghcwest.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/218 X-Sequence-Number: 30818 On Tue, Jul 22, 2008 at 5:32 PM, Scott Marlowe wrote: > On Tue, Jul 22, 2008 at 6:04 PM, Jeffrey W. Baker wrote: > >> Strangely the RAID controller behaves badly on the TPC-B workload. It >> is faster than disk, but not by a lot, and it's much slower than the >> other flash configurations. The read/write benchmark did not vary when >> changing the number of clients between 1 and 8. I suspect this is some >> kind of problem with Areca's kernel driver or firmware. > > Are you still using the 2.6.18 kernel for testing, or have you > upgraded to something like 2.6.22. I've heard many good things about > the areca driver in that kernel version. These tests are being run with the CentOS 5 kernel, which is 2.6.18. The ioDrive driver is available for that kernel, and I want to keep the software constant to get comparable results. I put the Samsung SSD in my laptop, which is a Core 2 Duo @ 2.2GHz with ICH9 SATA port and kernel 2.6.24, and it scored about 525 on R/W pgbench. > This sounds like an interesting development I'll have to keep track > of. In a year or two I might be replacing 16 disk arrays with SSD > drives... I agree, it's definitely an exciting development. I have yet to determine whether the SSDs have good properties for production operations, but I'm learning. -jwb