Re: [ADMIN] ZFS-FreeBSD + postgresql performance

2013-10-25 Thread Patrick Dung
On , Patrick Dung wrote: On Saturday, October 26, 2013 1:04 AM, Steven Hartland wrote: - Original Message - From: "Patrick Dung" Sent: Friday, October 25, 2013 4:53 PM Subject: Re: [ADMIN] ZFS-FreeBSD + postgresql performance >> I would also recommend to use 4K sector size u

Re: [ADMIN] ZFS-FreeBSD + postgresql performance

2013-10-25 Thread Patrick Dung
On Saturday, October 26, 2013 1:04 AM, Steven Hartland wrote: - Original Message - From: "Patrick Dung" 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/

Re: [ADMIN] ZFS-FreeBSD + postgresql performance

2013-10-25 Thread Steven Hartland
- Original Message - From: "Patrick Dung" 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 cre

Re: [ADMIN] ZFS-FreeBSD + postgresql performance

2013-10-25 Thread Patrick Dung
> I would also recommend to use 4K sector size using gnop and zpool export/import. Agree, in my small setup, 4K sectors and aligned partition can be seven or eight times faster than 512kb sectors when the harddisk is in advance format (4kb per sectors) Also suggest to have two separte fast SSD

Re: [ADMIN] ZFS-FreeBSD + postgresql performance

2013-10-25 Thread Patrick Dung
> I would also recommend to use 4K sector size using gnop and zpool export/import. Agree, in my small setup, 4K sectors and aligned partition can be seven or eight times faster than 512kb sectors when the harddisk is in advance format (4kb per sectors) Also suggest to have two separte fast SSD