> From:
>
> Michael Schmiedgen <schmiedgen@xxxxxxx>
>
> To:
>
> Mark Felder <feld@xxxxxxxxxxx>, Albert Shih <Albert.Shih@xxxxxxxx>,
> pgsql-admin@xxxxxxxxxxxxxx, freebsd-fs@xxxxxxxxxxx, freebsd-jail@xxxxxxxxxxx,
>
> Date:
>
> 23.10.2013 23:58
>
> Subject:
>
> Re: ZFS-FreeBSD + postgresql performance
>
> Sent by:
>
> owner-freebsd-fs@xxxxxxxxxxx
>
> On 10/23/13 19:14, Mark Felder wrote:
> > On Wed, Oct 23, 2013, at 11:25, Albert Shih wrote:
> >> My question is about the performance, I known ZFS eat all memory he can
> >> have (or almost), so what append when we run database like postgresql and
> >> jail ? (it's also the reason of 96 Go ram).
> >>
> >> Sorry for cross-posting but it's about 3 differents things....
> >>
> >
> > To my understanding the solution is to change the primarycache to
> > "metadata" for any ZFS filesystem that you do not want ZFS to heavily
> > cache in memory.
> >
> > Example:
> >
> > # zfs set primarycache=metadata tank/usr/local/pgsql
>
> In addition to this it is recommended to set the recordsize
> to the fixed value of 8k on dataset creation.
>
> Michael
>
I would also recommend to use 4K sector size using gnop and zpool export/import.
I agree that using fixed recordsize is a must when you have databases and you have DB on each jail.
Also there are a bunch of sysctl parameters you may want to play with, mostly about tuning the memory usage.
Also it might be an idea to use partitions on disks and:
1. Use first 1-2G on each disk for swap (just in case).
2. Use the rest of the disk for 4K aligned and 4K sector size partition, labelled in some way (I use disk ID as label, for easy identification).
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.
пзтбойюеойе об пфзпчптопуффб: уЯДЯТЦБОЙЕФП ОБ ФПЧБ ЕМЕЛФТПООП УЯПВЭЕОЙЕ Е РТЕДОБЪОБЮЕОП ЕДЙОУФЧЕОП ЪБ РПУПЮЕОЙС РПМХЮБФЕМ. уЯПВЭЕОЙЕФП УЯДЯТЦБ ЙОЖПТНБГЙС, ЛПСФП НПЦЕ ДБ ВЯДЕ РТЕДОБЪОБЮЕОБ ЪБ ПЗТБОЙЮЕОП РПМЪЧБОЕ Й/ЙМЙ РПЧЕТЙФЕМОБ. ч УМХЮБК ЮЕ ОЕ УФЕ ХЛБЪБОЙС РПМХЮБФЕМ ОБ ФПЧБ УЯПВЭЕОЙЕ ЙМЙ ОЕЗПЧ ПФПТЙЪЙТБО РТЕДУФБЧЙФЕМ, ОСНБФЕ РТБЧП ДБ ЗП ЛПРЙТБФЕ ЙМЙ ЙЪРПМЪЧБФЕ, ЛБЛФП Й ДБ ТБЪЛТЙЧБФЕ УЯДЯТЦБОЙЕФП НХ РТЕД ФТЕФЙ МЙГБ. бЛП УФЕ ЗП РПМХЮЙМЙ РП ЗТЕЫЛБ, НПМС ДБ ХЧЕДПНЙФЕ РПДБФЕМС ОЕЪБВБЧОП Й ДБ ЙЪФТЙЕФЕ ФПЧБ УЯПВЭЕОЙЕ ПФ УЙУФЕНБФБ. еМЕЛФТПООЙФЕ УЯПВЭЕОЙС, ТБЪРТПУФТБОСЧБОЙ РП йОФЕТОЕФ НПЗБФ ДБ ВЯДБФ РТПНЕОСОЙ. тБКЖБКЪЕОВБОЛ (вЯМЗБТЙС) ебд, тБКЖБКЪЕО бУЕФ нЕОЙДЦНЯОФ (вЯМЗБТЙС) ебд, тБКЖБКЪЕО ъБУФТБИПЧБФЕМЕО вТПЛЕТ еппд, тБКЖБКЪЕО уЯТЧЙУЙЪ ебд, тБКЖБКЪЕО мЙЪЙОЗ вЯМЗБТЙС ппд, тБКЖБКЪЕО бХФП мЙЪЙОЗ вЯМЗБТЙС еппд Й тБКЖБКЪЕО йНПФЙ еппд ОЕ ОПУСФ ПФЗПЧПТОПУФ ЪБ НПДЙЖЙГЙТБОЙ, РТПНЕОЕОЙ ЙМЙ ЖБМЫЙЖЙГЙТБОЙ УЯПВЭЕОЙС.
