PostgreSQL and ZFS

From: Thomas Bräutigam <thomas(dot)braeutigam(at)nexustelecom(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PostgreSQL and ZFS
Date: 2008-09-03 15:21:36
Message-ID: 46F5921DF52F6E40860287B30CADADC7A67B22@EROS.nexus-ag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message slamp slamp 2008-09-03 15:24:07 rpm install not recognized by yum.
Previous Message Anibal David Acosta 2008-09-03 13:40:36 Database encoding