From: Larry Rosenman <ler@lerctr.org>
To: 'Thomas Bräutigam' <thomas.braeutigam@nexustelecom.com>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL and ZFS
Date: Wed, 3 Sep 2008 15:17:07 -0500
Message-ID: <019501c90e02$10007a40$30016ec0$@org> (raw)
In-Reply-To: <46F5921DF52F6E40860287B30CADADC7A67B22@EROS.nexus-ag.com>
References: <46F5921DF52F6E40860287B30CADADC7A67B22@EROS.nexus-ag.com>
I'm running on ZFS on a lightly loaded FreeBSD 7 box, and it's fine.
I did give ZFS the hint with recordsize=8K on the data directory/fs, but
nothing else.
(other than the usual caveats with ZFS on FreeBSD (I'm on amd64)).
LER
--
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
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Thomas Bräutigam
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
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: ler@lerctr.org, thomas.braeutigam@nexustelecom.com
Subject: Re: PostgreSQL and ZFS
In-Reply-To: <019501c90e02$10007a40$30016ec0$@org>
* 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