From owner-freebsd-performance@FreeBSD.ORG Wed May 6 15:01:29 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 9E17110656A8 for ; Wed, 6 May 2009 15:01:29 +0000 (UTC) (envelope-from markwkm@gmail.com) Received: from mail-gx0-f163.google.com (mail-gx0-f163.google.com [209.85.217.163]) by mx1.freebsd.org (Postfix) with ESMTP id 21B678FC1A for ; Wed, 6 May 2009 15:01:24 +0000 (UTC) (envelope-from markwkm@gmail.com) Received: by gxk7 with SMTP id 7so225944gxk.19 for ; Wed, 06 May 2009 08:01:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=O+8yggfGc80T64v+rH5B1z8Mz1wA4UhbUXteStUByfk=; b=iVCtZNnBCzDNm8iINWfxLFjprgjWNsGTGTnw1GM6Sm2H+2e4egRFNpn6qoI1oLSR87 aCb0sJnZ/cVSYcJHDS4kRCMLyQv9dKyB5i1D7eXwL0GCNxgkc4jVYX7xnwQmYMWY9otP N1BKjHpRAplXOFGRY+frkXHPz7+rbDJY5iK8k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=nXdwucvX0FfMI7juFhUtXPq73Ftfsj/QcR2u0CHICZWq3UjZs5Q4a5xx6BUktj2fAG A/OgxZ8L6a91UyqgipMZxeg/8fawKqeYjmriCD8RiLW88D6ydsF4kaqStgZoAe1/RGY1 vAi5o/fvqr3vf8kt6OZY1VielerLHN5ePhavc= MIME-Version: 1.0 Received: by 10.100.251.8 with SMTP id y8mr3043368anh.74.1241622073334; Wed, 06 May 2009 08:01:13 -0700 (PDT) In-Reply-To: <5871156390.20090506132550@mail.ru> References: <70c01d1d0905042230v3357622cgf4c8e52a2a4ead96@mail.gmail.com> <5871156390.20090506132550@mail.ru> Date: Wed, 6 May 2009 08:01:13 -0700 Message-ID: <70c01d1d0905060801r1eb7b9f7o5c1c9505130a7667@mail.gmail.com> From: Mark Wong To: Anthony Pankov Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable Cc: freebsd-performance@freebsd.org, Selena Deckelmann , Gabrielle Roth Subject: Re: 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: Wed, 06 May 2009 15:01:30 -0000 On Wed, May 6, 2009 at 2:25 AM, Anthony Pankov wrote: > 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. The angle we're trying to look at is from a sizing perspective. In order words we want to have an idea of what to expect before we do it. For example, if I have 10 drives, what can I expect if I configure them in a RAID 10 configuration? > Are you sure there is =B1 strong relation between fio benchmark result an= d > PostgreSQL performance? Sorry, this was something I was trying to make clearer originally. No, I don't think there is a strong relationship between fio and PostgreSQL, but these i/o patterns we are simulating do give us a rough estimate of we can expect. For example, in workloads with lots of update and inserts into a database will generate a lot of sequential writes to the database logs, which we can physically isolate onto it's own lun. Similarly, in some warehousing applications there may be a table that is always scanned and read sequential, which also can be on its own physical lun. Regards, Mark