Re: postgres installation - best configuration?

Also, I have heard a lot of people reocommending RAID 0+1 or 1+0 as a
good mix of reliability and performance.

---------------------------------------------------------------------------

Curt Sampson wrote:
> On Thu, 23 Jan 2003, David Kennedy wrote:
> 
> > This weekend I will be building a couple of new postgres database servers
> > under RH7.3, and I am currently deciding between 2 different configuration
> > options. The new servers feature hot-swappable RAID w/ 3 hard drives in
> > each.
> 
> It depends on what you need in terms of reliability and performance.
> 
> Best performance (assuming non-insignifcant write load):
> 
>     Put the OS and DB on the first two drives, striped (RAID0), and the
>     logs on the third drive.
> 
> Best safety maximum capacity:
> 
>     Put everything on a single RAID5 across all three drives. (RAID5 on
>     three drives is likely to be significantly slower than a single disk
>     or mirrored pair would be, though.)
> 
> Best safety with good performance:
> 
>     Mirror two drives (RAID1) and put everything on the pair. Use the
>     third drive as a hot spare for the mirrored pair.
> 
> cjs
> -- 
> Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
>     Don't you know, in this new Dark Age, we're all light.  --XTC
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073