HOT Updates and BRIN indexes in Postgres 16

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-16-HOT-Updates-BRIN-Index

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:*

https://pganalyze.com

https://pganalyze.com/newsletter

https://twitter.com/pganalyze/

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

https://pganalyze.com/resources

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

*What HOT Updates are*

https://www.postgresql.org/docs/current/storage-hot.html

*pg_stat_all_tables*

https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-ALL-TABLES-VIEW

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

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=19d8e2308bc51ec4ab993ce90077342c915dd116

*README.HOT in the Postgres source code*

https://github.com/postgres/postgres/blob/master/src/backend/access/heap/README.HOT

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

https://pganalyze.com/blog/5mins-postgres-performance-HOT-updates-CLUSTER

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

https://pganalyze.com/blog/5mins-postgres-hot-updates-vs-bottom-up-index-deletion