Hacker News new | ask | show | jobs
by icefo 139 days ago
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