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

Channel:
Subscribers:
42,400
Published on ● Video Link: https://www.youtube.com/watch?v=_IieyXzdmcM



Duration: 41:35
14 views
0


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.




Other Videos By Confreaks


2022-10-12PGConf NYC 2021 - How to improve PostgreSQL Monitoring and ... by Agustin Gallego, Charly Batista
2022-10-12PGConf NYC 2021 - Understanding of Jsonb Performance by Oleg Bartunov
2022-10-12PGConf NYC 2021 - Managing PostgreSQL changes for the Agile DBA by Ryan Booz
2022-10-12PGConf NYC 2021 - Do it in SQL: pgbouncer_wrapper by David Fetter
2022-10-12PGConf NYC 2021 - Understanding and Reducing Application Contention by Simon Riggs
2022-10-12PGConf NYC 2021 - Typo Positive: When Collection Doesn't Get You What You Need by Renee Phillips
2022-10-12PGConf NYC 2021 - Will Postgres Live Forever? by Bruce Momjian
2022-10-12PGConf NYC 2021 - Advanced Postgres Schema Design... by Sehrope Sarkuni
2022-10-12PGConf NYC 2021 - A look at the Elephants Trunk: PostgreSQL 14 by Magnus Hagander
2022-10-12PGConf NYC 2021 - So You Inherited A Database by Corey Huinker
2022-10-12PGConf NYC 2021 - Advanced Int - Bigint Conversions by Robert Treat
2022-10-12PGConf NYC 2021 - PostgreSQL Query Performance Insights by Hamid Quddus Akhtar
2022-10-12PGConf NYC 2021 - Advanced Data Types in PostgreSQL by Andreas Scherbaum
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Speaking and Community Involvement for the Introvert by Pat Wright
2022-10-12PGConf NYC 2021 - Get Your Insecure PostgreSQL Passwords to SCRAM! by Jonathan S. Katz
2022-10-12PGConf NYC 2021 - NORM: No ORM Framework by Henrietta Dombrovskaya
2022-10-12PGConf NYC 2021 - Navigate Postgres Cloud Paths: Kubernetes, IaaS, or DbaaS by Marc Linster
2022-10-12PGConf NYC 2021 - How we made PG Fitter, Happier, More Productive by Andrew Atkinson
2022-10-12PGConf NYC 2021 - War Stories: Fighting the PostreSQL Support Trenches by Hans Jurgen
2022-10-12PGConf NYC 2021 - Flexible Indexing with Postgres by Bruce Momjian



Tags:
PostgreSQL
PGConf
Postgres