Transaction ID wraparound | Postgres.FM 027 |
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 #Postgre...
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 – Ale...
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.