Re: PostgreSQL and ZFS

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(at)lerctr(dot)org

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

From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Thomas Bräutigam
Sent: Wednesday, September 03, 2008 10:22 AM
To: pgsql-admin(at)postgresql(dot)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