Postgres FM

Transaction ID wraparound


Listen Later

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 elephant artwork
...more
View all episodesView all episodes
Download on the App Store

Postgres FMBy Nikolay Samokhvalov and Michael Christofides

  • 4.7
  • 4.7
  • 4.7
  • 4.7
  • 4.7

4.7

21 ratings


More shows like Postgres FM

View all
Acquired by Ben Gilbert and David Rosenthal

Acquired

4,764 Listeners

Software Engineering Radio - the podcast for professional software developers by team@se-radio.net (SE-Radio Team)

Software Engineering Radio - the podcast for professional software developers

274 Listeners

The Changelog: Software Development, Open Source by Changelog Media

The Changelog: Software Development, Open Source

288 Listeners

The a16z Show by Andreessen Horowitz

The a16z Show

1,096 Listeners

Software Engineering Daily by Software Engineering Daily

Software Engineering Daily

625 Listeners

Talk Python To Me by Michael Kennedy

Talk Python To Me

580 Listeners

Thoughtworks Technology Podcast by Thoughtworks

Thoughtworks Technology Podcast

43 Listeners

Python Bytes by Michael Kennedy and Brian Okken

Python Bytes

214 Listeners

Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

Syntax - Tasty Web Development Treats

989 Listeners

CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

CoRecursive: Coding Stories

188 Listeners

Scaling Postgres by Creston Jamison

Scaling Postgres

12 Listeners

The Stack Overflow Podcast by The Stack Overflow Podcast

The Stack Overflow Podcast

62 Listeners

The Real Python Podcast by Real Python

The Real Python Podcast

141 Listeners

Oxide and Friends by Oxide Computer Company

Oxide and Friends

66 Listeners

The Pragmatic Engineer by Gergely Orosz

The Pragmatic Engineer

71 Listeners