Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 18F32B5DBC2 for ; Sun, 2 Oct 2011 00:22:52 -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 31331-09 for ; Sun, 2 Oct 2011 03:22:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from nm9.bullet.mail.sp2.yahoo.com (nm9.bullet.mail.sp2.yahoo.com [98.139.91.79]) by mail.postgresql.org (Postfix) with SMTP id CE419B5DBC0 for ; Sun, 2 Oct 2011 00:22:44 -0300 (ADT) Received: from [98.139.91.62] by nm9.bullet.mail.sp2.yahoo.com with NNFMP; 02 Oct 2011 03:22:43 -0000 Received: from [98.139.91.8] by tm2.bullet.mail.sp2.yahoo.com with NNFMP; 02 Oct 2011 03:22:43 -0000 Received: from [127.0.0.1] by omp1008.mail.sp2.yahoo.com with NNFMP; 02 Oct 2011 03:22:43 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 544284.81190.bm@omp1008.mail.sp2.yahoo.com Received: (qmail 87497 invoked by uid 60001); 2 Oct 2011 03:22:43 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1317525762; bh=sb8WqvqtwvmBRqrFwVWrAmnpp5l0baFIDhTdF58BCkc=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=4iPmNX52SvVQ2hhDwV5RuQqsBej/KuRtOk0j9sY6NZ0GX3DUUJKqHeZ5dy+u4tx4pyiyoVov0LQLjtF+NAPPrGjB1/6RFKEO5nqe6xFsDtkdNUHtDJIAZ5pL7Pp3WwatTkbjpBksycDd1ugdmSuQ5QBbWy3UBKYsnmIrspNTsZ0= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=NycQiFtjAmq4CvWX6MP2pxzJUIJCIhc5CkUHUbtrY6Eo2PHmCQI8J0NJXDzUqVmRdOoeZTQFM9ziRjFmZBIxs5b3/XFQxznFVCFynoJWIw0own3Nhr2yAy05HAe6BozVR7yrF8NBYZccCz+7637r8d9QOGz0Ksx2KALhc8h2/l0=; X-YMail-OSG: 2OiZfnsVM1kGci5P6zEN3gDH0UJA7CDrdy80lp77DHFmbp0 O2O7il_rrFac_rUY1Bt5L5kKClNFiMhvktc29y_Z1cyueIE6WA6yE7rFp7v3 Rhg2zDxfQK6IC7CkAEog_tJJhEOBPiYomyCPmpjzmblvRsh34cOfeB4gyuXz .LkrFavwLYckRwln27DhTq2hlQ9XSxBhVPl5dfePzzk7WxdoXL.oICto2hb1 edaieIy_9O_zlvW9GWG6uf_Ltabxkg2As76kCyg8oyJwpt.aDkUG29Raw89o iJOiJsiZTBrC5C5YiWdSsmFGiIB5PmZVlgeFVrkcIr5QNbycpwVqg70VeMEZ UKx0UMiZ20GIHK97KYw99u0w9yQaNKHfl0qnZwIPKHCs5L4Vh4VIeYSuhnH1 mVCcJtLUu02tOT1gt7p.GZlOA2eIfrp7R.bDbgRwlpkzDjJDdhioSmupJUI2 Ggg-- Received: from [24.34.119.122] by web111315.mail.gq1.yahoo.com via HTTP; Sat, 01 Oct 2011 20:22:42 PDT X-Mailer: YahooMailWebService/0.8.114.317681 References: <4E87CEDF.3000504@boreham.org> Message-ID: <1317525762.87269.YahooMailNeo@web111315.mail.gq1.yahoo.com> Date: Sat, 1 Oct 2011 20:22:42 -0700 (PDT) From: Andy Reply-To: Andy Subject: Re: Suggestions for Intel 710 SSD test To: David Boreham , PGSQL Performance In-Reply-To: <4E87CEDF.3000504@boreham.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1802853223-2042894633-1317525762=:87269" 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/2 X-Sequence-Number: 45224 ---1802853223-2042894633-1317525762=:87269 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Do you have an Intel 320? =A0I'd love to see tests comparing 710 to 320 and= see if it's worth the price premium.=0A=0A=0A_____________________________= ___=0AFrom: David Boreham =0ATo: PGSQL Performance = =0ASent: Saturday, October 1, 2011 10:39 = PM=0ASubject: [PERFORM] Suggestions for Intel 710 SSD test=0A=0A=0AI have a= 710 (Lyndonville) SSD in a test server. Ultimately we'll run=0Acapacity te= sts using our application (which in turn uses PG), but it'll=0Atake a while= to get those set up. In the meantime, I'd be happy to=0Aentertain running = whatever tests folks here would like to suggest,=0Aspare time-permitting.= =0A=0AI've already tried bonnie++, sysbench and a simple WAL emulation=0Ate= st program I wrote more than 10 years ago.=A0 The drive tests at=0Aaround 1= 60Mbyte/s on bulk data and 4k tps for commit rate writing=0Asmall blocks.= =0A=0A=0A=0A-- Sent via pgsql-performance mailing list (pgsql-performance@p= ostgresql.org)=0ATo make changes to your subscription:=0Ahttp://www.postgre= sql.org/mailpref/pgsql-performance ---1802853223-2042894633-1317525762=:87269 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Do you hav= e an Intel 320?  I'd love to see tests comparing 710 to 320 and see if= it's worth the price premium.

<= div style=3D"font-size: 12pt; font-family: 'times new roman', 'new york', t= imes, serif; ">
From: David Boreham <david_list@boreh= am.org>
To: PGSQL Pe= rformance <pgsql-performance@postgresql.org>
Sent: Saturday, October 1, 2011 10:39 PM
= Subject: [PERFORM] Suggestion= s for Intel 710 SSD test

=0A
I have a 710 (Lyndonville) SS= D in a test server. Ultimately we'll run
capacity tests using our applic= ation (which in turn uses PG), but it'll
take a while to get those set u= p. In the meantime, I'd be happy to
entertain running whatever tests fol= ks here would like to suggest,
spare time-permitting.

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


<= br>-- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscript= ion:
http://www.postgresql.org/mailpref/pgsql-performance


---1802853223-2042894633-1317525762=:87269--