From owner-freebsd-performance@FreeBSD.ORG Tue May 5 05:57:32 2009 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 197C1106566B for ; Tue, 5 May 2009 05:57:32 +0000 (UTC) (envelope-from markwkm@gmail.com) Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31]) by mx1.freebsd.org (Postfix) with ESMTP id CD40E8FC1A for ; Tue, 5 May 2009 05:57:31 +0000 (UTC) (envelope-from markwkm@gmail.com) Received: by yw-out-2324.google.com with SMTP id 9so2678651ywe.13 for ; Mon, 04 May 2009 22:57:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:cc:content-type:content-transfer-encoding; bh=byt733mtlmMjDy0Q/2V4Tv46FOWqQOq4vcld/2zrBvg=; b=PC+fF65as9qZD9MnKKlRvkHcxFjrk970TcAVhRTtteErIBDNa9Y8jasV2k9fSl6mv+ VhDcazb650flxs4p996EZwNUFiUmmoleEXAq1k9qe70gx5NeSuaTea3bjYGsiWtSqYMc ZFOPonGglU3PJAiBHRATsiksAhC4yvX/sOMSk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; b=INPYJjplcjO8wNYU9sgrP7GTgZLcQRwDz3Yva6XAmwm7KLzvZHGfkqmRdi+S7u5WYx TNYnsjVMMC06gG7NZFDhz18fnh1sHa9wDY/aqFP5U3bKXyMfiwx5FFYO6V7D4HtQsol/ NQ6GBmaJDOgNCiH+eR344r3VnK+ca0LJ9vS9I= MIME-Version: 1.0 Received: by 10.100.240.9 with SMTP id n9mr14903358anh.135.1241501447799; Mon, 04 May 2009 22:30:47 -0700 (PDT) Date: Mon, 4 May 2009 22:30:47 -0700 Message-ID: <70c01d1d0905042230v3357622cgf4c8e52a2a4ead96@mail.gmail.com> From: Mark Wong To: freebsd-performance@freebsd.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Cc: Selena Deckelmann , Gabrielle Roth Subject: filesystem performance 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, 05 May 2009 05:57:32 -0000 Hi everyone, We (PostgreSQL community) have a HP DL380 G5 that we were using to do some very basic filesystem characterizations as part of a database performance tuning project, so we wanted to give FreeBSD a try out of the box. For this set of data we used 7.1. We're (us few that are running the tests) are fairly unfamiliar with the community here, so I'll be as brief as I can. We're basically wondering if the data we're getting out of the box is expected, and any tuning guidelines including what changes we should expect to see in the performance. So that said, I'll start with some of the charted results: Scaling from 1 device to 4 devices using RAID 0: http://207.173.203.223/~markwkm/community10/fio/freebsd-7.1/raid0-ufs.png Comparing RAID configurations of similar capacity: http://207.173.203.223/~markwkm/community10/fio/freebsd-7.1/capacity-ufs.png Comparing RAID configuration using same number of drives (4): http://207.173.203.223/~markwkm/community10/fio/freebsd-7.1/4-disk-ufs.png All of the raw data fio output, iostat, and vmstat including charts of some of the iostat and vmstat data are buried in here: http://207.173.203.223/~markwkm/community10/fio/freebsd-7.1/ We used fio v1.23 to run the tests and picked parameters based on what PostgreSQL is capable of. The profiles used are here: http://git.postgresql.org/gitweb?p=performance-tuning.git;a=tree;f=contrib/freebsd/fio;h=5ae97420fba010a3685c12c24cd69266d83b4daf;hb=HEAD Hardware details are here (note we only used 4 of the internal drives for this test, none in the MSA 70, and you may notice we have a lit of Linux data on this page too): http://wiki.postgresql.org/wiki/HP_ProLiant_DL380_G5_Tuning_Guide#Hardware_Details I know I've been brief and at the same time dumped a lot of raw data. Any pointers to tuning guides that we have obviously not seen would be a appreciated. We hope this data is of interest and is helpful. Regards, Mark