Understanding and Fixing Table Bloat in PostgreSQL

Understanding and Fixing Table Bloat in PostgreSQL Every row you update in PostgreSQL leaves a corpse behind. Not metaphorically -- literally. PostgreSQL's MVCC architecture means that UPDATE doesn't modify a row in place. It creates a brand new vers...