From owner-freebsd-performance@FreeBSD.ORG Wed Apr 14 13:54:06 2010 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id B410F106564A for ; Wed, 14 Apr 2010 13:54:06 +0000 (UTC) (envelope-from cwf-ml@arcor.de) Received: from mail.arcor.net (mail.arcor.net [145.253.32.2]) by mx1.freebsd.org (Postfix) with ESMTP id 3FF618FC0C for ; Wed, 14 Apr 2010 13:54:05 +0000 (UTC) Received: from mail-gw.arcor.net (sunmaildns01.arcor.net [62.213.136.73]) by mail.arcor.net (8.13.8/8.13.8) with ESMTP id o3EDs4LB025306 for ; Wed, 14 Apr 2010 15:54:04 +0200 (MEST) Received: from tkmail.arcor.net (esbanl-1ug-1-p2.arcor.net [62.213.137.69]) by mail-gw.arcor.net (8.13.8/8.13.8) with ESMTP id o3EDs4Vf023629 for ; Wed, 14 Apr 2010 15:54:04 +0200 (MEST) Received: from sky.tnd.arcor.net (sky.tnd.arcor.net [10.128.188.151]) by tkmail.arcor.net (Postfix) with ESMTP id BDF3B1FFF for ; Wed, 14 Apr 2010 15:54:03 +0200 (MEST) Received: from [10.128.189.1] (wefapc.tnd.arcor.net [10.128.189.1]) by sky.tnd.arcor.net (Postfix) with ESMTP id 9C1942F4A for ; Wed, 14 Apr 2010 15:54:03 +0200 (MEST) Message-ID: <4BC5C8FA.3030505@arcor.de> Date: Wed, 14 Apr 2010 15:54:02 +0200 From: Christoph Weber-Fahr User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4 MIME-Version: 1.0 To: freebsd-performance@freebsd.org References: <4BC4D46B.9040805@arcor.de> In-Reply-To: X-Enigmail-Version: 1.0.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Subject: Re: is there a problem with the HP SmartArray P410 and/or Postgres on FreeBSD ? X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2010 13:54:06 -0000 Hello, On 14.04.2010 11:04, Ivan Voras wrote: > On 04/13/10 22:30, Christoph Weber-Fahr wrote: >> Hello, >> >> on a new HP Proliant DL385 G6 I have a P410 with BBWC and >> 8 hard drives in RAID5. >> (BBWC is Battery Backed Write Cache Enabler, and the controller >> is configured with 300M (75%) write cache). >> >> One of the applications we want to run is PostgreSQL (not the top >> priority, else we would use a different RAID scenario). >> >> But before getting the system live, we tested the performance. >> PostgreSQL gets a whole wopping 80 (!) tps out of this >> scenario wit pgbench ( -c 5 -t 5000) > Can you give more details about your hardware? CPU? Memory? File system? > The "100% sys time" point makes it possible it's not the storage itself > that is the issue. CPU is a single AMD Athlon 2427 6-core processor, with 4 Gig RAM. Filesystem is standard bsd ufs/ffs with softupdates on a 3.2 TB RAID5. As for 100%sys time, I didn't claim that. I just note the storage device da0 in the systat -vmstat screen is marked as 100% busy. > You can also collect more information: I'd recommend with either "iostat > -x 1" or "gstat". I'll append some stats. Regards Christoph Weber-Fahr iostat -x 1 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 1.1 16.4 15.4 1030.9 1 5.5 7 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 57.0 0.0 3645.3 1 18.1 100 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 400.5 0.0 24052.3 1 2.6 96 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 196.8 0.0 12593.5 1 5.2 97 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 61.9 0.0 3963.4 1 16.5 98 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 70.9 0.0 4538.8 1 14.5 99 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 61.9 0.0 3963.4 1 16.6 100 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 60.9 0.0 3899.5 1 16.5 97 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 76.9 0.0 4922.3 1 13.9 101 pass0 0.0 0.0 0.0 0.0 0 0.0 0 extended device statistics device r/s w/s kr/s kw/s wait svc_t %b da0 0.0 62.9 0.0 4027.3 1 16.4 100 pass0 0.0 0.0 0.0 0.0 0 0.0 0 gstat dT: 1.001s w: 1.000s L(q) ops/s r/s kBps ms/r w/s kBps ms/w %busy Name 0 0 0 0 0.0 0 0 0.0 0.0| acd0 1 68 0 0 0.0 68 4347 14.8 99.4| da0 0 0 0 0 0.0 0 0 0.0 0.0| da0p1 0 0 0 0 0.0 0 0 0.0 0.0| da0p2 0 0 0 0 0.0 0 0 0.0 0.0| da0p3 0 0 0 0 0.0 0 0 0.0 0.0| da0p4 0 0 0 0 0.0 0 0 0.0 0.0| da0p5 1 68 0 0 0.0 68 4347 14.9 99.6| da0p6