TIL About Postgres dead tuples

When performing an UPDATE in Postgres, the records are not updated in-place. Instead new records are created, and the dead tuples remain in the database until a VACUUM is done.

References

• https://www.postgresql.org/docs/current/sql-vacuum.html