Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 61C452E014C for ; Thu, 13 Mar 2008 13:10:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 94169-06 for ; Thu, 13 Mar 2008 13:10:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from n67.bullet.mail.sp1.yahoo.com (n67.bullet.mail.sp1.yahoo.com [98.136.44.47]) by postgresql.org (Postfix) with SMTP id ADFCA2E0179 for ; Thu, 13 Mar 2008 13:10:52 -0300 (ADT) Received: from [216.252.122.219] by n67.bullet.mail.sp1.yahoo.com with NNFMP; 13 Mar 2008 16:10:51 -0000 Received: from [209.191.108.96] by t4.bullet.sp1.yahoo.com with NNFMP; 13 Mar 2008 16:10:51 -0000 Received: from [209.191.119.164] by t3.bullet.mud.yahoo.com with NNFMP; 13 Mar 2008 16:10:51 -0000 Received: from [127.0.0.1] by omp103.mail.mud.yahoo.com with NNFMP; 13 Mar 2008 16:10:51 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 170787.92399.bm@omp103.mail.mud.yahoo.com Received: (qmail 84209 invoked by uid 60001); 13 Mar 2008 16:10:50 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=XT2oqby8krXUUSp+C+/jQH/naQvGwZqSwNk5iUiCyIdi0++Ewv6I2dJtqu6DvSg974xuMvUUwXS9o5IluFNmOv+mDdJdKfdDTAljJhhgf69+L7/DiT98BXU5AcRiVISJ8zo/W5XQC/Y2lC5S/dsDKC/WlQW7T3N3Op/dWbXQYwY=; X-YMail-OSG: b.jXQP4VM1nsZBkzrRvtyFTeoyssn.4R7033QgsUa2j2kO.f2sSo6QWslyfea9ybqgfI_rO0FpCPUKx3urHZCVBD.ZVeQrLaQA._DherZr4cTH0YRg77UbsjP8Y- Received: from [83.166.184.142] by web25812.mail.ukl.yahoo.com via HTTP; Thu, 13 Mar 2008 16:10:49 GMT X-Mailer: YahooMailRC/902.38 YahooMailWebService/0.7.162 Date: Thu, 13 Mar 2008 16:10:49 +0000 (GMT) From: Glyn Astill Subject: Re: Recomendations on raid controllers raid 1+0 To: Guillaume Smet Cc: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Message-ID: <992988.82686.qm@web25812.mail.ukl.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/285 X-Sequence-Number: 29239 Bonie++ benchmarks below.=0A=0AI believe the the Perc 5/i Raid 10 mode is a= ctually a span of mirrors, rather than the expected stripe of mirrors we sh= ould expect from 1+0, and that this is the reason for the shitty performanc= e.=0A=0A=0ARAID 5=0A=3D=3D=3D=3D=3D=3D=0AVersion 1.03 ------Sequenti= al Output------ --Sequential Input- --Random-=0A -Per Ch= r- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--=0AMachine Size = K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP=0Away5a = 32096M 55354 97 201375 59 109586 23 59934 97 427541 33 767.9 1=0A = ------Sequential Create------ --------Random Create-------= -=0A -Create-- --Read--- -Delete-- -Create-- --Read--- -= Delete--=0A files /sec %CP /sec %CP /sec %CP /sec %CP /se= c %CP /sec %CP=0A 16 +++++ +++ +++++ +++ +++++ +++ +++++ += ++ +++++ +++ +++++ +++=0Away5a,32096M,55354,97,201375,59,109586,23,59934,97= ,427541,33,767.9,1,16,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++= ++,+++=0A=0ARAID 10=0A=3D=3D=3D=3D=3D=3D=3D=0AVersion 1.03 ------Seq= uential Output------ --Sequential Input- --Random-=0A -P= er Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--=0AMachine = Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP=0AWay5a = 32096M 53479 99 131640 33 66718 10 58225 95 339287 25 699.1 1= =0A ------Sequential Create------ --------Random Create-= -------=0A -Create-- --Read--- -Delete-- -Create-- --Rea= d--- -Delete--=0A files /sec %CP /sec %CP /sec %CP /sec %C= P /sec %CP /sec %CP=0A 16 +++++ +++ +++++ +++ +++++ +++ += ++++ +++ +++++ +++ +++++ +++=0AWay5a,32096M,53479,99,131640,33,66718,10,582= 25,95,339287,25,699.1,1,16,+++++,+++,+++++,+++,+++++,+++,+++++,+++,+++++,++= +,+++++,+++=0A=0A=0A----- Original Message ----=0A> From: Guillaume Smet =0A> To: Glyn Astill =0A> C= c: pgsql-performance@postgresql.org=0A> Sent: Thursday, 13 March, 2008 3:58= :41 PM=0A> Subject: Re: [PERFORM] Recomendations on raid controllers raid 1= +0=0A> =0A> Glyn,=0A> =0A> On Thu, Mar 13, 2008 at 1:33 PM, Glyn Astill wro= te:=0A> > I'm looking at switching out the perc5i (lsi megaraid) cards from= our=0A> > Dell 2950s for something else as they're crap at raid 10.=0A> = =0A> Do you have numbers? Perc 5/i cards perform quite well for us (we have= =0A> a 8 disks RAID 10 in a 2900 server with the traditional Perc 5/i).=0A>= =0A> --=0A> Guillaume=0A=0A=0A ______________________________________= _____________________ =0ARise to the challenge for Sport Relief with Yahoo!= For Good =0A=0Ahttp://uk.promotions.yahoo.com/forgood/