> ----- Original Message ----- > From: "Nathan Wilhelmi" <[EMAIL PROTECTED]> > To: <pgsql-general@postgresql.org> > Sent: Thursday, January 24, 2008 2:21 PM > Subject: [GENERAL] Disk configurations.... > > > > Hello - Typically case of a software guy needing to spec hardware for a > > new DB server. Further typified case of not knowing exact amount of data > > and I/O patterns. So if you were to spec a disk system for a new general > > purpose PostgreSQL server any suggestions of what to start with? > > > > Details I have: > > > > 1) We think 500GB is enough storage for the DB. > > 2) I would guess 66% read 33% write patterns, maybe closer to 50/50. > > > > I would assume that we would want to go SCSI raid. Would you do the > > whole disk array as Raid 5 or whole you partition it up differently? > > Would you go with 3x300gb disks or would you use more smaller disks to > > get there?
Do NOT use RAID5. Use RAID 10. If you can afford it, get a SCSI RAID controller with battery-backed cache and 15,000 RPM drives. -- Bill Moran http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
