Hot Updates in Postgres (opens in new tab)

(boringsql.com)

1 pointsradimm1mo ago2 comments

2 comments

2 comments · 1 top-level

radimmOP1mo ago· 1 in thread

Somehow it feel HOT updates are very confusing. You can also try to play with interactive visualizer to understand it better https://boringsql.com/visualizers/hot-updates/

I didn't get HOT until I saw a visualizer. My mistake was updating an indexed column and wondering why nothing got faster.

j / k navigate · click thread line to collapse