Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0434264FF8A for ; Wed, 3 Sep 2008 10:10:57 -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 52286-08 for ; Wed, 3 Sep 2008 10:10:53 -0300 (ADT) X-Greylist: delayed 00:10:04.298103 by SQLgrey-1.7.6 Received: from typhon.nexustelecom.com (typhon.nexustelecom.com [212.203.104.229]) by postgresql.org (Postfix) with ESMTP id 1783864FF57 for ; Wed, 3 Sep 2008 10:10:52 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.32,320,1217800800"; d="scan'208,217";a="329806" Received: from unknown (HELO hermes.nexustelecom.com) ([172.29.1.4]) by typhon.nexustelecom.com with ESMTP; 03 Sep 2008 15:00:45 +0200 Received: from hermes.nexustelecom.com (localhost [127.0.0.1]) by hermes.nexustelecom.com (Postfix) with ESMTP id 9B8D5159F64 for ; Wed, 3 Sep 2008 15:00:45 +0200 (CEST) Received: from EROS.nexus-ag.com (eros.nexus-ag.com [172.29.2.99]) by hermes.nexustelecom.com (Postfix) with ESMTP id 4099B159F63 for ; Wed, 3 Sep 2008 15:00:33 +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_01C90DC5.0CC17DEA" Subject: PostgreSQL and ZFS Date: Wed, 3 Sep 2008 15:00:19 +0200 Message-ID: <46F5921DF52F6E40860287B30CADADC7A67ACE@EROS.nexus-ag.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: PostgreSQL and ZFS Thread-Index: AckNxQSh0PSTJfV/TLuFu0+dmqVvBw== 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/6 X-Sequence-Number: 30099 This is a multi-part message in MIME format. ------_=_NextPart_001_01C90DC5.0CC17DEA Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, =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_01C90DC5.0CC17DEA Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
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 = Performance=20 with ZFS? Are the current write options = for=20 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_01C90DC5.0CC17DEA--