Skip to content

Latest commit

 

History

History
19 lines (7 loc) · 328 Bytes

hot_update.md

File metadata and controls

19 lines (7 loc) · 328 Bytes

Hot (Heap Only Tuple) Update

Update the row - where there is no update on index column.

Hot Update

How to Track?

select n_tup_upd, n_tup_hot_upd from pg_stat_all_tables where relname = 'table_name'

How to improve High write workload

Avoid updating indexed column.