Re: Postgresql 9.4 and ZFS?

On Tue, Sep 29, 2015 at 01:08:20PM -0700, Benjamin Smith wrote:
> 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
>
>
>
>
No, that would be:

zfs create -o blocksize=8192 <pool>/path/to/pgdata

this is for the DATASET, not the POOL
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 E-Mail: ler(at)lerctr(dot)org
US Mail: 7011 W Parmer Ln, Apt 1115, Austin, TX 78729-6961