Hot Updates in Postgres

1 points by radimm 64 days ago | 2 comments

radimm 63 days 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/

arriemeijer 63 days ago | |

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

radimm 63 days 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/

arriemeijer 63 days ago | |

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