From owner-freebsd-fs@FreeBSD.ORG Sat Oct 26 05:23:43 2013 Return-Path: Delivered-To: freebsd-fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTP id 17EF27CF for ; Sat, 26 Oct 2013 05:23:43 +0000 (UTC) (envelope-from patrick_dkt@yahoo.com.hk) Received: from nm1-vm1.bullet.mail.sg3.yahoo.com (nm1-vm1.bullet.mail.sg3.yahoo.com [106.10.148.72]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 7C58328EA for ; Sat, 26 Oct 2013 05:23:42 +0000 (UTC) Received: from [106.10.166.61] by nm1.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:23:34 -0000 Received: from [106.10.150.27] by tm18.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:23:33 -0000 Received: from [127.0.0.1] by omp1028.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:23:33 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 940745.66242.bm@omp1028.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 Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance To: Steven Hartland , "Ivailo.TANUSHEFF@raiffeisen.bg" , Michael Schmiedgen In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.14 Cc: "freebsd-fs@freebsd.org" , "pgsql-admin@postgresql.org" , "freebsd-jail@freebsd.org" , "owner-freebsd-fs@freebsd.org" X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: Patrick Dung List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 26 Oct 2013 05:23:43 -0000 =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: From owner-freebsd-fs@FreeBSD.ORG Sat Oct 26 05:24:27 2013 Return-Path: Delivered-To: freebsd-fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTP id 53C4D86E for ; Sat, 26 Oct 2013 05:24:27 +0000 (UTC) (envelope-from patrick_dkt@yahoo.com.hk) Received: from nm9-vm6.bullet.mail.sg3.yahoo.com (nm9-vm6.bullet.mail.sg3.yahoo.com [106.10.148.213]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 9000328FB for ; Sat, 26 Oct 2013 05:24:26 +0000 (UTC) Received: from [106.10.166.124] by nm9.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 Received: from [106.10.151.186] by tm13.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 Received: from [127.0.0.1] by omp1012.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 135079.24890.bm@omp1012.mail.sg3.yahoo.com Received: (qmail 36799 invoked by uid 60001); 26 Oct 2013 05:24:23 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com.hk; s=s1024; t=1382765063; bh=XhN/luD6GySM20955Al18hbmlaTTRJ0N6iJ3gTSWdic=; 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=y5pOGVfMW+b4j/CPpSg2BNho7/DI2HEb7Hw9SYZ1q4iGOs3lHBYFeUf+vnFt6trWr7CPDN5SMTRghOKSLvmOf/Do0Rctbf2z7ZMz8qeYAadkjr4N959IRsylmDGpnX8bEf2dEKEuV4fBuIIdbAWXxFFDojSY9MY62UIznihpfn4= 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=shWeDuwsO+RtugCTd8ACaeoL5vSXgTrKua/oYFF4otiZrQctr0ZtSevBW4ymBj+3B7QLUiSCxMmZiT2jno96N1V3Jm7122IFvjmdzvWKeUrGdhgcHqubDSygFd2bEJ6ajAtfCsGhor9eDFzmc5F86S0Ns3jyUgP98521s9WE/JM=; X-YMail-OSG: qw7EvoEVM1nXWr6ew5BfdYvLN7x1MUMP_zsmBdL0MCykLVV 8yoo2nzKOWI5i12sdIzzqfFdUlIc_xRwURjGcyiEOSopdogy6pfqkC_MTM20 m3vte8yVD7e2G2J3fVobo9KUtz5G_Df21tCuW_SlJdmWQ65zcS43KEJxzbjS BTy98g_gENdyRZ671lApAVPS2nhFAuwd6LZGZ.NlWisuW1y5_mo2tgiqvMCa QsLqiKGT6RKOsQJ2aMkuV2S5laQLQjCLKzLCREVGb_FlSHGBRebDyUnLzuqB inPra0G3zVuePimLIk9CHMTKM3Aacv_Epi3iMLBO0BUbt2l.YkcvsGDNKzNy 2foklJMpjMwmjS4f6AIIInuZsfmpJknAGlPkdXFueGm7TKivgC54L8fokJFx Fq.lvg312HiJbpzXI9LuSLSHlvHGSbaupvxRXmugd8IO10AL.CQpxHHrqRPE FCXtnmnPDv.FEo9ABZjI4aGB2jjIPlvEcfmw3bcRKEubojxOKPGjpm2MxJqG bQ3qXor3KT3EPQ0gZ3_uMqdJel.myz0KMkmR_XXjfCF_cj2ZCK72UQcdKMDN 90Lv56ugWyBBg2IQXJIVc30deLeUlexPhg2zNO5ZO2i_kDcMYZXq697j46HK 87T109S9yxB6l5IqGBgK7UZdTByNPCcVpqb6xB0IOwNlSl_5m5FLgb6U0__i gQ2QGYGePcgufTr33EdT8OTdIf03IqB5XiciDdA-- Received: from [61.15.240.133] by web193504.mail.sg3.yahoo.com via HTTP; Sat, 26 Oct 2013 13:24:23 SGT X-Rocket-MIMEInfo: 002.001, CgpPbiAsIFBhdHJpY2sgRHVuZyA8cGF0cmlja19ka3RAeWFob28uY29tLmhrPiB3cm90ZToKIAoKCk9uIFNhdHVyZGF5LCBPY3RvYmVyIDI2LCAyMDEzIDE6MDQgQU0sIFN0ZXZlbiBIYXJ0bGFuZCA8a2lsbGluZ0BtdWx0aXBsYXkuY28udWs.IHdyb3RlOgogCi0tLS0tIE9yaWdpbmFsIE1lc3NhZ2UgLS0tLS0gCkZyb206ICJQYXRyaWNrIER1bmciIDxwYXRyaWNrX2RrdEB5YWhvby5jb20uaGs.ClNlbnQ6IEZyaWRheSwgT2N0b2JlciAyNSwgMjAxMyA0OjUzIFBNClN1YmplY3Q6IFJlOiBbQURNSU5dIFpGUy0BMAEBAQE- 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> <1382765013.22777.YahooMailNeo@web193502.mail.sg3.yahoo.com> Message-ID: <1382765063.35320.YahooMailNeo@web193504.mail.sg3.yahoo.com> Date: Sat, 26 Oct 2013 13:24:23 +0800 (SGT) From: Patrick Dung Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance To: Steven Hartland , "Ivailo.TANUSHEFF@raiffeisen.bg" , Michael Schmiedgen In-Reply-To: <1382765013.22777.YahooMailNeo@web193502.mail.sg3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.14 Cc: "freebsd-fs@freebsd.org" , "pgsql-admin@postgresql.org" , "freebsd-jail@freebsd.org" , "owner-freebsd-fs@freebsd.org" X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: Patrick Dung List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 26 Oct 2013 05:24:27 -0000 =0A=0AOn , Patrick Dung wrote:=0A =0A=0A=0AOn Sa= turday, October 26, 2013 1:04 AM, Steven Hartland = wrote:=0A =0A----- Original Message ----- =0AFrom: "Patrick Dung" =0ASent: Friday, October 25, 2013 4:53 PM=0ASubject: Re: = [ADMIN] ZFS-FreeBSD + postgresql performance=0A=0A=0A>> I would also recomm= end to use 4K sector size=0A using=0A>=0A> gnop and zpool export/import.=0A= =0AThis will have no effect, the ashift for a pool is set at creation.=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 and steps:= =0AThe link is:=0A=0Ahttp://ivoras.sharanet.org/blog/tree/2011-01-01.freebs= d-on-4k-sector-drives.html=0A