Re: New system recommendations - Mailing list pgsql-admin

From Benjamin Krajmalnik
Subject Re: New system recommendations
Date
Msg-id 8511B4970E0D124898E973DF496F9B432515D9@stash.stackdump.local
Whole thread Raw
In response to New system recommendations  ("Benjamin Krajmalnik" <kraj@illumen.com>)
Responses Re: New system recommendations
List pgsql-admin
I was thinking of going Raid 0 to increase the active spindles.  But,
come to think about it, if I go to FreeBSD I really do not need to go
that route, since I can use a symlink and, as suggested, move the logs
to another spindle.
I was also wary of the Raid 0 approach - specially since last year I had
2 drives in a Raid 5 fail within 5 minutes of each other!

Assuming that presently the server's capability as far as drives is 3
drives, would you recommend doing a RAID-1 on 2 drives and an additional
non RAIDed drive to hold the WAL?  Anything else which shold be moved to
the other spindle?
Any recommendations when building the kernel (FreeBSD 6.0)?

Regards,

Benjamin



pgsql-admin by date:

Previous
From: Bricklen Anderson
Date:
Subject: Re: IsDate function in plpgsql
Next
From: Craig Servin
Date:
Subject: Alter table alter column using question