From: Steven Hartland <killing@multiplay.co.uk>
To: Patrick Dung <patrick_dkt@yahoo.com.hk>
To: Ivailo.TANUSHEFF@raiffeisen.bg
To: Michael Schmiedgen <schmiedgen@gmx.net>
Cc: owner-freebsd-fs@freebsd.org
Cc: freebsd-fs@freebsd.org
Cc: pgsql-admin@postgresql.org
Cc: freebsd-jail@freebsd.org
Subject: Re: ZFS-FreeBSD + postgresql performance
Date: Fri, 25 Oct 2013 17:19:54 +0100
Message-ID: <DF66E5265C9A470A8EFABA893D5BE384@multiplay.co.uk> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
----- Original Message -----
From: "Patrick Dung" <patrick_dkt@yahoo.com.hk>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: killing@multiplay.co.uk, patrick_dkt@yahoo.com.hk, Ivailo.TANUSHEFF@raiffeisen.bg, schmiedgen@gmx.net, owner-freebsd-fs@freebsd.org, freebsd-fs@freebsd.org, freebsd-jail@freebsd.org
Subject: Re: ZFS-FreeBSD + postgresql performance
In-Reply-To: <DF66E5265C9A470A8EFABA893D5BE384@multiplay.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox