From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Curt Sampson <cjs(at)cynic(dot)net> |
Cc: | David Kennedy <satch(at)biteme(dot)bigpond(dot)net(dot)au>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: postgres installation - best configuration? |
Date: | 2003-01-31 05:27:42 |
Message-ID: | 200301310527.h0V5Rgm11021@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)cynic(dot)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(at)postgresql(dot)org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2003-01-31 05:29:39 | Re: [mail] Re: Windows Build System |
Previous Message | Giles Lean | 2003-01-31 05:03:22 | Re: On file locking |