Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D8D259FA103 for ; Tue, 5 Dec 2006 08:57:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 49353-07 for ; Tue, 5 Dec 2006 08:57:45 -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 96B7C9F9EED for ; Tue, 5 Dec 2006 08:57:45 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so211962nfb for ; Tue, 05 Dec 2006 04:57:44 -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=pRwZFQIMRVzkH3s+o/1d9E0vhHhT94LxSR3wCWWLFS5W2gebsha/0Z2vc38DIFE93tFqJjw2BAMRBW2Iji/n6gbMwJFCeSNo9lApdnoIZUqJ90MeLgFmYArOCxcEDXJjgKkGZotZe+6RnsNURLrOEuyGdFc03YKAOsvK75XWrds= Received: by 10.82.111.8 with SMTP id j8mr1709905buc.1165323463411; Tue, 05 Dec 2006 04:57:43 -0800 (PST) Received: by 10.82.153.6 with HTTP; Tue, 5 Dec 2006 04:57:43 -0800 (PST) Message-ID: <33c6269f0612050457s4a8eb0eas662d7a50fb5dfa89@mail.gmail.com> Date: Tue, 5 Dec 2006 07:57:43 -0500 From: "Alex Turner" To: pgsql-performance@postgresql.org Subject: Re: Bad iostat numbers In-Reply-To: <20061205121507.GZ1622@mathom.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5298_10220019.1165323463261" References: <33c6269f0612032317t9f0bc77n3ff791a5cd88fc80@mail.gmail.com> <33c6269f0612042221x5820e98bl96f8d0dc4a87bd3f@mail.gmail.com> <20061205121507.GZ1622@mathom.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/74 X-Sequence-Number: 22130 ------=_Part_5298_10220019.1165323463261 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline The problem I see with software raid is the issue of a battery backed unit: If the computer loses power, then the 'cache' which is held in system memory, goes away, and fubars your RAID. Alex On 12/5/06, Michael Stone wrote: > > On Tue, Dec 05, 2006 at 01:21:38AM -0500, Alex Turner wrote: > >My other and most important point is that I can't find any solid > >recommendations for a SCSI card that can perform optimally in Linux or > >*BSD. Off by a factor of 3x is pretty sad IMHO. (and yes, we know the > >Adaptec cards suck worse, that doesn't bring us to a _good_ card). > > This gets back to my point about terminology. As a SCSI HBA the Adaptec > is decent: I can sustain about 300MB/s off a single channel of the > 39320A using an external RAID controller. As a RAID controller I can't > even imagine using the Adaptec; I'm fairly certain they put that > "functionality" on there just so they could charge more for the card. It > may be that there's not much market for on-board SCSI RAID controllers; > between SATA on the low end and SAS & FC on the high end, there isn't a > whole lotta space left for SCSI. I definitely don't think much > R&D is going into SCSI controllers any more, compared to other solutions > like SATA or SAS RAID (the 39320 hasn't change in at least 3 years, > IIRC). Anyway, since the Adaptec part is a decent SCSI controller and a > lousy RAID controller, have you tried just using software RAID? > > Mike Stone > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ------=_Part_5298_10220019.1165323463261 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline The problem I see with software raid is the issue of a battery backed unit: If the computer loses power, then the 'cache' which is held in system memory, goes away, and fubars your RAID.

Alex

On 12/5/06, Michael Stone <mstone+postgres@mathom.us> wrote:
On Tue, Dec 05, 2006 at 01:21:38AM -0500, Alex Turner wrote:
>My other and most important point is that I can't find any solid
>recommendations for a SCSI card that can perform optimally in Linux or
>*BSD.  Off by a factor of 3x is pretty sad IMHO. (and yes, we know the
>Adaptec cards suck worse, that doesn't bring us to a _good_ card).

This gets back to my point about terminology. As a SCSI HBA the Adaptec
is decent: I can sustain about 300MB/s off a single channel of the
39320A using an external RAID controller. As a RAID controller I can't
even imagine using the Adaptec; I'm fairly certain they put that
"functionality" on there just so they could charge more for the card. It
may be that there's not much market for on-board SCSI RAID controllers;
between SATA on the low end and SAS & FC on the high end, there isn't a
whole lotta space left for SCSI. I definitely don't think much
R&D is going into SCSI controllers any more, compared to other solutions
like SATA or SAS RAID (the 39320 hasn't change in at least 3 years,
IIRC). Anyway, since the Adaptec part is a decent SCSI controller and a
lousy RAID controller, have you tried just using software RAID?

Mike Stone

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

------=_Part_5298_10220019.1165323463261--