From owner-freebsd-performance@FreeBSD.ORG Wed Apr 14 09:04:40 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 22D72106566B for ; Wed, 14 Apr 2010 09:04:40 +0000 (UTC) (envelope-from gofp-freebsd-performance@m.gmane.org) Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mx1.freebsd.org (Postfix) with ESMTP id CE5848FC0A for ; Wed, 14 Apr 2010 09:04:39 +0000 (UTC) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1O1yWU-00070G-Fl for freebsd-performance@freebsd.org; Wed, 14 Apr 2010 11:04:38 +0200 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 14 Apr 2010 11:04:38 +0200 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 14 Apr 2010 11:04:38 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-performance@freebsd.org From: Ivan Voras Date: Wed, 14 Apr 2010 11:04:41 +0200 Lines: 39 Message-ID: References: <4BC4D46B.9040805@arcor.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.9.1.8) Gecko/20100329 Thunderbird/3.0.3 In-Reply-To: <4BC4D46B.9040805@arcor.de> X-Enigmail-Version: 1.0.1 Subject: Re: is trhere 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 09:04:40 -0000 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) Hmm yes, this is too slow. > Now I had not expected top performance, but something to the tune > of 500 tps should be well possible. And it's definitely a storage Yes, your expectations are correct. > or filke system issue, since CPU is bored to death during the > benchmark, while the file system is at 100% according to systat. > On a comparable Hardware our test machine runs as a VM under VMWare > and gets ~600 tps. > > Is there a known problem with this setup? > > OS is FreeBSD-amd64 7.2-p7 . 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. You can also collect more information: I'd recommend with either "iostat -x 1" or "gstat".