Скачать с ютуб Transaction ID wraparound | Postgres.FM 027 | в хорошем качестве

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.