Re: Postgresql 9.4 and ZFS?

Поиск
Список
Период
Сортировка
От Benjamin Smith
Тема Re: Postgresql 9.4 and ZFS?
Дата
Msg-id 1553214.07h7IOlabg@tesla.schoolpathways.com
обсуждение исходный текст
Ответ на Re: Postgresql 9.4 and ZFS?  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Postgresql 9.4 and ZFS?
Re: Postgresql 9.4 and ZFS?
Re: Postgresql 9.4 and ZFS?
Список 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 по дате отправления:

Предыдущее
От: Ramesh T
Дата:
Сообщение: Re: Format
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: Postgresql 9.4 and ZFS?