Re: Postgresql 9.4 and ZFS?

From: Benjamin Smith <lists(at)benjamindsmith(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql 9.4 and ZFS?
Date: 2015-09-29 20:08:20
Message-ID: 1553214.07h7IOlabg@tesla.schoolpathways.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2015-09-29 20:17:15 Re: Postgresql 9.4 and ZFS?
Previous Message Ramesh T 2015-09-29 17:55:31 Re: Format