Transaction ID wraparound | Postgres.FM 027 | #PostgreSQL #Postgres podcast

Michael and Nikolay discuss transaction ID wraparound — what it is, and some ideas to minimise the risk of it ever happening to you! Here are links to a few things we mentioned: The Internals of PostgreSQL chapter 5 (book by Hironobu SUZUKI) https://www.interdb.jp/pg/pgsql05.html PostgreSQL 14 internals chapter 7 (book by Egor Rogov) https://edu.postgrespro.com/postgresq... Transaction ID Wraparound (blog post from Sentry) https://blog.sentry.io/2015/07/23/tra... What We Learned from the Recent Mandrill Outage (blog post from Mailchimp) https://mailchimp.com/en-gb/what-we-l... How to simulate transaction ID wraparound (blog post by Prashant Dixit) https://fatdba.com/2021/07/20/how-to-... Add 64-bit XIDs into PostgreSQL 16 (commitfest entry) https://commitfest.postgresql.org/41/... Partitioning (docs) https://www.postgresql.org/docs/curre... Consider using VACUUM’s INDEX_CLEANUP option in an emergency (tweet by Peter Geoghan)   / 1350259956117692425   Add wraparound failsafe to VACUUM (commit) https://github.com/postgres/postgres/... Do you vacuum everyday? (talk by Hannu Krosing)    • Hannu Krosing. Do you vacuum #PostgreSQL e...   Multixacts wraparound monitoring (mailing list thread) https://www.postgresql.org/message-id... Subtransactions Considered Harmful (blog post by Nikolay) https://postgres.ai/blog/20210831-pos... Buffer management in PostgreSQL (talk by Alexander Korotkov)    • Buffer management in PostgreSQL – Alexande...   OrioleDB https://github.com/orioledb/orioledb pageinspect https://www.postgresql.org/docs/curre... pg_hexedit https://github.com/petergeoghegan/pg_... pg_visibility https://www.postgresql.org/docs/curre... Visibility Map (docs) https://www.postgresql.org/docs/curre... ------------- 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.