Operational hazards of managing PostgreSQL DBs over 100TB
Tuesday, September 08 at 10:00–10:50
Auditorium
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, 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 on 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!).
