Re: ZFS-FreeBSD + postgresql performance

2013-10-24 Thread Ivailo . TANUSHEFF
owner-freebsd...@freebsd.org wrote on 23.10.2013 23:57:57: > From: > > Michael Schmiedgen > > To: > > Mark Felder , Albert Shih , > pgsql-ad...@postgresql.org, freebsd...@freebsd.org, freebsd-jail@freebsd.org, > > Date: > > 23.10.2013 23:58 > >

Re: ZFS-FreeBSD + postgresql performance

2013-10-23 Thread Michael Schmiedgen
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-

Re: ZFS-FreeBSD + postgresql performance

2013-10-23 Thread Mark Felder
On Wed, Oct 23, 2013, at 11:25, Albert Shih 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) > >