Re: Disk configurations....

> ----- Original Message ----- 
> From: "Nathan Wilhelmi" 
> To: 
> 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