Postgres Pro
Downloads
Home   >   mailing lists

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

From Patrick Dung
Subject Re: ZFS-FreeBSD + postgresql performance
Date
Msg-id 1382765063.35320.YahooMailNeo@web193504.mail.sg3.yahoo.com
Whole thread Raw
In response to Re: ZFS-FreeBSD + postgresql performance  (Patrick Dung <patrick_dkt@yahoo.com.hk>)
List pgsql-admin
Tree view

On , Patrick Dung <patrick_dkt@yahoo.com.hk> wrote:

On Saturday, October 26, 2013 1:04 AM, Steven Hartland <killing@multiplay.co.uk> wrote:
----- 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


---------------------

To be specific, I think the steps should be gnop create, create zfs pool, export zfs, remove gnop and reimport zfs.
This link have the deatils and steps:
The link is:

http://ivoras.sharanet.org/blog/tree/2011-01-01.freebsd-on-4k-sector-drives.html

pgsql-admin by date:

Previous
From: Patrick Dung
Date:
Subject: Re: ZFS-FreeBSD + postgresql performance
Next
From: "Ginepro, Raymond C"
Date:
Subject: Re: wrong size archive file