Re: How to allocate 8 disks

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: How to allocate 8 disks
Дата
Msg-id 20080301130347.0832b323@commandprompt.com
обсуждение исходный текст
Ответ на How to allocate 8 disks  (Craig James <craig_james@emolecules.com>)
Ответы Re: How to allocate 8 disks  (Craig James <craig_james@emolecules.com>)
Re: How to allocate 8 disks  (Ivan Voras <ivoras@geri.cc.fer.hr>)
Список pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Sat, 01 Mar 2008 10:06:54 -0800
Craig James <craig_james@emolecules.com> wrote:

> We're upgrading to a medium-sized server, a Dell PowerEdge 2950,
> dual-quad CPU's and 8 GB memory.  This box can hold at most 8 disks
> (10K SCSI 2.5" 146 GB drives) and has Dell's Perc 6/i RAID controller.
> 
> I'm thinking of this:
> 
>   6 disks  RAID 1+0  Postgres data
>   1 disk   WAL
>   1 disk   Linux
> 
> I've often seen RAID 1 recommended for the WAL.  Is that strictly for
> reliability, or is there a performance advantage to RAID 1 for the
> WAL?
> 
> It seems to me separating the OS and WAL on two disks is better than
> making a single RAID 1 and sharing it, from a performance point of
> view.

This scares me... You lose WAL you are a goner. Combine your OS and
WAL into a RAID 1.

Sincerely,

Joshua D. Drake


- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHycSzATb/zqfZUUQRAs14AJ9pm3huW+z1j7jUIY7FbIZMzz2IxgCgnOhD
yWiDabTYAG+x12JEqrf4q8E=
=gBPs
-----END PGP SIGNATURE-----

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: How to allocate 8 disks
Следующее
От: Craig James
Дата:
Сообщение: Re: How to allocate 8 disks