Schedule - PGConf.DE 2025
Operational hazards of managing PostgreSQL DBs over 100TB
Date: 2025-05-09
Time: 09:00–09:45
Room: Berlin 1
Level: Intermediate
How do you backup (and restore) a +100TB database? Well, maybe you don't.
In this talk I will share the singularities I encountered when managing huge PostgreSQL databases, topics like backups, high availability challenges, how to keep vacuum under control...
When reading blog articles, the best practices, the "how to" guides, things seem straightforward, but when you start bending PostgreSQL limits, you will end up needing to question the most fundamental assumptions about how PostgreSQL works.
Over the last years, my team has been exploring the boundaries of what PostgreSQL can do and today I will share our findings with you (at least the ones I can!).