Re: ZFS-FreeBSD + postgresql performance

Поиск
Список
Период
Сортировка
От Patrick Dung
Тема Re: ZFS-FreeBSD + postgresql performance
Дата
Msg-id 1382765063.35320.YahooMailNeo@web193504.mail.sg3.yahoo.com
обсуждение исходный текст
Ответ на Re: ZFS-FreeBSD + postgresql performance  (Patrick Dung <patrick_dkt@yahoo.com.hk>)
Список pgsql-admin

On , Patrick Dung <patrick_dkt@yahoo.com.hk> wrote:

On Saturday, October 26, 2013 1:04 AM, Steven Hartland <killing@multiplay.co.uk> wrote:
----- Original Message -----
From: "Patrick Dung" <patrick_dkt@yahoo.com.hk>
Sent: Friday, October 25, 2013 4:53 PM
Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance


>> I would also recommend to use 4K sector size using
>
> gnop and zpool export/import.

This will have no effect, the ashift for a pool is set at creation.

    Regards
    Steve


---------------------

To be specific, I think the steps should be gnop create, create zfs pool, export zfs, remove gnop and reimport zfs.
This link have the deatils and steps:
The link is:

http://ivoras.sharanet.org/blog/tree/2011-01-01.freebsd-on-4k-sector-drives.html

В списке pgsql-admin по дате отправления:

Предыдущее
От: Patrick Dung
Дата:
Сообщение: Re: ZFS-FreeBSD + postgresql performance
Следующее
От: "Ginepro, Raymond C"
Дата:
Сообщение: Re: wrong size archive file