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 00FCC9DCC91 for ; Mon, 20 Mar 2006 16:59:24 -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 73676-08 for ; Mon, 20 Mar 2006 16:59:25 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id 94BE99DCC84 for ; Mon, 20 Mar 2006 16:59:22 -0400 (AST) Received: from 172.16.1.110 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Mon, 20 Mar 2006 15:59:15 -0500 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 20 Mar 2006 15:59:15 -0500 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.118]) with Microsoft Exchange Server HTTP-DAV ; Mon, 20 Mar 2006 20:59:14 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Mon, 20 Mar 2006 12:59:13 -0800 Subject: Re: Best OS & Configuration for Dual Xeon w/4GB & From: "Luke Lonergan" To: "Miguel" , "Vivek Khera" cc: "Postgresql Performance" Message-ID: Thread-Topic: [PERFORM] Best OS & Configuration for Dual Xeon w/4GB & Adaptec Thread-Index: AcZMX9s8FmVNNnB+TreDdxBbSoKQegAAUj+q In-Reply-To: <441F161D.7010502@123.com.sv> MIME-Version: 1.0 X-OriginalArrivalTime: 20 Mar 2006 20:59:15.0217 (UTC) FILETIME=[258CF010:01C64C61] X-WSS-ID: 6801C8292XS30860204-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.333 required=5 tests=[AWL=0.080, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.333 X-Spam-Level: * X-Archive-Number: 200603/344 X-Sequence-Number: 17781 Miguel, On 3/20/06 12:52 PM, "Miguel" wrote: > i have a HP dl380 g3 with array 5i controlled (1+0), these are my results Another "known bad" RAID controller. The Smartarray 5i is horrible on Linux - this is the first BSD result I've seen. > Seek times: > Full stroke: 250 iter in 1.138232 sec = 4.553 msec > Half stroke: 250 iter in 1.084474 sec = 4.338 msec These seem OK - are they "access times" or are they actually "seek times"? Seems like with RAID 10, you should get better by maybe double. > 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? It's pretty slow. How many disk drives do you have? - Luke