| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Cris Carampa <cris119(at)operamail(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Multiple disks |
| Date: | 2004-04-19 19:59:44 |
| Message-ID: | Pine.LNX.4.33.0404191356340.17372-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CoL | 2004-04-19 21:56:17 | Re: Going from a DB using SQL_ASCII to UNICODE |
| Previous Message | Dion Almaer | 2004-04-19 19:44:33 | Going from a DB using SQL_ASCII to UNICODE |