| 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:24:23 |
| Message-ID: | 1382765063.35320.YahooMailNeo@web193504.mail.sg3.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On , Patrick Dung <patrick_dkt(at)yahoo(dot)com(dot)hk> wrote:
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:
The link is:
http://ivoras.sharanet.org/blog/tree/2011-01-01.freebsd-on-4k-sector-drives.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Евгений Селявка | 2013-10-26 12:54:27 | postgresql 9.1 out of memory |
| Previous Message | Patrick Dung | 2013-10-26 05:23:33 | Re: ZFS-FreeBSD + postgresql performance |