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...
postgresdba.hashnode.dev5 min read