3 ms·
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
by mangeletti 11y ago
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.
- JimNasby 11y agoFWIW, 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).