Dual Xeon + HW RAID question

От: alexandre arruda paes :: aldeia digital
Тема: Dual Xeon + HW RAID question
Дата: ,
Msg-id: 1192.192.168.1.100.1057859005.squirrel@webmail.ad2.com.br
(см: обсуждение, исходный текст)
Ответы: Re: Dual Xeon + HW RAID question  (Rod Taylor)
Список: pgsql-performance

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

Dual Xeon + HW RAID question  ("alexandre arruda paes :: aldeia digital", )
 Re: Dual Xeon + HW RAID question  (Rod Taylor, )
 Re: Dual Xeon + HW RAID question  ("Nikolaus Dilger", )
  [OT] Such incredible h/w (was Re: Dual Xeon + HW RAID question)  (Ron Johnson, )
  Re: Dual Xeon + HW RAID question  (Andrew Sullivan, )
  Re: Dual Xeon + HW RAID question  (SZUCS Gábor, )
   Re: Dual Xeon + HW RAID question  ("alexandre paes :: aldeia digital", )
   Re: Dual Xeon + HW RAID question  (Bruce Momjian, )
    Re: Dual Xeon + HW RAID question  ("Mindaugas Riauba", )
     Re: Dual Xeon + HW RAID question  (Bruce Momjian, )
      Re: Dual Xeon + HW RAID question  (SZUCS Gábor, )
       Re: Dual Xeon + HW RAID question  (Jord Tanner, )
        Re: Dual Xeon + HW RAID question  (Bruce Momjian, )
         Re: Dual Xeon + HW RAID question  (Jord Tanner, )
          Re: Dual Xeon + HW RAID question  (Bruce Momjian, )
           Re: Dual Xeon + HW RAID question  (Jord Tanner, )
       Re: Dual Xeon + HW RAID question  (Bruce Momjian, )

Hi,

I have this machine with a 10 million records:
* Dual Xeon 2.0 (HyperThreading enabled), 3 7200 SCSI , Adaptec 2110S,
RAID 5 - 32k chunk size, 1 GB Ram DDR 266 ECC, RH 8.0 - 2.4.18

The database is mirrored with contrib/dbmirror in a P4 1 Gb Ram + IDE

If a disk failure occurs, I can use the server in the mirror.

I will format the main server in this weekend and I have seen in the list
some people that recomends a Software RAID instead HW.

I think too remove the RAID 5 and turn a RAID 1 for data in 2 HDs.
SO, WAL and swap in the thrid HD.

My questions:

1) I will see best disk performance changing the disk layout like above
2) HyperThreading really improve a procces basead program, like postgres

Thank´s for all

Alexandre




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

От: Rich Cullingford
Дата:
Сообщение: pre-Vacuum statistics
От: Scott Cain
Дата:
Сообщение: force the use of a particular index