Multiple ChoiceHard 45s
HOT updates and indexed columns
A Postgres HOT (Heap-Only Tuple) update avoids new index entries. Which condition must hold for HOT to apply?
Options
- 1The update must not modify any indexed column, and there must be space on the same page
- 2The update must change at least one indexed column, so the engine must relocate the row
- 3The table must have no indexes at all, since any index prevents HOT updates no matter which column changes
- 4The transaction must be strictly read-only, because a HOT update is only allowed when no write lock is held
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.