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@xxxxxxxxxxxxxx) > 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@xxxxxxxxxx US Mail: 7011 W Parmer Ln, Apt 1115, Austin, TX 78729-6961 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
