HOT Updates and BRIN indexes in Postgres 16

Today, I want to talk about a new change in Postgres 16 that helps you ignore BRIN indexes when Postgres checks for HOT updates. Join me for 5mins of Postgres E86.

*Learn more about pganalyze:*

*Check out the pganalyze library for eBooks, webinars, and more:*

📑 *What we have discussed in this episode of 5mins of Postgres:*

*What HOT Updates are*

*pg_stat_all_tables*

*Ignore BRIN indexes when checking for HOT updates - commit*

*README.HOT in the Postgres source code*

*How to use HOT Updates in Postgres to make CLUSTER work better*

*HOT Updates vs Bottom-Up Index Deletion in Postgres 14*

[JogJezz]

It is hard to implement HOT updates on a very big tables. let say I have 1 TB table and have column named status. status is updated and read frequently, so if I have indexes with column status, the tables would not get most benefit of HOT updates.