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: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bräutigam Sent: Wednesday, September 03, 2008 10:22 AM To: [email protected] 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
