If you can model the domain, then you can achieve very good compression. See this recent timescaledb post (since you mentioned Postgres) which goes over an arr

If you can model the domain, then you can achieve very good compression. See this recent timescaledb post (since you mentioned Postgres) which goes over an array of techniques used in column-store databases that general-purpose compressors on a csv file full of data would not be able to match: https://blog.timescale.com/blog/building-columnar-compression-in-a-row-oriented-database/ https://blog.timescale.com/blog/building-columnar-compressio... discussion: https://news.ycombinator.com/item?id=21412596 https://news.ycombinator.com/item?id=21412596