Re: PostgreSQL and ZFS - Mailing list pgsql-admin

From Larry Rosenman
Subject Re: PostgreSQL and ZFS
Date
Msg-id 019501c90e02$10007a40$30016ec0$@org
Whole thread Raw
In response to PostgreSQL and ZFS  (Thomas Bräutigam <thomas.braeutigam@nexustelecom.com>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: Jan-Peter Seifert
Date:
Subject: Re: SSL problems
Next
From: valgog
Date:
Subject: Re: Database encoding