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.