News for hackers. Stuff that matters.
Re:Transaction ID Wraparound in Postgres by mangeletti on Thursday July 23, 2015 @11:01PM (#9939906)
Wow, this was a great read. Fellow Djangonaut / Pythonista here, and I really enjoy reading David's blog posts. I've learned from and been inspired by him since what seems like early 2011 or so. I also didn't know Armin Ronacher worked for Sentry (re: his comment herein). What a cool company.

Also, great call on truncating that table. I've witnessed situations where nobody has been willing to accept loss, snd the result is a conference call that lasts until 4am and a lot of angry customers.

Re:Transaction ID Wraparound in Postgres by JimNasby on Friday July 24, 2015 @05:04PM (#9945188)
FWIW, I got the impression that they didn't truncate the table, but just forced an update to it's relfrozenxid to advance the freeze age and allow the database to restart. That means there's a risk that rows that were currently visible would suddenly vanish as the XID advanced and their xmin became "the future". Eventually record of those commits would vanish and presumably the rows would then get removed (though I'm not sure on that without checking the code).