| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Hannu Krosing <hannu(at)tm(dot)ee> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Hardware performance |
| Date: | 2003-07-17 14:57:53 |
| Message-ID: | 3F16B971.7050104@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hannu Krosing wrote:
> How do you do RAID 1+0 with just two drives ?
>
Hmm, good point -- I must have been tired last night ;-). With two
drives you can do mirroring or striping, but not both.
Usually I've seen a pair of mirrored drives for the OS, and a RAID 1+0
array for data. But that requires 6 drives, not 5. On non-database
servers usually the data array is RAID 5, and you could get away with 5
drives (as someone else pointed out).
As I said, I've never personally found it necessary to move WAL off to a
different physical drive. What do you think is the best configuration
given the constraint of 5 drives? 1 drive for OS, and 4 for RAID 1+0 for
data-plus-WAL? I guess the ideal would be to find enough money for that
6th drive, use the mirrored pair for both OS and WAL.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Witney | 2003-07-17 15:04:38 | Re: Hardware performance |
| Previous Message | Bill Moran | 2003-07-17 14:45:35 | Relation of indices to ANALYZE |