7z the csv. Get a million rows from your table. Compare the csv to the 7z. That will give you a good idea on what kind of compression you will see.

I have very redundant data. I often see 10:1 compression. It's a lot less when I have hashes, addresses and timestamps.