From owner-freebsd-fs@FreeBSD.ORG Mon Oct 28 09:27:31 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 5FE4177F; Mon, 28 Oct 2013 09:27:31 +0000 (UTC) (envelope-from prvs=10136994e7=killing@multiplay.co.uk) Received: from mail1.multiplay.co.uk (mail1.multiplay.co.uk [85.236.96.23]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by mx1.freebsd.org (Postfix) with ESMTPS id 86E3E2E23; Mon, 28 Oct 2013 09:27:30 +0000 (UTC) Received: from r2d2 ([82.69.179.245]) by mail1.multiplay.co.uk (mail1.multiplay.co.uk [85.236.96.23]) (MDaemon PRO v10.0.4) with ESMTP id md50006524437.msg; Mon, 28 Oct 2013 09:27:29 +0000 X-Spam-Processed: mail1.multiplay.co.uk, Mon, 28 Oct 2013 09:27:29 +0000 (not processed: message from valid local sender) X-MDDKIM-Result: neutral (mail1.multiplay.co.uk) X-MDRemoteIP: 82.69.179.245 X-Return-Path: prvs=10136994e7=killing@multiplay.co.uk X-Envelope-From: killing@multiplay.co.uk Message-ID: <5E70894E80E24CF5AF894DAF80DCF04E@multiplay.co.uk> From: "Steven Hartland" To: 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> Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance Date: Mon, 28 Oct 2013 09:27:42 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="koi8-r"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5931 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 Cc: Patrick Dung , pgsql-admin@postgresql.org, owner-freebsd-fs@freebsd.org, freebsd-fs@freebsd.org, freebsd-jail@freebsd.org X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 28 Oct 2013 09:27:31 -0000 ----- Original Message ----- From: >> ----- Original Message ----- >> From: "Patrick Dung" >> Sent: Friday, October 25, 2013 4:53 PM >> Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance >> >> >> >> I would also recommend to use 4K sector size using >> > >> > gnop and zpool export/import. >> >> This will have no effect, the ashift for a pool is set at creation. >> >> Regards >> Steve >> > > That's the idea: to set the ashift during the creation of the pool. Never > did that before? > > gnop create -S 4096 /dev/gpt/disk0 > gnop create -S 4096 /dev/gpt/disk1 > zpool create mirror /dev/gpt/disk0.nop /dev/gpt/disk1.nop > zpool export zroot > gnop destroy /dev/gpt/disk0.nop > gnop destroy /dev/gpt/disk1.nop > zpool import zroot First if your on 10 or 11 you don't need this unless you have a disk which is 4k but is reporting 512b and isnt in our list of quirks. If you still need to do this you only need to do gnop create / destroy onone disk per top level vdev so in your example thats only one disk. Regards Steve ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337 or return the E.mail to postmaster@multiplay.co.uk.