Optimal settings for RAID controller - optimized for writes

Поиск
Список
Период
Сортировка
От Niels Kristian Schjødt
Тема Optimal settings for RAID controller - optimized for writes
Дата
Msg-id D89BE95F-60D2-431B-A82D-53378392AAC3@autouncle.com
обсуждение исходный текст
Ответы Re: Optimal settings for RAID controller - optimized for writes  (DFE <mimmopasticcio@gmail.com>)
Re: Optimal settings for RAID controller - optimized for writes  ("Tomas Vondra" <tv@fuzzy.cz>)
Re: Optimal settings for RAID controller - optimized for writes  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance
Hi,

I’m kind of a noob when it comes to setting up RAID controllers and tweaking them so I need some advice here.

I’m just about to setup my newly rented DELL R720 12. gen server. It’s running a single Intel Xeon E5-2620 v.2
processorand 64GB ECC ram. I have installed 8 300GB SSDs in it. It has an PERC H710 raid controller (Based on the LSI
SAS2208 dual core ROC).  

Now my database should be optimized for writing. UPDATEs are by far my biggest bottleneck.

Firstly: Should I just put all 8 drives in one single RAID 10 array, or would it be better to have the 6 of them in one
RAID10 array, and then the remaining two in a separate RAID 1 array e.g. for having WAL log dir on it’s own drives? 

Secondly: Now what settings should I pay attention to when setting this up, if I wan’t it to have optimal write
performance(cache behavior, write back etc.)? 

THANKS!

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

Предыдущее
От: Tory M Blue
Дата:
Сообщение: Re: Can one Dump schema without index/constraints?
Следующее
От: DFE
Дата:
Сообщение: Re: Optimal settings for RAID controller - optimized for writes