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@postgresql.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@lerctr.org
US Mail: 7011 W Parmer Ln, Apt 1115, Austin, TX 78729-6961