Some databases can compress each column differently (https://www.timescale.com/blog/building-columnar-compression-in-a-row-oriented-database/ https://www.timesc

Some databases can compress each column differently (https://www.timescale.com/blog/building-columnar-compression-in-a-row-oriented-database/ https://www.timescale.com/blog/building-columnar-compression...) decreasing overall size. That's not possible in a dump I think. For smallest possible size you'd select an algorithm that is as specific as possible for your data. Once specific it would have worse impact on another type of file.