Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
От | Miguel |
---|---|
Тема | Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec |
Дата | |
Msg-id | 441F161D.7010502@123.com.sv обсуждение исходный текст |
Ответ на | Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S (Vivek Khera <vivek@khera.org>) |
Ответы |
Re: Best OS & Configuration for Dual Xeon w/4GB &
Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec |
Список | pgsql-performance |
Vivek Khera wrote: > > On Mar 17, 2006, at 5:11 PM, Kenji Morishige wrote: > >> In summary, my questions: >> >> 1. Would running PG on FreeBSD 5.x or 6.x or Linux improve performance? > > > FreeBSD 6.x will definitely get you improvements. Many speedup > improvements have been made to both the generic disk layer and the > specific drivers. However, the current best of breed RAID controller > is the LSI 320-x (I use 320-2X). I have one box into which this > card will not fit (Thanks Sun, for making a box with only low-profile > slots!) so I use an Adaptec 2230SLP card in it. Testing shows it is > about 80% speed of a LSI 320-2x on sequential workload (load DB, run > some queries, rebuild indexes, etc.) > > If you do put on FreeBSD 6, I'd love to see the output of "diskinfo - > v -t" on your RAID volume(s). > Not directly related ... i have a HP dl380 g3 with array 5i controlled (1+0), these are my results shiva2# /usr/sbin/diskinfo -v -t /dev/da2s1d /dev/da2s1d 512 # sectorsize 218513555456 # mediasize in bytes (204G) 426784288 # mediasize in sectors 52301 # Cylinders according to firmware. 255 # Heads according to firmware. 32 # Sectors according to firmware. Seek times: Full stroke: 250 iter in 1.138232 sec = 4.553 msec Half stroke: 250 iter in 1.084474 sec = 4.338 msec Quarter stroke: 500 iter in 1.690313 sec = 3.381 msec Short forward: 400 iter in 0.752646 sec = 1.882 msec Short backward: 400 iter in 1.306270 sec = 3.266 msec Seq outer: 2048 iter in 0.766676 sec = 0.374 msec Seq inner: 2048 iter in 0.803759 sec = 0.392 msec Transfer rates: outside: 102400 kbytes in 2.075984 sec = 49326 kbytes/sec middle: 102400 kbytes in 2.100510 sec = 48750 kbytes/sec inside: 102400 kbytes in 2.042313 sec = 50139 kbytes/sec is this good enough?
В списке pgsql-performance по дате отправления: