Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZko3-0003OD-62 for pgsql-admin@arkaria.postgresql.org; Fri, 25 Oct 2013 17:04:15 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VZko2-00049c-3Z for pgsql-admin@arkaria.postgresql.org; Fri, 25 Oct 2013 17:04:14 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZk7D-0004EV-P5 for pgsql-admin@postgresql.org; Fri, 25 Oct 2013 16:19:59 +0000 Received: from mail1.multiplay.co.uk ([85.236.96.23]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VZk79-0005CA-KO for pgsql-admin@postgresql.org; Fri, 25 Oct 2013 16:19:58 +0000 Received: from r2d2 ([82.69.141.170]) by mail1.multiplay.co.uk (mail1.multiplay.co.uk [85.236.96.23]) (MDaemon PRO v10.0.4) with ESMTP id md50006503893.msg for ; Fri, 25 Oct 2013 17:19:53 +0100 X-Spam-Processed: mail1.multiplay.co.uk, Fri, 25 Oct 2013 17:19:53 +0100 (not processed: message from valid local sender) X-MDDKIM-Result: neutral (mail1.multiplay.co.uk) X-MDRemoteIP: 82.69.141.170 X-Return-Path: prvs=101050af22=killing@multiplay.co.uk X-Envelope-From: killing@multiplay.co.uk X-MDaemon-Deliver-To: pgsql-admin@postgresql.org Message-ID: From: "Steven Hartland" To: "Patrick Dung" , , "Michael Schmiedgen" Cc: , , , 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: ZFS-FreeBSD + postgresql performance Date: Fri, 25 Oct 2013 17:19:54 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8"; 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 X-Pg-Spam-Score: -1.4 (-) 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 ----- 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 ================================================ 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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin