HOT Updates in Postgres
Summary
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 pagei...
Description
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 pagei...
Original reporting
AFBytes is a read-only aggregator. Use the original source for full context and complete reporting.
Open original source