I recently introduced ZFS in our lab via FreeNAS 9.2.1 on two large file servers. For the most part we are not dealing with databases but I will definitely keep an eye on it. As of the ZF and Database fragmentation I pretty much lost interest to read article at the point when guy selected i386 and PAE enabled kernel to use with ZFS and 6GB or RAM. My 7 knows that when we use ZFS we need amd64.

As You can imagine there are blocks of free space after METADATA has been erased, which beautifully leads to fragmentation. This can be limited by adding a ZIL device, even on a single disk, then it would look like that:

The REAL solution to ZFS fragmentation is 'Block Pointer Rewrite', which will allow defragmentation and other great features [1] but it did not happened yet.

[1] Rebuild 4-way RAID5 into 5-way RAID5 or remove disks from pool.

__________________religions, worst damnation of mankind"If 386BSD had been available when I started on Linux, Linux would probably never had happened." Linus TorvaldsLinux is not UNIX! Face it! It is not an insult. It is fact: GNU is a recursive acronym for “GNU's Not UNIX”.vermaden's:linksresourcesdeviantartspreadbsd