Basic Understanding of Bloat and VACUUM in PostgreSQL

Implementation of MVCC (Multi-Version Concurrency Control) in PostgreSQL is different and special when compared with other RDBMS. MVCC in PostgreSQL controls which tuples can be visible to transactions via versioning.
What is versioning in PostgreSQL?
Let’s consider the case of an Oracle or a MySQL Database. What happens when you perform a DELETE or an UPDATE […]