# Pavlo Golub - Professional PostgreSQL scheduling made easy

- Institution: CERN
- Department: Visitor badges
- Speaker: Pavlo Golub,
- Year: 2020
- Language: English
- Source: [CERN](https://videos.cern.ch/record/3010385)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Teens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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..

0:00:00 Slide 1

0:00:29 Slide 2

0:00:41 Slide 3

0:00:52 Slide 4

0:00:59 Slide 5

0:01:08 Slide 6

0:02:17 Slide 7

0:02:44 Slide 8

0:02:55 Slide 9

0:03:00 Slide 10

0:03:33 Slide 11

0:04:18 Slide 12

0:04:52 Slide 13

0:05:17 Slide 14

0:05:50 Slide 15

0:06:57 Slide 16

0:07:36 Slide 17

0:08:53 Slide 18

0:10:29 Slide 19

0:13:10 Slide 20

0:15:46 Slide 21

0:16:50 Slide 22

0:17:36 Slide 23

0:20:22 Slide 24

0:23:58 Slide 25

0:25:16 Slide 26

0:26:11 Slide 27

0:29:25 Slide 28

0:29:29 Slide 29

0:30:30 Slide 30

0:30:39 Slide 31

0:30:51 Slide 32

0:31:04 Slide 33

0:31:09 Slide 34

0:33:15 Slide 35

0:33:29 Slide 36

0:33:35 Slide 37

0:33:42 Slide 38

0:33:50 Slide 39

0:33:55 Slide 40

0:34:05 Slide 41

0:34:09 Slide 42

0:34:13 Slide 43

0:34:18 Slide 44

0:34:22 Slide 45

0:34:32 Slide 46

0:34:36 Slide 47

0:34:40 Slide 48

0:34:54 Slide 49

0:35:11 Slide 50

0:35:16 Slide 51

0:35:40 Slide 52

0:35:46 Slide 53

0:36:15 Slide 54

0:36:19 Slide 55

0:36:44 Slide 56

0:36:48 Slide 57

0:36:52 Slide 58

0:37:24 Slide 59

0:38:05 Slide 60

0:38:28 Slide 61

0:38:35 Slide 62

0:39:05 Slide 63

0:39:12 Slide 64

0:39:19 Slide 65…

## Lectures

1. [Pavlo Golub - Professional PostgreSQL scheduling made easy](https://invisiblenetwork.ai/learn/cern/3010385/46bab5301184), 48 min (CERN's player)