Hot Updates in Postgres(boringsql.com)

1 pointsby radimm2 เดือนที่ผ่านมา2 comments

https://boringsql.com/posts/hot-updates/

2 comments

radimm2 เดือนที่ผ่านมา

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/

arriemeijer2 เดือนที่ผ่านมา

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