Re: Postgresql 9.0.6 Raid 5 or not please help. - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Postgresql 9.0.6 Raid 5 or not please help.
Date
Msg-id CAOR=d=0bh9QATnRpSDuBXALsDd5XcJAWTaH-BqQ8ECzxkc0Qhw@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql 9.0.6 Raid 5 or not please help.  (tuanhoanganh <hatuan05@gmail.com>)
Responses Re: Postgresql 9.0.6 Raid 5 or not please help.  ("Satoshi Nagayasu" <satoshi.nagayasu@gmail.com>)
Re: Postgresql 9.0.6 Raid 5 or not please help.  (Mario Weilguni <roadrunner6@gmx.at>)
List pgsql-performance
On Thu, Dec 22, 2011 at 11:18 PM, tuanhoanganh <hatuan05@gmail.com> wrote:
> Thanks for your answer. But how performance between raid5 and one disk.

One disk will usually win, 2 disks (in a mirror) will definitely win.
RAID-5 has the highest overhead and the poorest performance,
especially if it's degraded (1 drive out) that simple mirroring
methods don't suffer from.  But even in an undegraded state it is
usually the slowest method.  RAID-10 is generally the fastest with
redundancy, and of course pure RAID-0 is fastest of all but has no
redundancy.

You should do some simple benchmarks with something like pgbench and
various configs to see for yourself.  For extra bonus points, break a
mirror (2 disk -> 1 disk) and compare it to RAID-5 (3 disk -> 2 disk
degraded) for performance.  The change in performance for a RAID-1 to
single disk degraded situation is usually reads are half as fast and
writes are just as fast.  For RAID-5 expect to see it drop by a lot.

pgsql-performance by date:

Previous
From: tuanhoanganh
Date:
Subject: Re: Postgresql 9.0.6 Raid 5 or not please help.
Next
From: "Satoshi Nagayasu"
Date:
Subject: Re: Postgresql 9.0.6 Raid 5 or not please help.