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

From Benjamin Smith
Subject Re: Postgresql 9.4 and ZFS?
Date
Msg-id 1553214.07h7IOlabg@tesla.schoolpathways.com
Whole thread Raw
In response to Re: Postgresql 9.4 and ZFS?  (John R Pierce <pierce@hogranch.com>)
Responses Re: Postgresql 9.4 and ZFS?
Re: Postgresql 9.4 and ZFS?
Re: Postgresql 9.4 and ZFS?
List pgsql-general
On Tuesday, September 29, 2015 10:35:28 AM John R Pierce wrote:
> 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.

Based on my reading here, that would be -o ashift=13 ?
HowDoesZFSonLinuxHandleAdvacedFormatDrives

EG: 2^13 = 8192




pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: Re: Format
Next
From: Larry Rosenman
Date:
Subject: Re: Postgresql 9.4 and ZFS?