Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5605964FD1E for ; Wed, 3 Sep 2008 17:17:25 -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 91622-07 for ; Wed, 3 Sep 2008 17:17:22 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from thebighonker.lerctr.org (thebighonker.lerctr.org [192.147.25.65]) by postgresql.org (Postfix) with ESMTP id E24CC64FCF3 for ; Wed, 3 Sep 2008 17:17:21 -0300 (ADT) Received: from 64.3.1.253.ptr.us.xo.net ([64.3.1.253]:49286 helo=LROSENMAN) by thebighonker.lerctr.org with esmtpa (Exim 4.69 (FreeBSD)) (envelope-from ) id 1Kaymz-0008eD-Pb; Wed, 03 Sep 2008 15:17:19 -0500 From: "Larry Rosenman" To: =?iso-8859-1?Q?'Thomas_Br=E4utigam'?= , References: <46F5921DF52F6E40860287B30CADADC7A67B22@EROS.nexus-ag.com> In-Reply-To: <46F5921DF52F6E40860287B30CADADC7A67B22@EROS.nexus-ag.com> Subject: Re: PostgreSQL and ZFS Date: Wed, 3 Sep 2008 15:17:07 -0500 Message-ID: <019501c90e02$10007a40$30016ec0$@org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0196_01C90DD8.272A7240" X-Mailer: Microsoft Office Outlook 12.0 thread-index: AckNxQSh0PSTJfV/TLuFu0+dmqVvBwAE62GgAApNS8A= Content-Language: en-us X-LERCTR-Spam-Score: -2.3 (--) X-LERCTR-Spam-Report: SpamScore (-2.3/5.0) ALL_TRUSTED=-1.8, BAYES_00=-2.599, HTML_MESSAGE=0.001, SARE_SUB_OBFU_OTHER=0.135, TVD_RCVD_IP=1.931, TW_PG=0.077 DomainKey-Status: no signature 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/14 X-Sequence-Number: 30107 This is a multipart message in MIME format. ------=_NextPart_000_0196_01C90DD8.272A7240 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm running on ZFS on a lightly loaded FreeBSD 7 box, and it's fine. =20 I did give ZFS the hint with recordsize=3D8K on the data directory/fs, = but nothing else.=20 =20 (other than the usual caveats with ZFS on FreeBSD (I'm on amd64)). =20 LER =20 --=20 Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 =20 From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Thomas = Br=E4utigam Sent: Wednesday, September 03, 2008 10:22 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] PostgreSQL and ZFS =20 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_000_0196_01C90DD8.272A7240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I'm running on ZFS on a lightly loaded FreeBSD 7 box, and = it's fine.

I did give ZFS the hint with recordsize=3D8K on the data directory/fs, but nothing else.

(other than the usual caveats with ZFS on FreeBSD (I'm on amd64)).

LER

--

Larry Rosenman=A0=A0=A0=A0=A0 = =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0http://www.lerctr.org/~ler

Phone: +1 = 512-248-2683=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 E-Mail: = ler@lerctr.org

US Mail: 430 Valona Loop, Round Rock, TX = 78681-3893

From:= = pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Thomas = Br=E4utigam
Sent: Wednesday, September 03, 2008 10:22 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] PostgreSQL and ZFS

Hello all,

I am working with a PostgreSQL Database and I want to change = the Filesystem to ZFS.

Does someone have experience with PostgreSQL and its = Performance with ZFS? Are the current write options for PostgreSQL suitable for = ZFS?

Do I need to finetune Postgres with the settings for = ZFS?

Like finetuning of...

- fsync
- wal_sync_method

Thanks if someone can help me on this.

Cheers Thomas

------=_NextPart_000_0196_01C90DD8.272A7240--