PGConf NYC 2021 - Advanced Int - Bigint Conversions by Robert Treat

Advanced Int-Bigint Conversions by Robert Treat It's 2021 and we're still dealing with integer overflow. Just a few months ago I came within 24 hours of watching one of the worlds tech unicorns come to a stop due because of a possible overflow problem. In this talk I'll talk about the nature of the problem, why we still see it today, and cover many of the various options to work your way through a pending int overflow. I also talk about some of the more advanced work we did to make sure our bases were covered, and walk through techniques you can use to keep from hitting the wall.