From owner-freebsd-fs@FreeBSD.ORG Thu Jan 10 01:37:10 2013 Return-Path: Delivered-To: freebsd-fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 44482D2 for ; Thu, 10 Jan 2013 01:37:10 +0000 (UTC) (envelope-from artemb@gmail.com) Received: from mail-vc0-f174.google.com (mail-vc0-f174.google.com [209.85.220.174]) by mx1.freebsd.org (Postfix) with ESMTP id 023F6CE9 for ; Thu, 10 Jan 2013 01:37:09 +0000 (UTC) Received: by mail-vc0-f174.google.com with SMTP id d16so27829vcd.5 for ; Wed, 09 Jan 2013 17:37:09 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; bh=TqoV+GK8uBvrWacvhOMR9xqTSDvlcZyHwBehRWIuzH4=; b=YAxXPg2s6+7zPXTUY4Mhs2U7uBCtXe1ww3SmrD7SdKerykk3b0/ew4psUcNYrcf337 muJ1jBdlOEWRRwYWitDhjUtdTSrRRau3MRp9XF0HCSq/0RDsSIWjHp5OzPY8+wQaCjhw HAsdLwScQRg/qEPB/XM1u03naqxKXisNK8QJBaahDdB/ndqx3+VGgrQJOq5srW4ZYEvP Jlq9rYQSR01aJ+xDpZw3SXM2ZB9Yy3u8o7srZPhqgckB2g6Cr8rU5dnGVshq1x55Cs8K EjoKn0lL2mvZ+xZl6aiHzwVigSK23tXuonljF5k8s/wPphvFD78sE59VecUyMBwDkQlE vZrg== MIME-Version: 1.0 Received: by 10.52.74.38 with SMTP id q6mr15982156vdv.17.1357781829108; Wed, 09 Jan 2013 17:37:09 -0800 (PST) Sender: artemb@gmail.com Received: by 10.220.122.196 with HTTP; Wed, 9 Jan 2013 17:37:09 -0800 (PST) In-Reply-To: <1357741879.56011.YahooMailClassic@web190806.mail.sg3.yahoo.com> References: <1357741879.56011.YahooMailClassic@web190806.mail.sg3.yahoo.com> Date: Wed, 9 Jan 2013 17:37:09 -0800 X-Google-Sender-Auth: XV-GsbMYsralrKu-S6O2T86_TJY Message-ID: Subject: Re: ZFS sub-optimal performance with default setting From: Artem Belevich To: Patrick Dung Content-Type: text/plain; charset=ISO-8859-1 Cc: freebsd-fs X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 10 Jan 2013 01:37:10 -0000 On Wed, Jan 9, 2013 at 6:31 AM, Patrick Dung wrote: > Hi freebsd-fs! > > I have my the original question in: > http://archives.postgresql.org/pgsql-performance/2013-01/msg00044.php > But later it was found out the bottleneck seems to be the ZFS with out a fast ZIL. > Please give some advise, thanks. For database storage on ZFS it may be necessary to change ZFS record size to match database page size. At least that's what one of the things Oracle recommends for oracle database: http://www.oracle.com/technetwork/server-storage/solaris10/config-solaris-zfs-wp-167894.pdf You may also check if disabling prefetching (via vfs.zfs.prefetch_disable=1 tunable in loader.conf) helps your workload. --Artem