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

*Find the article on our blog here:* https://pganalyze.com/blog/5mins-postgres-performance-HOT-updates-CLUSTER

In E72 of “5mins of Postgres” we’re gonna talk about how to use HOT updates to use CLUSTER more effectively, and how we can utilize CLUSTER to get the last bit of performance out of an index scan.

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

*Use HOT, so CLUSTER won’t rot in PostgreSQL*
https://www.cybertec-postgresql.com/en/use-hot-so-cluster-wont-rot-postgresql/

*The Basics of Postgres Query Planning*
https://pganalyze.com/docs/explain/basics-of-postgres-query-planning

*5mins of Postgres E14: HOT Updates vs Bottom-Up Index Deletion in Postgres 14*
https://pganalyze.com/blog/5mins-postgres-hot-updates-vs-bottom-up-index-deletion

*5mins of Postgres E40: How to debug slow Postgres UPDATEs and bloated tables with auto_explain & page_inspect*
https://pganalyze.com/blog/5mins-postgres-debug-UPDATE-bloated-tables-auto-explain-pageinspect

*eBook: Effective Indexing in Postgres*
https://pganalyze.com/ebooks/postgres-indexing

*Webinar re-run: Webinar: How To Reason About Indexing Your Postgres Database*
https://pganalyze.com/webinars/how-to-reason-about-indexing-your-postgres-database