4 ms·

I'm also a very happy ZFS user on FreeBSD. I've tried to use it in a lot of crazy ways. At the moment I'm researching if ZFS and a virtual machine running Micro

by olavgg 13y ago

I'm also a very happy ZFS user on FreeBSD. I've tried to use it in a lot of crazy ways. At the moment I'm researching if ZFS and a virtual machine running Microsoft SQL Server can improve query performance(with LZ4/GZIP compression) and improve the backup speed. Though I'm wondering about if there are any plans to add XZ compression? Or faster hashing with Siphash24 for data checksums?

Scaevolus 13y ago
LZMA compression (used in the xz format) is much slower than the disk interface and uses a lot of memory, so it would reduce performance.
Scaevolus 13y ago
LZMA compression (used in the xz format) is much slower than the disk interface and uses a lot of memory, so it would reduce performance.
patrickg_zill 13y ago
Improving the backup speed should be as easy as quiescing the database, taking a ZFS snapshot after you are sure everything is written to disk, then backing up that snapshot.