X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D48659DC9C6 for ; Mon, 20 Mar 2006 19:00:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95301-08 for ; Mon, 20 Mar 2006 19:00:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from asgard1.americatelsal.com (asgard1.americatelsal.com [200.13.161.7]) by postgresql.org (Postfix) with ESMTP id 6AA8D9DC9FC for ; Mon, 20 Mar 2006 19:00:28 -0400 (AST) Received: (qmail 70474 invoked from network); 20 Mar 2006 23:23:11 -0000 Received: from unknown (HELO ?192.168.10.124?) (200.13.161.68) by asgard1.americatelsal.com with SMTP; 20 Mar 2006 23:23:11 -0000 Message-ID: <441F34EA.6020100@123.com.sv> Date: Mon, 20 Mar 2006 17:04:10 -0600 From: Miguel User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Vivek Khera CC: Postgresql Performance Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & Adaptec References: <20060317221116.GA14661@juniper.net> <8F6490E1-64E2-406B-A559-7DA8BA1EB197@khera.org> <441F161D.7010502@123.com.sv> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.025 required=5 tests=[AWL=0.025] X-Spam-Score: 0.025 X-Spam-Level: X-Archive-Number: 200603/354 X-Sequence-Number: 17791 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