Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VaH6F-0006F5-T8 for pgsql-admin@arkaria.postgresql.org; Sun, 27 Oct 2013 03:33:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VaH6D-0005LV-R8 for pgsql-admin@arkaria.postgresql.org; Sun, 27 Oct 2013 03:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZwLb-0004bg-JQ for pgsql-admin@postgresql.org; Sat, 26 Oct 2013 05:23:39 +0000 Received: from nm2-vm3.bullet.mail.sg3.yahoo.com ([106.10.148.106]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZwLX-0001rf-Sh for pgsql-admin@postgresql.org; Sat, 26 Oct 2013 05:23:38 +0000 Received: from [106.10.166.115] by nm2.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:23:34 -0000 Received: from [106.10.150.28] by tm4.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:23:33 -0000 Received: from [127.0.0.1] by omp1029.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:23:33 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 945491.5966.bm@omp1029.mail.sg3.yahoo.com Received: (qmail 23919 invoked by uid 60001); 26 Oct 2013 05:23:33 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.hk; s=s1024; t=1382765013; bh=Mo3yxvxwwK/n+yKjTq5FeeXPaE+iNZZ5Tj3mx7NCXDw=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=lEjB3jN/mEBN1HejHDUF/pJLEDmA52L1BPQiSpnl1lzRLUibCWuayR9HEI3I1jKDNDevD0gWDldmASLEbU38XMqP1i3WaNzmGt4K2jaj3CVlQ2IVG0LeSSMlumRgfd+6Rl+C9vRKXuC79JY9NLlQbBmdcpPltpJ4gdOvTYojyCw= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com.hk; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=xt+Dj2pGACn36EvjozN2qHlqY4lA/U9H6vST07S6OmrWddqMd9J/bJqelG8BWJ4EhePB8Oi4LD3XuQj2V8+K85N5CaOvnQOJipGYk91z6xXk2J0cJx6M6U3SPZUpqNIDINkTsIm+6Hdi0mvdhwkFKWraIq9QSXHUlKxQ5gimL30=; X-YMail-OSG: _hhhqQsVM1lyy4P1tSWoK7QmRjD27b4qRZemOd8BVqKpNmn QjfNlPhAYzQRw4nh_fF230tonyrTkkcGTnIs1xaU4tYtUuM1w9lmRDZsCdAv c9gavmWYbSLFzTSRQrr4WjmxxpIphoMX8k3fkXdEHVK8KRaGsgu3JUspZMyg h7vChCfG7XWB1Zhb4b6Gr06LHUtyPDXpsbYodrqrOSVi9emCx7m0KqVefkJC 1S4ljOhxjHX1spL76Kpj0RPy81zig_ovHzb8o7VXD4nJ0JBpNJjHNlh7Xlgc Zwuwjeqf5zHugjpNSnEwd6ADvXJwfO6ju.6s6m0OnGt8rMhMfM6lQCepGu.G OR9_jSvkpTadU4eluGqbD3H1Gugvbzp3If9ElzhnfFxlszsE3MTyLlV.ggnY EOKmjMzAEFGdxiwBzZ2Qt0rpYay3NSvA5sBiAx0pohAegrSOUt142ggxfxgt 56ss_qOx2Ni9uoSH7MWV0tgQ.EYZdfg55yvpK9onCg.bOSoYJAU4Ote0WjK0 nidffZoGhJwcVaInZCXA.x58wrIrJM0PL0Ej0R1Q_g80136aRA0KczzJOh_X ZrTK06aw3ic_esSN_b5s- Received: from [61.15.240.133] by web193502.mail.sg3.yahoo.com via HTTP; Sat, 26 Oct 2013 13:23:33 SGT X-Rocket-MIMEInfo: 002.001, CgpPbiBTYXR1cmRheSwgT2N0b2JlciAyNiwgMjAxMyAxOjA0IEFNLCBTdGV2ZW4gSGFydGxhbmQgPGtpbGxpbmdAbXVsdGlwbGF5LmNvLnVrPiB3cm90ZToKIAotLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0tIApGcm9tOiAiUGF0cmljayBEdW5nIiA8cGF0cmlja19ka3RAeWFob28uY29tLmhrPgpTZW50OiBGcmlkYXksIE9jdG9iZXIgMjUsIDIwMTMgNDo1MyBQTQpTdWJqZWN0OiBSZTogW0FETUlOXSBaRlMtRnJlZUJTRCArIHBvc3RncmVzcWwgcGVyZm9ybWFuY2UKCgo.PiBJIHdvdWxkIGFsc28gcmVjb20BMAEBAQE- X-Mailer: YahooMailWebService/0.8.160.587 References: <20131023162545.GA19794@pcjas.obspm.fr> <1382548465.32073.37624113.6AA8DB42@webmail.messagingengine.com> <52683855.6060609@gmx.net> <1382716422.13782.YahooMailNeo@web193504.mail.sg3.yahoo.com> Message-ID: <1382765013.22777.YahooMailNeo@web193502.mail.sg3.yahoo.com> Date: Sat, 26 Oct 2013 13:23:33 +0800 (SGT) From: Patrick Dung Reply-To: Patrick Dung Subject: Re: ZFS-FreeBSD + postgresql performance To: Steven Hartland , "Ivailo.TANUSHEFF@raiffeisen.bg" , Michael Schmiedgen Cc: "owner-freebsd-fs@freebsd.org" , "freebsd-fs@freebsd.org" , "pgsql-admin@postgresql.org" , "freebsd-jail@freebsd.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-507039889-944062071-1382765013=:22777" X-Pg-Spam-Score: 2.0 (++) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---507039889-944062071-1382765013=:22777 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =0A=0AOn Saturday, October 26, 2013 1:04 AM, Steven Hartland wrote:=0A =0A----- Original Message ----- =0AFrom: "Patrick Dun= g" =0ASent: Friday, October 25, 2013 4:53 PM=0ASu= bject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance=0A=0A=0A>> I would = also recommend to use 4K sector size using=0A>=0A> gnop and zpool export/im= port.=0A=0AThis will have no effect, the ashift for a pool is set at creati= on.=0A=0A=A0 =A0 Regards=0A=A0 =A0 Steve=0A=0A=0A---------------------=0A= =0ATo be specific, I think the steps should be gnop create, create zfs pool= , export zfs, remove gnop and reimport zfs.=0AThis link have the deatils an= d steps: ---507039889-944062071-1382765013=:22777 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

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: Fr= iday, October 25, 2013 4:53 PM
Subject: Re: [ADMIN] ZFS-FreeBSD + postgr= esql performance


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

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

    R= egards
    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= :

---507039889-944062071-1382765013=:22777--