suggestions for postgresql setup on Dell 2950 , PERC6i controller

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема suggestions for postgresql setup on Dell 2950 , PERC6i controller
Дата
Msg-id a97c77030902041045p603fc49g15b5b3f3a2e0da8d@mail.gmail.com
обсуждение исходный текст
Ответы Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Gary Doades <gpd@gpdnet.co.uk>)
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
Hi,

I am going to get a Dell 2950 with PERC6i with
8 * 73 15K SAS drives +
300 GB EMC SATA SAN STORAGE,

I seek suggestions from users sharing their experience with
similar hardware if any. I have following specific concerns.

1. On list i read  that RAID10 function in PERC5 is not really
   striping but spanning and does not give performance boost
   is it still true in case of PERC6i ?


2. I am planning for RAID10 array of 8 drives for entrire database
   ( including pg_xlog)  , the controller has a write back cache (256MB)
   is it a good idea ?
   or is it better to have 6 drives in HW RAID1 and RAID0 of 3 mirrors
   in s/w  and leave 2 drives (raid1) for OS ?

3. Is there any preferred Stripe Size for RAID0  for postgresql usage ?


4. Although i would benchmark (with bonnie++) how would the EMC
   SATA SAN storage compare with locally attached SAS storage for the
   purpose of hosting the data  , i am hiring the storage primarily for
   storing base base backups and  log archives for PITR implementation.
   as retal of separate machine was higher than SATA SAN.

Regds
mallah.

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

Предыдущее
От: Jeff
Дата:
Сообщение: Re: SSD performance
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller