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

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 us

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