Learn · CERN

Talk48 min

Operational hazards of managing PostgreSQL DBs over 100TB

Teresa Lopes · CERN

Watch At CERN

About

Picture this: you start a new role, eager to learn and contribute with your ideas! Your next task is to get familiar with the database setup, and then you start encountering these massive PostgreSQL databases — 100TB, 200TB, 300TB...

And you start questioning yourself: how do you backup (and restore) a +100TB database? And how about HA? Performance? Vacuum?

It should work the same way as for a 100GB database, right? Well, maybe not exactly.

Blog posts and best practice guides make PostgreSQL seem straightforward—until you push it to its limits. At extreme scale, you will find yourself questioning the most fundamental assumptions about how PostgreSQL works.

Over the last years, my team at Adyen 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!).

0:00:00 Slide 1

0:00:57 Slide 2

0:01:33 Slide 3

0:02:17 Slide 4

0:02:44 Slide 5

0:03:04 Slide 6

0:03:31 Slide 7

The talk

  1. Operational hazards of managing PostgreSQL DBs over 100TB 2026-02-06 · 48 min · CERN's player

Credits and licence

Institution
CERN
Speaker
Teresa Lopes
Year
2026
Language
English
Source
CERN
Licence
CERN, as CERN states it. CERN's terms
Attribution
© CERN. CERN provides its audiovisual media free of charge for educational and informational use, credited to CERN; this lecture is shown in CERN's own player.
Who can watch
CERN gives no rating. Invisible Network shows it to Teens profiles and older, judged from what the source says about it. How courses are placed