Date: Thu, 24 Oct 2013 10:20:13 +0200 From: "Ronald Klop" <ronald-freebsd8@klop.yi.org> To: freebsd-fs@freebsd.org Subject: Re: ZFS-FreeBSD + postgresql performance Message-ID: <op.w5f9f0q28527sy@212-182-167-131.ip.telfort.nl> In-Reply-To: <20131023162545.GA19794@pcjas.obspm.fr> References: <20131023162545.GA19794@pcjas.obspm.fr>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 23 Oct 2013 18:25:45 +0200, Albert Shih <Albert.Shih@obspm.fr> wrote: > Hi > > I would like to known if someone here have in production a FreeBSD server > with postgresql and the FS for the data of postgresql is a ZFS pool. > > I'm going to buy some server with 96Go of Ram and a jbod of 12 disks (4To > each) > > The purpose is to have everything on this zfs pool (except the system who > still on classic raid). So to have > > many jail (~20-30) running apache/mysql/etc. > one postgresql server with all data on the zfs. > > each jail use his own zfs partition. So I can use zfs send/received to > have > a mirror of everything in a other server. > > 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.... > > Regards. > > JAS Databases do a lot of sync writes, so it might be good to use a fast ZIL device (SSD). Ronald.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?op.w5f9f0q28527sy>