Postgres@CERN - PostgreSQL Meetup at CERN - January 17th

Contribution List

8. Welcome and Opening

Laetitia Avrot, Franck Pachot

1/17/20, 2:00 PM

4. Gülçin Yıldırım - Evolution of Fault Tolerance in PostgreSQL

Gülçin Yıldırım

1/17/20, 2:15 PM

PostgreSQL is an awesome project and it evolves at an amazing rate. The talk will focus on the evolution of fault tolerance capabilities in PostgreSQL throughout its versions.

The talk will cover the topics listed below:
• Robustness of PostgreSQL
• PostgreSQL Fault Tolerance: WAL
• Transaction? Commit? Checkpoint?
• Replication Methods for PostgreSQL
• Physical Replication
• Standby...

1. Pavlo Golub - Professional PostgreSQL scheduling made easy

Pavlo Golub

1/17/20, 3:10 PM

The talk firstly introduces all appropriate levels of
database scheduling and then focuses on PostgreSQL and the means it
provides. The talk explains the meaning and importance of key
approaches. Postgres community has already developed several tools in
that area. Some popular common options will be highlighted together
with the problems that different scheduling approaches have....

2. Anastasia Lubennikova - Advanced PostgreSQL Backup and Recovery methods

Anastasia Lubennikova

1/17/20, 4:15 PM

As database size and complexity grow, DBAs may face the fact that the functionality offered by built-in tools
such as pg_dump and pg_basebackup is insufficient, and more flexibility is required to create reliable backups
and manage them.
This talk cover various advanced topics in the area of backups:
- incremental backups;
- archive management;
- backup validation;
- retention...

5. Vik Fearing - Advent of Code Using PostgreSQL

Vik Fearing

1/17/20, 5:10 PM

SQL is a rich language and can do more than you think. The short talk will show some techniques I learned by trying to solve general-purpose programming challenges using just a single query.

7. Romuald Thion - PostgreSQL at the university : some lessons learned

Romuald Thion

1/17/20, 5:35 PM

The computer science department of Université Claude Bernard Lyon 1 (France) has progressively introduced PostgreSQL in its courses since 2018.
Now, more than 400 students enrolled from second to fifth year use PostgreSQL in databases, web, security or system administration courses.
In this talk, we will briefly showcase our platform and give feedback on some common pitfalls students and...

6. Oleg Bartunov - All You Need Is Postgres !

Oleg Bartunov

1/17/20, 6:00 PM

Closing keynote