From owner-freebsd-performance@FreeBSD.ORG Wed May 6 09:50:03 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 35FEF1065673 for ; Wed, 6 May 2009 09:50:03 +0000 (UTC) (envelope-from ap00@mail.ru) Received: from mx0.awanti.com (mx0.awanti.com [91.190.112.18]) by mx1.freebsd.org (Postfix) with ESMTP id E22D68FC19 for ; Wed, 6 May 2009 09:50:02 +0000 (UTC) (envelope-from ap00@mail.ru) Received: from pstation (unknown [10.28.4.14]) by mx0.awanti.com (Postfix) with ESMTP id 5B0524C0B1; Wed, 6 May 2009 13:24:58 +0400 (MSD) Date: Wed, 6 May 2009 13:25:50 +0400 From: Anthony Pankov X-Mailer: The Bat! (v1.51) Personal X-Priority: 3 (Normal) Message-ID: <5871156390.20090506132550@mail.ru> To: Mark Wong In-Reply-To: <70c01d1d0905042230v3357622cgf4c8e52a2a4ead96@mail.gmail.com> References: <70c01d1d0905042230v3357622cgf4c8e52a2a4ead96@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Cc: freebsd-performance@freebsd.org Subject: Re: filesystem performance X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Anthony Pankov List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 06 May 2009 09:50:04 -0000 Hello Mark, May i ask a question while more expierenced people is waking up? I don't fully understand the target. For what filesystem should be optimized? I expect a patterns of recorded IO calls when pgsql perform typical operations with statistics and in-depth analysis. Are you sure there is à strong relation between fio benchmark result and PostgreSQL performance? Tuesday, May 05, 2009, 9:30:47 AM, you wrote: MW> Hi everyone, MW> We (PostgreSQL community) have a HP DL380 G5 that we were using to do MW> some very basic filesystem characterizations as part of a database MW> performance tuning project, so we wanted to give FreeBSD a try out of MW> the box. For this set of data we used 7.1. We're (us few that are MW> running the tests) are fairly unfamiliar with the community here, so MW> I'll be as brief as I can. We're basically wondering if the data MW> we're getting out of the box is expected, and any tuning guidelines MW> including what changes we should expect to see in the performance. -- Best regards, Anthony mailto:ap00@mail.ru