PostgreSQL Heap-Only-Tuple or HOT Update Optimization

Introduction In this article, we are going to analyze how PostgreSQL Heap-Only-Tuple or HOT Update optimization works, and why you should avoid indexing columns that change very frequently.