Postgres@CERN - PostgreSQL Meetup at CERN - January 13th
Friday 13 January 2023 -
13:30
Monday 9 January 2023
Tuesday 10 January 2023
Wednesday 11 January 2023
Thursday 12 January 2023
Friday 13 January 2023
13:30
Arrival at CERN reception
Arrival at CERN reception
13:30 - 13:50
Room: 503/1-001 - Council Chamber
14:00
Introduction
-
Eva Dafonte Perez
(
CERN
)
Introduction
Eva Dafonte Perez
(
CERN
)
14:00 - 14:25
Room: 503/1-001 - Council Chamber
14:30
Citus Data: The database distributed without complex
-
Cédric Villemain
(
Data Bene
)
Citus Data: The database distributed without complex
Cédric Villemain
(
Data Bene
)
14:30 - 15:20
Room: 503/1-001 - Council Chamber
Interested in the issues of High Availability and Quality of Service, he contributes to the various projects he uses and promotes. Citus Data is an extension of PostgreSQL that extends this famous relational database server to design distributed databases. Distributed calculations, multi-tenant with isolated customers, resharding without downtime, ... If this already sounds familiar, you'll learn more. And if not, you will finally know what a multi-tenant architecture is... And how easy sharding is!
15:20
Break
Break
15:20 - 15:50
Room: 503/1-001 - Council Chamber
15:50
Patroni + pgBackRest : Hero + Hero = Superhero?
-
Julia Gugel
(
DBI Services
)
Patroni + pgBackRest : Hero + Hero = Superhero?
Julia Gugel
(
DBI Services
)
15:50 - 16:30
Room: 503/1-001 - Council Chamber
The first hero gives you high availability and reliability. The second hero gives you disaster recovery and recovery from human errors. What happens if we combine those heroes to get a kind of superhero? We're talking about Patroni and pgBackRest here: Can/will they integrate? We'll see that live, reproducible for you with easy step by step instructions.
16:30
Break
Break
16:30 - 16:50
Room: 503/1-001 - Council Chamber
16:50
PostgreSQL: The Time-Series Database You Actually Want
-
Chris Engelbert
(
Timescale
)
PostgreSQL: The Time-Series Database You Actually Want
Chris Engelbert
(
Timescale
)
16:50 - 17:30
Room: 503/1-001 - Council Chamber
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!
17:35
YugabyteDB: Distributed SQL Open-Source PostgreSQL-compatible
-
Franck Pachot
(
Yugabyte
)
YugabyteDB: Distributed SQL Open-Source PostgreSQL-compatible
Franck Pachot
(
Yugabyte
)
17:35 - 17:55
Room: 503/1-001 - Council Chamber
A short introduction to Distributed SQL databases, to scale-out OLTP with cloud-native High Availability, Elasticity, and geo-distribution
18:00
Apéro
Apéro
18:00 - 19:00
Room: 503/1-001 - Council Chamber