Find the article on our blog here: 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:
pganalyze.com
pganalyze.com/newsletter
/ pganalyze
Check out the pganalyze library for eBooks, webinars, and more:
pganalyze.com/resources
📑 What we have discussed in this episode of 5mins of Postgres:
What HOT Updates are
www.postgresql.org/docs/curre...
pg_stat_all_tables
www.postgresql.org/docs/curre...
Ignore BRIN indexes when checking for HOT updates - commit
git.postgresql.org/gitweb/?p=...
README.HOT in the Postgres source code
github.com/postgres/postgres/...
How to use HOT Updates in Postgres to make CLUSTER work better
pganalyze.com/blog/5mins-post...
HOT Updates vs Bottom-Up Index Deletion in Postgres 14
pganalyze.com/blog/5mins-post...
Негізгі бет Ғылым және технология HOT Updates and BRIN indexes in Postgres 16
Пікірлер: 3