Advanced INT to BIGINT Conversions | Citus Con: An Event for Postgres 2022

Video of a talk given by Postgres expert Robert Treat at Citus Con: An Event for Postgres. Abstract: Well folks, it is now 2022 and we are still dealing with integer overflow problems in PostgreSQL. Just a few months ago I came within 24 hours of watching one of the worlds tech unicorns come to a stop because of a possible overflow. We all know what the problem is but what we need to know is how to avoid it, in production, at scale, when it is already too late. So join me as I discuss some of the more advanced work we did to get out of the mess in front of us and help ensure we didn't see problems elsewhere in the chain; including dealing with other Postgres data types and on-the-fly database schema change needs as well.

Having spent his early years building data-intensive, real-time systems within the Fortune 500, Robert now works as a Technical Fellow for Instaclustr. A published author and speaker at conferences worldwide, Robert is a recognized industry expert on topics including databases, DevOps, and Open Source. He occasionally blogs at https://xzilla.net.

► Video bookmarks:
⏩ 00:00 Introduction
⏩ 01:45 SMALLINT, BIGINT, INTEGER
⏩ 05:25 Avoiding the 'INTEGER' problem
⏩ 13:45 Dealing with overflows in production
⏩ 19:57 Other problems to consider

✅ Learn more:
Watch more Citus Con talks: https://aka.ms/cituscon-playlist

📕 Everything you need to know about Citus Con: An Event for Postgres can be found at: https://aka.ms/cituscon

📌 Let’s connect:
Twitter – @CitusCon,   / cituscon  

#CitusCon #PostgreSQL #Database