Re: Bad iostat numbers

From: "Alex Turner" <armtuk(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Bad iostat numbers
Date: 2006-12-04 17:52:46
Message-ID: 33c6269f0612040952l461407dcsd52b3f2c57825431@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

http://en.wikipedia.org/wiki/RAID_controller

Alex

On 12/4/06, Michael Stone <mstone+postgres(at)mathom(dot)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
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Stone 2006-12-04 18:03:17 Re: Bad iostat numbers
Previous Message Joost Kraaijeveld 2006-12-04 17:48:19 How to move pg_xlog to another drive on Windows????