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?
