Roberto Diniz

DELETE in PostgreSQL doesn't shrink the table: only VACUUM reclaims the space

A test with 2 million rows shows, in numbers, why DELETE keeps the table's physical size unchanged and what actually returns space to disk.