Hot Updates in Postgres
boringsql.com
Hot Updates in Postgres
1–3 of 3 posts
Re: Hot Updates in Postgres
#2Somehow 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/
Re: Hot Updates in Postgres
#3Somehow 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.