# Operational hazards of managing PostgreSQL DBs over 100TB

- Institution: CERN
- Speaker: Teresa Lopes
- Year: 2026
- Language: English
- Source: [CERN](https://videos.cern.ch/record/3020776)
- Licence: [CERN](https://copyright.web.cern)
- Who can watch: Teens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

0:03:52 Slide 8

0:04:27 Slide 9

0:05:03 Slide 10

0:05:42 Slide 11

0:06:10 Slide 12

0:06:23 Slide 13

0:06:34 Slide 14

0:07:05 Slide 15

0:07:58 Slide 16

0:08:43 Slide 17

0:09:17 Slide 18

0:10:01 Slide 19

0:10:16 Slide 20

0:10:40 Slide 21

0:11:26 Slide 22

0:12:19 Slide 23

0:12:40 Slide 24

0:13:50 Slide 25

0:14:39 Slide 26

0:15:20 Slide 27

0:16:36 Slide 28

0:17:39 Slide 29

0:18:01 Slide 30

0:18:22 Slide 31

0:18:43 Slide 32

0:19:51 Slide 33

0:20:13 Slide 34

0:20:26 Slide 35

0:20:39 Slide 36

0:20:51 Slide 37

0:21:02 Slide 38

0:21:35 Slide 39

0:21:52 Slide 40

0:22:40 Slide 41

0:22:55 Slide 42

0:24:32 Slide 43

0:25:08 Slide 44

0:27:37 Slide 45

0:28:19 Slide 46

0:29:10 Slide 47

0:29:31 Slide 48

0:29:48 Slide 49

0:30:48 Slide 50

0:32:28 Slide 51

0:32:51 Slide 52

0:34:58 Slide 53

0:35:28 Slide 54

0:35:56 Slide 55

0:36:23 Slide 56

0:37:57 Slide 57

0:38:51 Slide 58

0:39:47 Slide 59

0:40:51 Slide 60

0:41:03 Slide 61

0:41:21 Slide 62r>

## Lectures

1. [Operational hazards of managing PostgreSQL DBs over 100TB](https://invisiblenetwork.ai/learn/cern/3020776/52bd9fd02396), 48 min (CERN's player)