HOT updates | Postgres.FM 020 |
Michael and Nikolay discuss Heap-Only Tuple (HOT) updates — what they are, the benefits, and things you can do to optimize for them.
Here are links to a few things we mentioned:
Heap-only tuple updates (docs): https://www.postgresql.org/docs/curre...
README file (source code): https://github.com/postgres/postgres/...
Heap Only Tuple chapter (Internals of PostgreSQL by Hironobu SUZUKI) https://www.interdb.jp/pg/pgsql07.html
How partial, covering, and multicolumn indexes may slow down UPDATEs (blog post by Nikolay) https://postgres.ai/blog/20211029-how...
Why Uber switched from Postgres to MySQL (blog post) https://www.uber.com/en-GB/blog/postg...
Fighting write amplification with HOT updates (Adyen blog post) https://www.adyen.com/knowledge-hub/p...
HOT Updates vs Bottom-Up Index Deletion (video by Lukas Fittl from pganalyze) • 5mins of Postgres E14: HOT Updates vs Bott...
Reduced Bloat with Bottom-Up Deletion (blog post by Hamid Akthar from Percona) https://www.percona.com/blog/postgres...
What is fillfactor and how does it affect performance? (blog post by Kaarel Moppel from Cybertec) https://www.cybertec-postgresql.com/e...
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
Nikolay Samokhvalov, founder of Postgres.ai
Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.