Re: Disk configurations.... - Mailing list pgsql-general

From Bill Moran
Subject Re: Disk configurations....
Date
Msg-id 20080124221021.9caffb9c.wmoran@potentialtech.com
Whole thread Raw
In response to Re: Disk configurations....  ("Martin Gainty" <mgainty@hotmail.com>)
List pgsql-general
> ----- Original Message -----
> From: "Nathan Wilhelmi" <wilhelmi@ucar.edu>
> 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

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: close connection
Next
From: Ow Mun Heng
Date:
Subject: DB wide Vacuum(Goes thru readonly tables) vs Autovacuum