Hacker News new | ask | show | jobs
by philliphaydon 2479 days ago
If you change a value to null it’s still a row allocated in the index. The index size won’t shrink unless you rebuild it. Removing and deleting data will just end up with fragmentation.