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 1382765013.22777.YahooMailNeo@web193502.mail.sg3.yahoo.com
Whole thread Raw
In response to Re: ZFS-FreeBSD + postgresql performance  ("Steven Hartland" <killing@multiplay.co.uk>)
Responses Re: ZFS-FreeBSD + postgresql performance  (Patrick Dung <patrick_dkt@yahoo.com.hk>)
List pgsql-admin
Tree view

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:

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: postgresql 9.1 out of memory
Next
From: Patrick Dung
Date:
Subject: Re: ZFS-FreeBSD + postgresql performance