Date: Wed, 23 Oct 2013 22:57:57 +0200 From: Michael Schmiedgen <schmiedgen@gmx.net> To: Mark Felder <feld@FreeBSD.org>, Albert Shih <Albert.Shih@obspm.fr>, pgsql-admin@postgresql.org, freebsd-fs@freebsd.org, freebsd-jail@freebsd.org Subject: Re: ZFS-FreeBSD + postgresql performance Message-ID: <52683855.6060609@gmx.net> In-Reply-To: <1382548465.32073.37624113.6AA8DB42@webmail.messagingengine.com> References: <20131023162545.GA19794@pcjas.obspm.fr> <1382548465.32073.37624113.6AA8DB42@webmail.messagingengine.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 10/23/13 19:14, Mark Felder wrote: > On Wed, Oct 23, 2013, at 11:25, Albert Shih wrote: >> My question is about the performance, I known ZFS eat all memory he can >> have (or almost), so what append when we run database like postgresql and >> jail ? (it's also the reason of 96 Go ram). >> >> Sorry for cross-posting but it's about 3 differents things.... >> > > To my understanding the solution is to change the primarycache to > "metadata" for any ZFS filesystem that you do not want ZFS to heavily > cache in memory. > > Example: > > # zfs set primarycache=metadata tank/usr/local/pgsql In addition to this it is recommended to set the recordsize to the fixed value of 8k on dataset creation. Michael
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?52683855.6060609>