Re: Bad iostat numbers - Mailing list pgsql-performance

From Michael Stone
Subject Re: Bad iostat numbers
Date
Msg-id 20061204174320.GX1622@mathom.us
Whole thread Raw
In response to Re: Bad iostat numbers  ("Alex Turner" <armtuk@gmail.com>)
Responses Re: Bad iostat numbers
Re: Bad iostat numbers
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Configuration settings for 32GB RAM server
Next
From: Joost Kraaijeveld
Date:
Subject: How to move pg_xlog to another drive on Windows????