התחל במצב לא מקוון עם האפליקציה Player FM !
Transaction ID wraparound
Manage episode 351808444 series 3369151
Here are links to a few things we mentioned:
- The Internals of PostgreSQL chapter 5 (book by Hironobu SUZUKI)
- PostgreSQL 14 internals chapter 7 (book by Egor Rogov)
- Transaction ID Wraparound (blog post from Sentry)
- What We Learned from the Recent Mandrill Outage (blog post from Mailchimp)
- How to simulate transaction ID wraparound (blog post by Prashant Dixit)
- Add 64-bit XIDs into PostgreSQL 16 (commitfest entry)
- Partitioning (docs)
- Consider using VACUUM’s INDEX_CLEANUP option (tweet by Peter Geoghan)
- Add wraparound failsafe to VACUUM (commit)
- Do you vacuum everyday? (talk by Hannu Krosing)
- Multixacts wraparound monitoring (mailing list thread)
- Subtransactions Considered Harmful (blog post by Nikolay)
- Buffer management in PostgreSQL (talk by Alexander Korotkov)
- OrioleDB
- pageinspect
- pg_hexedit
- pg_visibility
- Visibility Map (docs)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
145 פרקים
Manage episode 351808444 series 3369151
Here are links to a few things we mentioned:
- The Internals of PostgreSQL chapter 5 (book by Hironobu SUZUKI)
- PostgreSQL 14 internals chapter 7 (book by Egor Rogov)
- Transaction ID Wraparound (blog post from Sentry)
- What We Learned from the Recent Mandrill Outage (blog post from Mailchimp)
- How to simulate transaction ID wraparound (blog post by Prashant Dixit)
- Add 64-bit XIDs into PostgreSQL 16 (commitfest entry)
- Partitioning (docs)
- Consider using VACUUM’s INDEX_CLEANUP option (tweet by Peter Geoghan)
- Add wraparound failsafe to VACUUM (commit)
- Do you vacuum everyday? (talk by Hannu Krosing)
- Multixacts wraparound monitoring (mailing list thread)
- Subtransactions Considered Harmful (blog post by Nikolay)
- Buffer management in PostgreSQL (talk by Alexander Korotkov)
- OrioleDB
- pageinspect
- pg_hexedit
- pg_visibility
- Visibility Map (docs)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
145 פרקים
כל הפרקים
×ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.