[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