Re: Disk configurations....

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Disk configurations....
Дата
Msg-id 20080124221021.9caffb9c.wmoran@potentialtech.com
обсуждение исходный текст
Ответ на Re: Disk configurations....  ("Martin Gainty" <mgainty@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: close connection
Следующее
От: Ow Mun Heng
Дата:
Сообщение: DB wide Vacuum(Goes thru readonly tables) vs Autovacuum