HOT Updates in Postgres (opens in new tab)

Every UPDATE risks rewriting every index. HOT updates skip that bill by chaining new tuple versions inside a single page, leaving the indexes untouched. A pageinspect-led tour of HOT chains, page pruning, and fillfactor.