Asking for assistance in determining storage requirements

Поиск
Список
Период
Сортировка
You assistance is appreciated.


BODY{font:10pt Tahoma, Verdana, sans-serif;}

I have question regarding disk storage for postgres servers

 

We are thinking long term about scalable storage and performance and would like some advise
or feedback about what other people are using.

 

We would like to get as much performance from our file systems as possible.

 

We use ibm 3650 quad processor with onboard SAS controller ( 3GB/Sec) with 15,000rpm drives.

We use raid 1 for the centos operating system and the wal archive logs.

The postgres database is on 5 drives configured as raid 5 with a global hot spare.

 

We are curious about using SAN with fiber channel hba and if anyone else uses this technology.

We would also like to know if people have preference to the level of raid with/out striping.

p.MsoNormal,li.MsoNormal,div.MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}a:link,span.MsoHyperlink {color:blue;text-decoration:underline;}a:visited,span.MsoHyperlinkFollowed {color:purple;text-decoration:underline;}span.EmailStyle17 {mso-style-type:personal-compose;font-family:Arial;color:windowtext;}@page Section1 {size:612.0pt 792.0pt;margin:72.0pt 90.0pt 72.0pt 90.0pt;}div.Section1 {page:Section1;}
Sincerely,

Chris Barnes
Recognia Inc.
Senior DBA


Attention all humans. We are your photos. Free us.

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

Предыдущее
От: Ben Harper
Дата:
Сообщение: SELECT DISTINCT very slow
Следующее
От: "Paolo Saudin"
Дата:
Сообщение: PostgreSQL 8.4 Window functions