Episode

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

Citus Con: An Event for Postgres

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.

Chapters

  • 00:00 - Introduction
  • 01:45 - Three data types
  • 05:25 - Avoiding the problem
  • 08:35 - How can I get a heads-up on the problem
  • 13:45 - Dealing with overflows in production
  • 19:57 - Other problems to consider

Connect