17 January 2020
CERN
Europe/Zurich timezone
There is a live webcast for this event.
Slides and Recording is available from the Timetable

Pavlo Golub - Professional PostgreSQL scheduling made easy

17 Jan 2020, 15:10
50m
503/1-001 - Council Chamber (CERN)

503/1-001 - Council Chamber

CERN

162
Show room on map

Speaker

Pavlo Golub

Description

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. To
overcome some of these problems a new Open Source tool from Cybertec,
called pg_timetable, is introduced and explained in detail. It offers
the simplest possibly entry into exhaustive Postgres scheduling
combined with system tasks (cron on steroids). Also discussed will be
advanced topics like transaction support and cross-platform tasks.

Pavlo Golub is a PostgreSQL expert and developer at Cybertec. Pavlo is working with PG for 17 years.

Presentation materials