Heap Only Tuples

When doing a UPDATE, Postgres’s MVCC to keeps track of version of rows. This updated version of row also needs to update index. Remove old version of rows and its index is expensive.

To reduce this overhead, Postgres has optimization called heap-only tuples HOT. An update is HOT when:


The system view pg_stat_all_tables can monitor occurrence of HOT and non-HOT updates.