| From: | Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk> |
|---|---|
| To: | Steven Hartland <killing(at)multiplay(dot)co(dot)uk>, "Ivailo(dot)TANUSHEFF(at)raiffeisen(dot)bg" <Ivailo(dot)TANUSHEFF(at)raiffeisen(dot)bg>, Michael Schmiedgen <schmiedgen(at)gmx(dot)net> |
| Cc: | "owner-freebsd-fs(at)freebsd(dot)org" <owner-freebsd-fs(at)freebsd(dot)org>, "freebsd-fs(at)freebsd(dot)org" <freebsd-fs(at)freebsd(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, "freebsd-jail(at)freebsd(dot)org" <freebsd-jail(at)freebsd(dot)org> |
| Subject: | Re: ZFS-FreeBSD + postgresql performance |
| Date: | 2013-10-26 05:23:33 |
| Message-ID: | 1382765013.22777.YahooMailNeo@web193502.mail.sg3.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Saturday, October 26, 2013 1:04 AM, Steven Hartland <killing(at)multiplay(dot)co(dot)uk> wrote:
----- Original Message -----
From: "Patrick Dung" <patrick_dkt(at)yahoo(dot)com(dot)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:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Patrick Dung | 2013-10-26 05:24:23 | Re: ZFS-FreeBSD + postgresql performance |
| Previous Message | Scott Ribe | 2013-10-25 17:07:06 | Re: failover and switchover in postgresql |