Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql 9.4 and ZFS? - Mailing list pgsql-general

From John R Pierce
Subject Re: Postgresql 9.4 and ZFS?
Date
Msg-id 560ACBE0.4020507@hogranch.com
Whole thread Raw
In response to Postgresql 9.4 and ZFS?  (Benjamin Smith <ben@chico.com>)
Responses Re: Postgresql 9.4 and ZFS?
List pgsql-general
Tree view 
On 9/29/2015 10:01 AM, Benjamin Smith wrote:
> Does anybody here have any recommendations for using PostgreSQL 9.4 (latest)
> with ZFS?

For databases, I've always used mirrored pools, not raidz*.

put pgdata in its own zfs file system in your zpool.  on that dedicated
zfs, set the blocksize to 8k.



--
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: 9.4 and centos/yum multiversion installs
Next
From: Adrian Klaver
Date:
Subject: Re: Format