Date: Wed, 9 Jan 2013 17:37:09 -0800 From: Artem Belevich <art@freebsd.org> To: Patrick Dung <patrick_dkt@yahoo.com.hk> Cc: freebsd-fs <freebsd-fs@freebsd.org> Subject: Re: ZFS sub-optimal performance with default setting Message-ID: <CAFqOu6gE2C1FoqZWVKKcw9=sKYagrwT5LpVo-jipbxTyLmjFVA@mail.gmail.com> In-Reply-To: <1357741879.56011.YahooMailClassic@web190806.mail.sg3.yahoo.com> References: <1357741879.56011.YahooMailClassic@web190806.mail.sg3.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Jan 9, 2013 at 6:31 AM, Patrick Dung <patrick_dkt@yahoo.com.hk> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAFqOu6gE2C1FoqZWVKKcw9=sKYagrwT5LpVo-jipbxTyLmjFVA>