Operational hazards of managing PostgreSQL DBs over 100TB
Presented by:
Teresa Lopes
Teresa has worked with databases for more than 8 years. After several years as an Oracle DBA, she transitioned to PostgreSQL and never looked back! Extensibility and the Community are the two main aspects she finds fascinating about PostgreSQL. Teresa is also part of the PGDay Lowlands organization.
Teresa started her career far away from databases, as a Civil Engineer. So, if you've always wanted to know how tunnels and bridges are built, just ask!
In her free time, Teresa enjoys spending time outdoors (mainly admiring rocks), hiking, and cooking.
No video of the event yet, sorry!
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!).
- Date:
- Duration:
- 45 min
- Room:
- Conference:
- PGConf India, 2026
- Language:
- Track:
- Case Study
- Difficulty:
- Medium