Postgres MVCC
Index improvements
Heap-only tuples
Suppose r1 is updated to r2, and we have an index.
HOT avoids creating a new index entry if:
- All index column fields match between r1 and r2.
- r1 is on the same page as r2.
Without HOT:
Postgres MVCCIndex improvementsHeap-only tuplesSuppose r1 is updated to r2, and we have an index. HOT avoids creating a new index entry if:
Without HOT:
|