Database Compression Options – Compared

This is the best way I found to visualize this data.  Each compression method (bzip2, gzip, etc) starts at 0 or 1 (least compression on the left) and goes up to 9 (most compression on the right).   Except for xz -e which just does the odd numbers and 0. They are all compressing the same size file (it was a 32 GB database).

I think this graph nicely shows why xz (which is the same compression as LZMA2/7-zip) is getting so much traction.

Take a look at the raw data.
Technical notes: I actually divided filesize (from ls) by 10000000 because it worked out better for the graph. I truncated the seconds.

Leave a Reply