Learn · CERN

Talk44 min

PostgreSQL: The Time-Series Database You Actually Want

Chris Engelbert · CERN

Watch At CERN

About

Time-series data, or data being associated with its respective time of occurrence, is everywhere. From the obvious cases, such as metrics, observability, IoT data, all the way to logs, invoicing, or payment records.

While storing some of these in relational databases is standard practice, people often reach for specific time-series databases when volume gets high. But imagine if you could have all of them in the same database: PostgreSQL.

Join me for this session to learn more about the different types of time-series data and have a look at the naive, the native, and the scalable approaches to storing it in PostgreSQL. We'll contrast their usability and performance characteristics and show you why Postgres is the only database you need!.

0:00:00 Slide 1

0:01:01 Slide 2

0:05:46 Slide 3

0:07:19 Slide 4

0:12:41 Slide 5

0:17:41 Slide 6

0:19:37 Slide 7

0:22:14 Slide 8

0:27:11 Slide 9

The talk

  1. PostgreSQL: The Time-Series Database You Actually Want 2023-01-13 · 44 min · CERN's player

Credits and licence

Institution
CERN
Department
Visitor badges
Speaker
Chris Engelbert
Year
2023
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