ScyllaDB tested out LZ4, Snappy, DEFLATE, and ZStandard at several different levels on a decently real-world-ish workload. tl;dr:
Use compression. Unless you are using a really (but REALLY) fast hard drive, using the default compression settings will be even faster than disabling compression, and the space savings are huge. When running a data warehouse where data is mostly being read and only rarely updated, consider using DEFLATE. It provides very good compression ratios while maintaining high decompression speeds; compression can be slower, but that might be unimportant for your workload. If your workload is write-heavy but you really care about saving disk space, consider using ZStandard on level 1. It provides a good middle-ground between LZ4/Snappy and DEFLATE in terms of compression ratios and keeps compression speeds close to LZ4 and Snappy. Be careful however: if you often want to read cold data (from the SSTables on disk, not currently stored in memory, so for example data that was inserted a long time ago), the slower decompression might become a problem.
Rather than focusing on the production of a commercial conifer (or broadleaf) timber crop, you can also choose to establish a new native woodland. Not only will an ecologically rich, biodiverse woodland be created, but it also presents opportunities for planting in various environmentally sensitive areas such as Special Areas of Conservation (SACs) and Special Protection Areas (SPAs). Establishing a native woodland will provide you with higher annual payments of €665-€680/ha/yr for 15 years.