I've got a largeish table which according to pg_size_pretty, has an on-disksize of ~22GB Table size and 12GB index size, approx 55million rows.
When I truncate the table, (I've moved the data somewhere else), I see thatI only gain back ~7GB in the Filesystem space.
What gives?