Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VaH6K-0006Fd-Br for pgsql-admin@arkaria.postgresql.org; Sun, 27 Oct 2013 03:33:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VaH6J-0005Qv-RP for pgsql-admin@arkaria.postgresql.org; Sun, 27 Oct 2013 03:33:15 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZwMP-0004bz-Jv for pgsql-admin@postgresql.org; Sat, 26 Oct 2013 05:24:29 +0000 Received: from nm8-vm8.bullet.mail.sg3.yahoo.com ([106.10.148.199]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZwMM-0001rz-2y for pgsql-admin@postgresql.org; Sat, 26 Oct 2013 05:24:29 +0000 Received: from [106.10.166.122] by nm8.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 Received: from [106.10.151.155] by tm11.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 Received: from [127.0.0.1] by omp1009.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 132209.79010.bm@omp1009.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 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: <1382765013.22777.YahooMailNeo@web193502.mail.sg3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-2135349674-1240868207-1382765063=:35320" X-Pg-Spam-Score: 0.7 (/) 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 ---2135349674-1240868207-1382765063=:35320 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable =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 ---2135349674-1240868207-1382765063=:35320 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable

On , Patrick Dung <patrick_dkt@yahoo.com.hk= > wrote:
<= div id=3D"yiv8333007812">

On S= aturday, October 26, 2013 1:04 AM, Steven Hartland <killing@multiplay.co.uk> wrote:
----- Original Message -----
From: "Patrick Dung" <<= a rel=3D"nofollow" shape=3D"rect" ymailto=3D"mailto:patrick_dkt@yahoo.com.h= k" target=3D"_blank" href=3D"mailto:patrick_dkt@yahoo.com.hk">patrick_dkt@y= ahoo.com.hk>
Sent: Friday, October 25, 2013 4:53 P= M
Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performan= ce


>> I would= also recommend to use 4K sector size=0A using
>
> gnop and zpool export/import.

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

    Regards
    Steve


---------------------

To be spec= ific, 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:
The link is:

http://ivoras.sharanet.or= g/blog/tree/2011-01-01.freebsd-on-4k-sector-drives.html
<= /div>
=
---2135349674-1240868207-1382765063=:35320--