|< < 10 > >|

Postgres MVCC

Index improvements

Heap-only tuples

• Try to avoid maintaining an index when the update does not modify an index key column.
  • Index on r(a), update a: Index maintenance is necessary.
  • Index on r(a), update b: Try to avoid index maintenance.

• Try to avoid multiple index entries for versions of the same row.

|< < 10 > >|