Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec

From: Miguel <mmiranda(at)123(dot)com(dot)sv>
To: Vivek Khera <vivek(at)khera(dot)org>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec
Date: 2006-03-20 23:04:10
Message-ID: 441F34EA.6020100@123.com.sv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Vivek Khera wrote:

>>> 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
>> [...]
>> is this good enough?
>
>
> Is that on a loaded box or a mostly quiet box? Those number seem
> rather low for my tastes. For comparison, here are numbers from a
> Dell 1850 with a built-in PERC 4e/Si RAID in a two disk mirror. All
> numbers below are on mostly or totally quiet disk systems.

My numbers are on totally quiet box, i've just installed it.

>
> amrd0
> 512 # sectorsize
> 73274490880 # mediasize in bytes (68G)
> 143114240 # mediasize in sectors
> 8908 # Cylinders according to firmware.
> 255 # Heads according to firmware.
> 63 # Sectors according to firmware.
>
> Seek times:
> Full stroke: 250 iter in 0.756718 sec = 3.027 msec
> Half stroke: 250 iter in 0.717824 sec = 2.871 msec
> Quarter stroke: 500 iter in 1.972368 sec = 3.945 msec
> Short forward: 400 iter in 1.193179 sec = 2.983 msec
> Short backward: 400 iter in 1.322440 sec = 3.306 msec
> Seq outer: 2048 iter in 0.271402 sec = 0.133 msec
> Seq inner: 2048 iter in 0.271151 sec = 0.132 msec
> Transfer rates:
> outside: 102400 kbytes in 1.080339 sec = 94785
> kbytes/sec
> middle: 102400 kbytes in 1.166021 sec = 87820
> kbytes/sec
> inside: 102400 kbytes in 1.461498 sec = 70065
> kbytes/sec
>
>
Umm, in my box i see better seektimes but worst transfer rates, does it
make sense?
i think i have something wrong, the question i cant answer is what
tunning am i missing?

---
Miguel

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vivek Khera 2006-03-20 23:05:35 Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec RAID 2200S
Previous Message Jim Buttafuoco 2006-03-20 22:56:34 Re: update == delete + insert?