Hot Updates in Postgres (opens in new tab)

(boringsql.com)

1 pointsradimm11d ago2 comments

2 comments

radimmOP11d ago

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

radimmOP11d ago

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