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 13:00:19
Message-ID: 46F5921DF52F6E40860287B30CADADC7A67ACE@EROS.nexus-ag.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

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 Anibal David Acosta 2008-09-03 13:40:36 Database encoding
Previous Message Andriy Bakay 2008-09-03 12:43:29 SSL problems