Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 223A9B5DBF2 for ; Sun, 2 Oct 2011 02:01:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 29923-09 for ; Sun, 2 Oct 2011 05:01:36 +0000 (UTC) X-Greylist: delayed 00:59:59.853339 by SQLgrey-1.8.0-rc2 Received: from asmtpout029.mac.com (asmtpout029.mac.com [17.148.16.104]) by mail.postgresql.org (Postfix) with ESMTP id 9E19FB5DBEE for ; Sun, 2 Oct 2011 02:01:36 -0300 (ADT) MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_6v8PpiSqaoz50QqQXw/rqg)" Received: from [192.168.1.69] (99-40-6-237.lightspeed.sntcca.sbcglobal.net [99.40.6.237]) by asmtp029.mac.com (Oracle Communications Messaging Server 7u4-23.01(7.0.4.23.0) 64bit (built Aug 10 2011)) with ESMTPSA id <0LSF00GQB74DZ440@asmtp029.mac.com> for pgsql-performance@postgresql.org; Sat, 01 Oct 2011 21:00:14 -0700 (PDT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.4.6813,1.0.211,0.0.0000 definitions=2011-10-02_01:2011-09-30, 2011-10-02, 1970-01-01 signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 ipscore=0 suspectscore=0 phishscore=0 bulkscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=6.0.2-1012030000 definitions=main-1110010349 Subject: Re: Suggestions for Intel 710 SSD test From: Gregory Gerard In-reply-to: <1317525762.87269.YahooMailNeo@web111315.mail.gq1.yahoo.com> Date: Sat, 01 Oct 2011 21:00:12 -0700 Cc: David Boreham , PGSQL Performance Message-id: References: <4E87CEDF.3000504@boreham.org> <1317525762.87269.YahooMailNeo@web111315.mail.gq1.yahoo.com> To: Andy X-Mailer: Apple Mail (2.1244.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.402 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201110/3 X-Sequence-Number: 45225 --Boundary_(ID_6v8PpiSqaoz50QqQXw/rqg) Content-type: text/plain; CHARSET=US-ASCII Content-transfer-encoding: 7BIT How does this same benchmark compare on similar (or same) hardware but with magnetic media? On Oct 1, 2011, at 8:22 PM, Andy wrote: > Do you have an Intel 320? I'd love to see tests comparing 710 to 320 and see if it's worth the price premium. > > From: David Boreham > To: PGSQL Performance > Sent: Saturday, October 1, 2011 10:39 PM > Subject: [PERFORM] Suggestions for Intel 710 SSD test > > > I have a 710 (Lyndonville) SSD in a test server. Ultimately we'll run > capacity tests using our application (which in turn uses PG), but it'll > take a while to get those set up. In the meantime, I'd be happy to > entertain running whatever tests folks here would like to suggest, > spare time-permitting. > > I've already tried bonnie++, sysbench and a simple WAL emulation > test program I wrote more than 10 years ago. The drive tests at > around 160Mbyte/s on bulk data and 4k tps for commit rate writing > small blocks. > > > > -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > > --Boundary_(ID_6v8PpiSqaoz50QqQXw/rqg) Content-type: text/html; CHARSET=US-ASCII Content-transfer-encoding: quoted-printable How = does this same benchmark compare on similar (or same) hardware but with = magnetic media?

On Oct 1, 2011, at 8:22 PM, Andy = wrote:

Do you have an Intel 320?  I'd = love to see tests comparing 710 to 320 and see if it's worth the price = premium.

From: David Boreham <david_list@boreham.org>
<= b>To: PGSQL Performance = <pgsql-performance@postgre= sql.org>
Sent: Saturday, October 1, 2011 10:39 PM
Subject: [PERFORM] Suggestions = for Intel 710 SSD test


I have a 710 (Lyndonville) SSD in a test server. Ultimately we'll = run
capacity tests using our application (which in turn uses PG), but = it'll
take a while to get those set up. In the meantime, I'd be happy = to
entertain running whatever tests folks here would like to = suggest,
spare time-permitting.

I've already tried bonnie++, = sysbench and a simple WAL emulation
test program I wrote more than 10 = years ago.  The drive tests at
around 160Mbyte/s on bulk data = and 4k tps for commit rate writing
small blocks.



-- = Sent via pgsql-performance mailing list (pgsql-performance@postgre= sql.org)
To make changes to your subscription:
http://www.p= ostgresql.org/mailpref/pgsql-performance


=

= --Boundary_(ID_6v8PpiSqaoz50QqQXw/rqg)--