Richard Neill wrote:
> 3. RAID 0 is twice as unreliable as no raid. I'd recommend using RAID 1
> intead. If you use the Linux software mdraid, remote admin is easy.
The main thing to be wary of with Linux software RAID-1 is that you
configure things so that both drives are capable of booting the system.
It's easy to mirror the data, but not the boot loader and the like.
> 7. If you have 3 equal disks, try doing some experiments. My inclination
> would be to set them all up with ext4...
I have yet to yet a single positive thing about using ext4 for
PostgreSQL. Stick with ext3, where the problems you might run into are
at least well understood and performance is predictable.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com www.2ndQuadrant.com