Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec - Mailing list pgsql-performance

From Miguel
Subject Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Date
Msg-id 441F161D.7010502@123.com.sv
Whole thread Raw
In response to Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S  (Vivek Khera <vivek@khera.org>)
Responses Re: Best OS & Configuration for Dual Xeon w/4GB &  ("Luke Lonergan" <llonergan@greenplum.com>)
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 & Adaptec  (PFC <lists@peufeu.com>)
List 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 by date:

Previous
From: Alex Hayward
Date:
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &
Next
From: "Luke Lonergan"
Date:
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &