MVCC leaves old row versions behind on every update and delete. VACUUM cleans them up, and a handful of system views tell you which tables and queries need your attention.