Re: ZFS-FreeBSD + postgresql performance - Mailing list pgsql-admin

From Steven Hartland
Subject Re: ZFS-FreeBSD + postgresql performance
Date
Msg-id DF66E5265C9A470A8EFABA893D5BE384@multiplay.co.uk
Whole thread Raw
In response to ZFS-FreeBSD + postgresql performance  (Albert Shih <Albert.Shih@obspm.fr>)
Responses Re: ZFS-FreeBSD + postgresql performance
Re: ZFS-FreeBSD + postgresql performance
List pgsql-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.
Inthe event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or
anyinformation 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.



pgsql-admin by date:

Previous
From: Patrick Dung
Date:
Subject: Re: ZFS-FreeBSD + postgresql performance
Next
From: Payal Singh
Date:
Subject: Re: failover and switchover in postgresql