Re: ZFS-FreeBSD + postgresql performance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Steven Hartland" <killing@xxxxxxxxxxxxxxx> wrote on 25.10.2013 19:19:54:

> From:

>
> "Steven Hartland" <killing@xxxxxxxxxxxxxxx>

>
> To:

>
> "Patrick Dung" <patrick_dkt@xxxxxxxxxxxx>,
> <Ivailo.TANUSHEFF@xxxxxxxxxxxxx>, "Michael Schmiedgen" <schmiedgen@xxxxxxx>,

>
> Cc:

>
> <owner-freebsd-fs@xxxxxxxxxxx>, <freebsd-fs@xxxxxxxxxxx>, <pgsql-
> admin@xxxxxxxxxxxxxx>, <freebsd-jail@xxxxxxxxxxx>

>
> Date:

>
> 25.10.2013 19:20

>
> Subject:

>
> Re: [ADMIN] ZFS-FreeBSD + postgresql performance

>
> ----- Original Message -----
> From: "Patrick Dung" <patrick_dkt@xxxxxxxxxxxx>
> 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 -S4096/dev/gpt/disk0
gnop create
-S4096/dev/gpt/disk1
zpool create mirror
/dev/gpt/disk0.nop /dev/gpt/disk1.nop
zpool
exportzroot
gnop destroy
/dev/gpt/disk0.nop
gnop destroy
/dev/gpt/disk1.nop
zpool import zroot


Best regards,
Ivailo Tanusheff


DISCLAIMER: The contents of this e-mail are intended for the named addressee only. It contains information that may be privileged and/or confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. Messages transported over the public Internet are susceptible to alteration. Raiffeisenbank (Bulgaria) EAD, Raiffeisen Asset Management (Bulgaria) EAD, Raiffeisen Insurance Broker EOOD, Raiffeisen Services EAD, Raiffeisen Leasing Bulgaria OOD, Raiffeisen Auto Leasing Bulgaria EOOD and Raiffeisen Real Estate EOOD shall not be liable for the message if altered, changed or falsified.

пзтбойюеойе об пфзпчптопуффб: уЯДЯТЦБОЙЕФП ОБ ФПЧБ ЕМЕЛФТПООП УЯПВЭЕОЙЕ Е РТЕДОБЪОБЮЕОП ЕДЙОУФЧЕОП ЪБ РПУПЮЕОЙС РПМХЮБФЕМ. уЯПВЭЕОЙЕФП УЯДЯТЦБ ЙОЖПТНБГЙС, ЛПСФП НПЦЕ ДБ ВЯДЕ РТЕДОБЪОБЮЕОБ ЪБ ПЗТБОЙЮЕОП РПМЪЧБОЕ Й/ЙМЙ РПЧЕТЙФЕМОБ. ч УМХЮБК ЮЕ ОЕ УФЕ ХЛБЪБОЙС РПМХЮБФЕМ ОБ ФПЧБ УЯПВЭЕОЙЕ ЙМЙ ОЕЗПЧ ПФПТЙЪЙТБО РТЕДУФБЧЙФЕМ, ОСНБФЕ РТБЧП ДБ ЗП ЛПРЙТБФЕ ЙМЙ ЙЪРПМЪЧБФЕ, ЛБЛФП Й ДБ ТБЪЛТЙЧБФЕ УЯДЯТЦБОЙЕФП НХ РТЕД ФТЕФЙ МЙГБ. бЛП УФЕ ЗП РПМХЮЙМЙ РП ЗТЕЫЛБ, НПМС ДБ ХЧЕДПНЙФЕ РПДБФЕМС ОЕЪБВБЧОП Й ДБ ЙЪФТЙЕФЕ ФПЧБ УЯПВЭЕОЙЕ ПФ УЙУФЕНБФБ. еМЕЛФТПООЙФЕ УЯПВЭЕОЙС, ТБЪРТПУФТБОСЧБОЙ РП йОФЕТОЕФ НПЗБФ ДБ ВЯДБФ РТПНЕОСОЙ. тБКЖБКЪЕОВБОЛ (вЯМЗБТЙС) ебд, тБКЖБКЪЕО бУЕФ нЕОЙДЦНЯОФ (вЯМЗБТЙС) ебд, тБКЖБКЪЕО ъБУФТБИПЧБФЕМЕО вТПЛЕТ еппд, тБКЖБКЪЕО уЯТЧЙУЙЪ ебд, тБКЖБКЪЕО мЙЪЙОЗ вЯМЗБТЙС ппд, тБКЖБКЪЕО бХФП мЙЪЙОЗ вЯМЗБТЙС еппд Й тБКЖБКЪЕО йНПФЙ еппд ОЕ ОПУСФ ПФЗПЧПТОПУФ ЪБ НПДЙЖЙГЙТБОЙ, РТПНЕОЕОЙ ЙМЙ ЖБМЫЙЖЙГЙТБОЙ УЯПВЭЕОЙС.


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux