RAID stripe size question

Поиск
Список
Период
Сортировка
От Mikael Carneholm
Тема RAID stripe size question
Дата
Msg-id 7F10D26ECFA1FB458B89C5B4B0D72C2B4E4BB1@sesrv12.wirelesscar.com
обсуждение исходный текст
Ответы Re: RAID stripe size question  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Re: RAID stripe size question  (Michael Stone <mstone+postgres@mathom.us>)
Re: RAID stripe size question  ("Alex Turner" <armtuk@gmail.com>)
Список pgsql-performance

I have finally gotten my hands on the MSA1500 that we ordered some time ago. It has 28 x 10K 146Gb drives, currently grouped as 10 (for wal) + 18 (for data). There's only one controller (an emulex), but I hope performance won't suffer too much from that. Raid level is 0+1, filesystem is ext3.

Now to the interesting part: would it make sense to use different stripe sizes on the separate disk arrays? In theory, a smaller stripe size (8-32K) should increase sequential write throughput at the cost of decreased positioning performance, which sounds good for WAL (assuming WAL is never "searched" during normal operation). And for disks holding the data, a larger stripe size (>32K) should provide for more concurrent (small) reads/writes at the cost of decreased raw throughput. This is with an OLTP type application in mind, so I'd rather have high transaction throughput than high sequential read speed. The interface is a 2Gb FC so I'm throttled to (theoretically) 192Mb/s, anyway.

So, does this make sense? Has anyone tried it and seen any performance gains from it?

Regards,
Mikael.

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Big differences in plans between 8.0 and 8.1
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: RAID stripe size question