best arrangement of 3 disks for (insert) performance

От: Richard Jones
Тема: best arrangement of 3 disks for (insert) performance
Дата: ,
Msg-id: 200309121126.29756.rj@last.fm
(см: обсуждение, исходный текст)
Ответы: Re: best arrangement of 3 disks for (insert) performance  ("Matt Clark")
Re: best arrangement of 3 disks for (insert) performance  (Josh Berkus)
Список: pgsql-performance

Скрыть дерево обсуждения

best arrangement of 3 disks for (insert) performance  (Richard Jones, )
 Re: best arrangement of 3 disks for (insert) performance  ("Matt Clark", )
 Re: best arrangement of 3 disks for (insert) performance  (Christopher Browne, )
  Re: best arrangement of 3 disks for (insert) performance  (Richard Jones, )
   Re: best arrangement of 3 disks for (insert) performance  (Rod Taylor, )
  Re: best arrangement of 3 disks for (insert) performance  (Cott Lang, )
 Re: best arrangement of 3 disks for (insert) performance  (Josh Berkus, )
  Re: best arrangement of 3 disks for (insert) performance  (Richard Jones, )

Hi all,
I have some new hardware on the way and would like some advice on how to get
the most out of it..

its a dual xeon 2.4,  4gb ram and 3x identical 15k rpm scsi disks

should i mirror 2 of the disks for postgres data, and use the 3rd disk for the
o/s and the pg logs or raid5 the 3 disks or even stripe 2 disks for pg and
use the 3rd for o/s,logs,backups ?

the machine will be dealing with lots of inserts, basically as many as we can
throw at it

thanks,
Richard


В списке pgsql-performance по дате сообщения:

От: "scott.marlowe"
Дата:
Сообщение: Re: [GENERAL] how to get accurate values in pg_statistic
От: Christopher Browne
Дата:
Сообщение: Re: software vs hw hard on linux