HOT Updates and BRIN indexes in Postgres 16
Find the article on our blog here: https://pganalyze.com/blog/5mins-post...
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
/ 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/curre...
pg_stat_all_tables
https://www.postgresql.org/docs/curre...
Ignore BRIN indexes when checking for HOT updates - commit
https://git.postgresql.org/gitweb/?p=...
README.HOT in the Postgres source code
https://github.com/postgres/postgres/...
How to use HOT Updates in Postgres to make CLUSTER work better
https://pganalyze.com/blog/5mins-post...
HOT Updates vs Bottom-Up Index Deletion in Postgres 14
https://pganalyze.com/blog/5mins-post...