Truncating table doesn't bring back (ALL?) used space?

Started by Ow Mun Hengover 16 years ago1 messagesgeneral
Jump to latest
#1Ow Mun Heng
Ow.Mun.Heng@wdc.com

I've got a largeish table which according to pg_size_pretty, has an on-disk
size 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 that
I only gain back ~7GB in the Filesystem space.

What gives?