# A new PostgreSQL backend for CERN Tape Archive scheduling for LHC Run 4

- Institution: CERN
- Taught by: Jaroslav Guenther, Konstantina Skovola
- Year: 2026
- Language: English
- Source: [CERN](https://videos.cern.ch/record/3020777)
- 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)

The CERN Tape Archive (CTA) stores over one exabyte of scientific data. To orchestrate storage operations (archival) and access operations (retrieval), the CTA Scheduler coordinates concurrent data movements across hundreds of tape servers, relying on a Scheduler Database (Scheduler DB) to manage the metadata of the in-flight requests. The existing objectstore-based design of the CTA Scheduler DB is a complex transactional management system. This talk presents the development of a new PostgreSQL-based backend for the CTA Scheduler as an off-the-shelf solution which simplifies implementation and is expected to significantly reduce future development and operational costs. We describe the implementation of all main CTA workflows and explain how PostgreSQL addresses the limitations of the objectstore-based system, providing the foundation for the tenfold increase in data throughput expected during LHC Run 4.

0:00:00 Slide 1

0:00:59 Slide 2

0:01:45 Slide 3

0:03:14 Slide 4

0:04:02 Slide 5

0:05:30 Slide 6

0:06:15 Slide 7

0:07:30 Slide 8

0:08:31 Slide 9

0:09:09 Slide 10

0:09:53 Slide 11

0:11:13 Slide 12

0:11:45 Slide 13

0:12:06 Slide 14

0:12:45 Slide 15

0:13:05 Slide 16

0:13:20 Slide 17

0:14:01 Slide 18

0:14:57 Slide 19

0:15:41 Slide 20

0:16:00 Slide 21

0:16:26 Slide 22

0:16:50 Slide 23

0:17:06 Slide 24

0:17:37 Slide 25

0:18:21 Slide 26

0:18:55 Slide 27

0:19:56 Slide 28

0:20:10 Slide 29

0:21:13 Slide 30

0:22:27 Slide 31

0:22:48 Slide 32

0:23:01 Slide 33

0:23:13 Slide 34

0:23:31 Slide 35

0:24:05 Slide 36

0:24:23 Slide 37

0:24:52 Slide 38

0:25:13 Slide 39

0:26:18 Slide 40r>

## Lectures

1. [A new PostgreSQL backend for CERN Tape Archive scheduling for LHC Run 4](https://invisiblenetwork.ai/learn/cern/3020777/478d1f644f83), 29 min (CERN's player)