Re: Postgresql 9.4 and ZFS?

From: Jov <zhao6014(at)gmail(dot)com>
To: Benjamin Smith <ben(at)chico(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgresql 9.4 and ZFS?
Date: 2015-09-30 03:14:57
Message-ID: CADyrUxObE6_pKF46u=NVoomvmnbfCzvja9WNp=JkBe9589-SUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I use pg with zfs on freebsd,it work great.I test zol 1 years ago,it will
crash the os on load.

Some note for pg on freebsd from my experience:
1.if you use compression,8k recordsize make the compression ratio poor.I
reach 7.x with gzip using default record size(128k if I remember) while get
2.x with 8k record size.

2.use slog to reduce fragment,and improve the sync write performance.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2015-09-30 12:01:51 Re: Postgresql 9.4 and ZFS?
Previous Message Patric Bechtel 2015-09-29 22:21:12 Re: Postgresql 9.4 and ZFS?