Level: Intermediate
Upgrading a 200TB PostgreSQL database? Let's just say it's an adventure! In this session, I'll walk you through a real-world upgrade of a massive PostgreSQL setup. It wasn't always smooth sailing, and we definitely learned some hard lessons along the way.
We'll dive into the nitty-gritty of moving from PostgreSQL 13 to 17, focusing on how we kept downtime to a minimum – because 24/7 is the name of the game, right? Data integrity was paramount, and we'll share the strategies we used to ensure everything stayed rock solid. Expect to hear about the real-world challenges we wrestled with, from wrangling huge data migrations to fine-tuning performance and battling extension compatibility.
Come to this session to get the inside scoop on: * Planning a PostgreSQL upgrade when "large-scale" is an understatement. * Practical, battle-tested techniques for cutting downtime. * Performance tricks and optimization for truly massive databases. * Testing and validation methods that actually work under pressure. * The key takeaways – the stuff we wish we knew before we started – that you can use for your own upgrades, no matter the size.
If you're a DBA, architect, or anyone who wrestles with keeping large PostgreSQL environments running smoothly through upgrades, this session is for you. Especially if "large datasets" and "always-on" are part of your daily vocabulary.