Date: Sat, 26 Oct 2013 13:23:33 +0800 (SGT) From: Patrick Dung <patrick_dkt@yahoo.com.hk> To: Steven Hartland <killing@multiplay.co.uk>, "Ivailo.TANUSHEFF@raiffeisen.bg" <Ivailo.TANUSHEFF@raiffeisen.bg>, Michael Schmiedgen <schmiedgen@gmx.net> Cc: "freebsd-fs@freebsd.org" <freebsd-fs@freebsd.org>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>, "freebsd-jail@freebsd.org" <freebsd-jail@freebsd.org>, "owner-freebsd-fs@freebsd.org" <owner-freebsd-fs@freebsd.org> Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance Message-ID: <1382765013.22777.YahooMailNeo@web193502.mail.sg3.yahoo.com> In-Reply-To: <DF66E5265C9A470A8EFABA893D5BE384@multiplay.co.uk> References: <20131023162545.GA19794@pcjas.obspm.fr> <1382548465.32073.37624113.6AA8DB42@webmail.messagingengine.com> <52683855.6060609@gmx.net> <OF0B1DBA74.B7B14575-ONC2257C0E.001EC20A-C2257C0E.00239411@LocalDomain> <1382716422.13782.YahooMailNeo@web193504.mail.sg3.yahoo.com> <DF66E5265C9A470A8EFABA893D5BE384@multiplay.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
=0A=0AOn Saturday, October 26, 2013 1:04 AM, Steven Hartland <killing@multi= play.co.uk> wrote:=0A =0A----- Original Message ----- =0AFrom: "Patrick Dun= g" <patrick_dkt@yahoo.com.hk>=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-jail@FreeBSD.ORG Sat Oct 26 05:24:27 2013 Return-Path: <owner-freebsd-jail@FreeBSD.ORG> Delivered-To: freebsd-jail@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 3500786D for <freebsd-jail@freebsd.org>; Sat, 26 Oct 2013 05:24:27 +0000 (UTC) (envelope-from patrick_dkt@yahoo.com.hk) Received: from nm29-vm8.bullet.mail.sg3.yahoo.com (nm29-vm8.bullet.mail.sg3.yahoo.com [106.10.151.167]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 72FFF28FA for <freebsd-jail@freebsd.org>; Sat, 26 Oct 2013 05:24:26 +0000 (UTC) Received: from [106.10.166.125] by nm29.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 Received: from [106.10.151.170] by tm14.bullet.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 Received: from [127.0.0.1] by omp1010.mail.sg3.yahoo.com with NNFMP; 26 Oct 2013 05:24:24 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 132045.49110.bm@omp1010.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> <OF0B1DBA74.B7B14575-ONC2257C0E.001EC20A-C2257C0E.00239411@LocalDomain> <1382716422.13782.YahooMailNeo@web193504.mail.sg3.yahoo.com> <DF66E5265C9A470A8EFABA893D5BE384@multiplay.co.uk> <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 <patrick_dkt@yahoo.com.hk> Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance To: Steven Hartland <killing@multiplay.co.uk>, "Ivailo.TANUSHEFF@raiffeisen.bg" <Ivailo.TANUSHEFF@raiffeisen.bg>, Michael Schmiedgen <schmiedgen@gmx.net> 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" <freebsd-fs@freebsd.org>, "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>, "freebsd-jail@freebsd.org" <freebsd-jail@freebsd.org>, "owner-freebsd-fs@freebsd.org" <owner-freebsd-fs@freebsd.org> X-BeenThere: freebsd-jail@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: Patrick Dung <patrick_dkt@yahoo.com.hk> List-Id: "Discussion about FreeBSD jail\(8\)" <freebsd-jail.freebsd.org> List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-jail>, <mailto:freebsd-jail-request@freebsd.org?subject=unsubscribe> List-Archive: <http://lists.freebsd.org/pipermail/freebsd-jail>; List-Post: <mailto:freebsd-jail@freebsd.org> List-Help: <mailto:freebsd-jail-request@freebsd.org?subject=help> List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-jail>, <mailto:freebsd-jail-request@freebsd.org?subject=subscribe> X-List-Received-Date: Sat, 26 Oct 2013 05:24:27 -0000 =0A=0AOn , Patrick Dung <patrick_dkt@yahoo.com.hk> wrote:=0A =0A=0A=0AOn Sa= turday, October 26, 2013 1:04 AM, Steven Hartland <killing@multiplay.co.uk>= wrote:=0A =0A----- Original Message ----- =0AFrom: "Patrick Dung" <patrick= _dkt@yahoo.com.hk>=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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1382765013.22777.YahooMailNeo>