HOT update term
Postgres in-place update that skips index modification
When updated columns aren't indexed AND the new tuple fits on the same page, Postgres avoids rewriting indexes. Big perf win — but breaks down with low fillfactor or indexed columns updated.