Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1895565012B for ; Wed, 3 Sep 2008 12:21:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19222-02 for ; Wed, 3 Sep 2008 12:21:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from typhon.nexustelecom.com (typhon.nexustelecom.com [212.203.104.229]) by postgresql.org (Postfix) with ESMTP id 9015C64FD06 for ; Wed, 3 Sep 2008 12:21:20 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.32,320,1217800800"; d="scan'208,217";a="330217" Received: from unknown (HELO hermes.nexustelecom.com) ([172.29.1.4]) by typhon.nexustelecom.com with ESMTP; 03 Sep 2008 17:21:17 +0200 Received: from hermes.nexustelecom.com (localhost [127.0.0.1]) by hermes.nexustelecom.com (Postfix) with ESMTP id 86AB8159F64 for ; Wed, 3 Sep 2008 17:21:17 +0200 (CEST) Received: from EROS.nexus-ag.com (eros.nexus-ag.com [172.29.2.99]) by hermes.nexustelecom.com (Postfix) with ESMTP id 824FE159F63 for ; Wed, 3 Sep 2008 17:21:17 +0200 (CEST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C90DD8.B5F6E51B" Subject: PostgreSQL and ZFS Date: Wed, 3 Sep 2008 17:21:36 +0200 Message-ID: <46F5921DF52F6E40860287B30CADADC7A67B22@EROS.nexus-ag.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: PostgreSQL and ZFS Thread-Index: AckNxQSh0PSTJfV/TLuFu0+dmqVvBwAE62Gg From: =?iso-8859-1?Q?Thomas_Br=E4utigam?= To: X-TBoneOriginalFrom: =?iso-8859-1?Q?Thomas_Br=E4utigam?= X-TBoneOriginalTo: X-TBoneDomainSigned: false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200809/9 X-Sequence-Number: 30102 This is a multi-part message in MIME format. ------_=_NextPart_001_01C90DD8.B5F6E51B Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello all, =20 I am working with a PostgreSQL Database and I want to change the = Filesystem to ZFS. =20 Does someone have experience with PostgreSQL and its Performance with = ZFS? Are the current write options for PostgreSQL suitable for ZFS? =20 Do I need to finetune Postgres with the settings for ZFS? Like finetuning of... - fsync - wal_sync_method =20 Thanks if someone can help me on this. =20 Cheers Thomas ------_=_NextPart_001_01C90DD8.B5F6E51B Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello =20 all,
 
I am=20 working with a PostgreSQL Database and I want to change the Filesystem = to=20 ZFS.
 
Does someone have experience with = PostgreSQL and its=20 Performance with ZFS? Are the current = write=20 options for PostgreSQL suitable for=20 ZFS?
 
Do I=20 need to finetune Postgres with the settings for ZFS?
Like=20 finetuning of...
- fsync
-=20 wal_sync_method
 
Thanks=20 if someone can help me on this.
 
Cheers=20 Thomas
------_=_NextPart_001_01C90DD8.B5F6E51B--