Re: Multiple disks - Mailing list pgsql-admin

From scott.marlowe
Subject Re: Multiple disks
Date
Msg-id Pine.LNX.4.33.0404191356340.17372-100000@css120.ihs.com
Whole thread Raw
In response to Re: Multiple disks  (Cris Carampa <cris119@operamail.com>)
List pgsql-admin
On Thu, 15 Apr 2004, Cris Carampa wrote:

> scott.marlowe wrote:
>
> > The current king of putting postgresql on multiple platters and getting
> > best overall performance is a battery backed caching raid controller run
> > one or more many disk RAID-5 arrays.
>
> I thought the best choice were RAID-10 (1+0) (when available). There
> isn't a write penalty with RAID-5?

there is for software RAID-5 or for non-battery backed cached RAID-5, but
for a battery backed controller, the penalty is basically gotten rid of by
being hidden in a lazy write.  Plus the controller can "gang" writes to
individual drives to achieve a very good throughput.


pgsql-admin by date:

Previous
From: "Dion Almaer"
Date:
Subject: Going from a DB using SQL_ASCII to UNICODE
Next
From: Tom Lane
Date:
Subject: Re: Going from a DB using SQL_ASCII to UNICODE