Every UPDATE Leaves a Ghost: MVCC, Bloat, and VACUUM in PostgreSQL

Every UPDATE Leaves a Ghost: MVCC, Bloat, and VACUUM in PostgreSQL

💡 原文英文,约3600词,阅读约需14分钟。
📝

内容提要

What happens to old row versions after nobody needs them? They become dead tuples, and over time they bloat your tables. Go deeper into PostgreSQL MVCC with runnable psql examples.

🏷️

标签

➡️

继续阅读