Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B04A89FA192 for ; Mon, 4 Dec 2006 13:52:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 47183-03 for ; Mon, 4 Dec 2006 13:52:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.186]) by postgresql.org (Postfix) with ESMTP id 651B69FA0EE for ; Mon, 4 Dec 2006 13:52:48 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so4575634nfb for ; Mon, 04 Dec 2006 09:52:47 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=q11uhN87B8B6g4oS9imFBG0EASQkjzuosqaWXecwHS+I1npTsMbjA15CXFy6gPZEoz4BU6YmJvZFS6wOyElTS6HBVrsFD2bhCcD6RwfCuLSboneXBplUf6NTlOFjOl0hlletRHttiydKl0B0NiP7sEdT35wQO7XOdDlVfJpC1Gc= Received: by 10.82.138.6 with SMTP id l6mr1534377bud.1165254766462; Mon, 04 Dec 2006 09:52:46 -0800 (PST) Received: by 10.82.153.6 with HTTP; Mon, 4 Dec 2006 09:52:46 -0800 (PST) Message-ID: <33c6269f0612040952l461407dcsd52b3f2c57825431@mail.gmail.com> Date: Mon, 4 Dec 2006 12:52:46 -0500 From: "Alex Turner" To: pgsql-performance@postgresql.org Subject: Re: Bad iostat numbers In-Reply-To: <20061204174320.GX1622@mathom.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31268_3053303.1165254766093" References: <33c6269f0612032317t9f0bc77n3ff791a5cd88fc80@mail.gmail.com> <1165249513.14565.329.camel@state.g2switchworks.com> <33c6269f0612040937l276c5178naecac1983d355e29@mail.gmail.com> <20061204174320.GX1622@mathom.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/54 X-Sequence-Number: 22110 ------=_Part_31268_3053303.1165254766093 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline http://en.wikipedia.org/wiki/RAID_controller Alex On 12/4/06, Michael Stone wrote: > > On Mon, Dec 04, 2006 at 12:37:29PM -0500, Alex Turner wrote: > >This discussion I think is important, as I think it would be useful for > this > >list to have a list of RAID cards that _do_ work well under Linux/BSD for > >people as recommended hardware for Postgresql. So far, all I can > recommend > >is what I've found to be good, which is 3ware 9500 series cards with 10k > >SATA drives. Throughput was great until you reached higher levels of > RAID > >10 (the bonnie++ mark I posted showed write speed is a bit slow). But > that > >doesn't solve the problem for SCSI. What cards in the SCSI arena solve > the > >problem optimally? Why should we settle for sub-optimal performance in > SCSI > >when there are a number of almost optimally performing cards in the SATA > >world (Areca, 3Ware/AMCC, LSI). > > Well, one factor is to be more precise about what you're looking for; a > HBA != RAID controller, and you may be comparing apples and oranges. (If > you have an external array with an onboard controller you probably want > a simple HBA rather than a RAID controller.) > > Mike Stone > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > ------=_Part_31268_3053303.1165254766093 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline http://en.wikipedia.org/wiki/RAID_controller

Alex

On 12/4/06, Michael Stone < mstone+postgres@mathom.us> wrote:
On Mon, Dec 04, 2006 at 12:37:29PM -0500, Alex Turner wrote:
>This discussion I think is important, as I think it would be useful for this
>list to have a list of RAID cards that _do_ work well under Linux/BSD for
>people as recommended hardware for Postgresql.   So far, all I can recommend
>is what I've found to be good, which is 3ware 9500 series cards with 10k
>SATA drives.  Throughput was great until you reached higher levels of RAID
>10 (the bonnie++ mark I posted showed write speed is a bit slow).  But that
>doesn't solve the problem for SCSI.  What cards in the SCSI arena solve the
>problem optimally?  Why should we settle for sub-optimal performance in SCSI
>when there are a number of almost optimally performing cards in the SATA
>world (Areca, 3Ware/AMCC, LSI).

Well, one factor is to be more precise about what you're looking for; a
HBA != RAID controller, and you may be comparing apples and oranges. (If
you have an external array with an onboard controller you probably want
a simple HBA rather than a RAID controller.)

Mike Stone

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

------=_Part_31268_3053303.1165254766093--