[icefo]

That's something I did for small medium size data analysis (300Gb of csv). The reported size was around 800gb with indexes iirc and it fitted on a 512gb SSD.

It compresses the indexes pretty well but don't forget to turn off postgres' own copy on write mechanism