Re: ZFS-FreeBSD + postgresql performance

From: "Steven Hartland" <killing(at)multiplay(dot)co(dot)uk>
To: "Patrick Dung" <patrick_dkt(at)yahoo(dot)com(dot)hk>, <Ivailo(dot)TANUSHEFF(at)raiffeisen(dot)bg>, "Michael Schmiedgen" <schmiedgen(at)gmx(dot)net>
Cc: <owner-freebsd-fs(at)freebsd(dot)org>, <freebsd-fs(at)freebsd(dot)org>, <pgsql-admin(at)postgresql(dot)org>, <freebsd-jail(at)freebsd(dot)org>
Subject: Re: ZFS-FreeBSD + postgresql performance
Date: 2013-10-25 16:19:54
Message-ID: DF66E5265C9A470A8EFABA893D5BE384@multiplay.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

----- 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

================================================
This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information 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(at)multiplay(dot)co(dot)uk(dot)

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Payal Singh 2013-10-25 17:02:13 Re: failover and switchover in postgresql
Previous Message Patrick Dung 2013-10-25 15:53:42 Re: ZFS-FreeBSD + postgresql performance