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.

► 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:

📌 Let’s connect:

#CitusCon #PostgreSQL #Database