From: Albert Shih <Albert.Shih@obspm.fr>
To: pgsql-admin@postgresql.org
To: freebsd-fs@freebsd.org
To: freebsd-jail@freebsd.org
Subject: ZFS-FreeBSD + postgresql performance
Date: Wed, 23 Oct 2013 18:25:45 +0200
Message-ID: <20131023162545.GA19794@pcjas.obspm.fr> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
--
Albert SHIH
DIO bâtiment 15
Observatoire de Paris
5 Place Jules Janssen
92195 Meudon Cedex
France
Téléphone : +33 1 45 07 76 26/+33 6 86 69 95 71
xmpp: jas@obspm.fr
Heure local/Local time:
mer 23 oct 2013 18:17:24 CEST
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Albert.Shih@obspm.fr, freebsd-fs@freebsd.org, freebsd-jail@freebsd.org
Subject: Re: ZFS-FreeBSD + postgresql performance
In-Reply-To: <20131023162545.GA19794@pcjas.obspm.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox