On Apr 10, 2019, at 2:12 PM, Keith Medcalf <kmedc...@dessus.com> wrote: > > It is far cheaper and much more reliable to just buy some file storage space. >
If you’re going to buy some more storage, you should put ZFS on it then, too. :) You get a whole lot more from ZFS than just transparent compression. You actually have to go out of your way to disable compression on ZFS, since in the most common cases, you do want it, since compression + I/O is generally faster than raw I/O. The disk space savings is almost a freebie, in that context. We get this partly because computers often have unused CPU capacity, and ZFS defaults to one of the fastest lossless compression algorithms, lz4: https://facebook.github.io/zstd/ That page is for another up-and-coming alternative for ZFS, zstd, which claims to give gzip-like compression levels at near-lz4 speeds. From their own numbers, though, it looks like the default will remain lz4. About the only time you want to disable compression on ZFS is when you know the pool’s contents are compressed already, as with most digital media, so ZFS would end up just burning a lot of CPU to no good end otherwise. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users