- 4-disk RAID-10 array containing data, 2-disk RAID-1 array for WAL, OS, etc
- 4-disk RAID-5 array containing data, 2-disk RAID-1 array for WAL, OS, etc
- 6-disk RAID-5 array (will probably perform worst)
Hope this helps.
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
undancy should a single disk fail.
I'd use RAID-5 if you absolutely cannot use more disks, but I would use
RAID-10 or two RAID-1 partitions if you can afford to use 4 disks.
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
---(end of broadcast)-
consider though:
- new files won't be created with the same options (I think), so you'll have
to run this command as a daily cronjob or something to that effect
- chattr is probably more filesystem-specific than a noatime mount, although
this isn't a problem on ext[23] ofcour
on ext3
(yes, better than XFS, JFS or ReiserFS) with a linux 2.4.21 kernel. Be sure to
mount noatime and to create the ext3 partition with the correct stripe size of
your RAID array using the '-R stride=foo' option (see man mke2fs).
Vincent van Leeuwen
Media Des
ome
different setups under your own database load to see what works best for you.
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
st)-----------
> > TIP 8: explain analyze is your friend
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: [EMAIL PROTECTED] secondary: [EMAIL PROTECTED]|postgresql}.org
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Vincent van Leeuwen
Media Design - http://www.mediadesign.nl/
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
