From owner-freebsd-performance@FreeBSD.ORG Tue Apr 13 20:57:54 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 2B62B1065675 for ; Tue, 13 Apr 2010 20:57:54 +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 AC62B8FC14 for ; Tue, 13 Apr 2010 20:57:53 +0000 (UTC) Received: from mail-gw.arcor.net (sunmaildns02.arcor.net [62.213.136.74]) by mail.arcor.net (8.13.8/8.13.8) with ESMTP id o3DKUZCG010458; Tue, 13 Apr 2010 22:30:35 +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 o3DKUZVj008008; Tue, 13 Apr 2010 22:30:35 +0200 (MEST) Received: from sky.tnd.arcor.net (sky.tnd.arcor.net [10.128.188.151]) by tkmail.arcor.net (Postfix) with ESMTP id B279B1F9E; Tue, 13 Apr 2010 22:30:35 +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 966DB2F12; Tue, 13 Apr 2010 22:30:35 +0200 (MEST) Message-ID: <4BC4D46B.9040805@arcor.de> Date: Tue, 13 Apr 2010 22:30:35 +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-proliant@freebsd.org, freebsd-performance@freebsd.org X-Enigmail-Version: 1.0.1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: Subject: 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: Tue, 13 Apr 2010 20:57:54 -0000 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) 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 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 . Regards Christoph Wenber-Fahr