Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 20D45B5DBC4 for ; Wed, 24 Aug 2011 14:44:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 03214-09 for ; Wed, 24 Aug 2011 17:44:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.nuevasync.com (server13-scl.nuevasync.com [64.13.157.153]) by mail.postgresql.org (Postfix) with ESMTP id B7029B5DBF2 for ; Wed, 24 Aug 2011 14:44:42 -0300 (ADT) Received: from [69.145.82.235] (unknown [69.145.82.235]) by mail.nuevasync.com (Postfix) with ESMTP id 101FD2B149F for ; Wed, 24 Aug 2011 11:44:41 -0600 (MDT) Message-ID: <4E5537F6.3070105@boreham.org> Date: Wed, 24 Aug 2011 11:42:14 -0600 From: David Boreham User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:6.0) Gecko/20110812 Thunderbird/6.0 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Intel 320 SSD info References: <4E552DCF.80802@boreham.org> <1314206629.63488.YahooMailNeo@web111301.mail.gq1.yahoo.com> <4E5537C9.9080308@2ndQuadrant.com> In-Reply-To: <4E5537C9.9080308@2ndQuadrant.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201108/275 X-Sequence-Number: 44722 On 8/24/2011 11:41 AM, Greg Smith wrote: > > > I've measured the performance of this drive from a couple of > directions now, and it always comes out the same. For PostgreSQL, > reading or writing 8K blocks, I'm seeing completely random workloads > hit a worst-case of 20MB/s; that's just over 2500 IOPS. It's quite > possible that number can go lower under pressure of things like > internal drive garbage collection however, which I believe is going > into the 600 IOPS figure. I haven't tried to force that yet--drive is > too useful to me to try and burn it out doing tests like that at the > moment. I hope someone from Intel is reading -- it would be well worth their while to just send you a few drives, since you are set up to perform the right test, and can provide impartial results.