Re: ZFS-FreeBSD + postgresql performance

Поиск
Список
Период
Сортировка
От Steven Hartland
Тема Re: ZFS-FreeBSD + postgresql performance
Дата
Msg-id 5E70894E80E24CF5AF894DAF80DCF04E@multiplay.co.uk
обсуждение исходный текст
Ответ на ZFS-FreeBSD + postgresql performance  (Albert Shih <Albert.Shih@obspm.fr>)
Список pgsql-admin
----- Original Message -----
From: <Ivailo.TANUSHEFF@raiffeisen.bg>
>> ----- 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
>>
>
> That's the idea: to set the ashift during the creation of the pool. Never
> did that before?
>
> gnop create -S 4096 /dev/gpt/disk0
> gnop create -S 4096 /dev/gpt/disk1
> zpool create mirror /dev/gpt/disk0.nop /dev/gpt/disk1.nop
> zpool export zroot
> gnop destroy /dev/gpt/disk0.nop
> gnop destroy /dev/gpt/disk1.nop
> zpool import zroot

First if your on 10 or 11 you don't need this unless you have a disk
which is 4k but is reporting 512b and isnt in our list of quirks.

If you still need to do this you only need to do gnop create / destroy
onone disk per top level vdev so in your example thats only one disk.

    Regards
    Steve

================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed.
Inthe event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or
anyinformation contained in it.  

In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337
or return the E.mail to postmaster@multiplay.co.uk.



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

Предыдущее
От: Ivailo.TANUSHEFF@raiffeisen.bg
Дата:
Сообщение: Re: ZFS-FreeBSD + postgresql performance
Следующее
От: mark_postgres_user
Дата:
Сообщение: displaying UTC time in local time