--- title: "Job scheduler pg_timetable hits 2.0" publication: "Postgres Weekly" issue: 348 published_at: "2020-03-25" canonical_url: "https://postgresweekly.com/issues/348" --- This week's Postgres news, views, and tools. #348 — March 25, 2020 [Read on the Web](https://postgresweekly.com/issues/348) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/xcwquklpimyw5aoi1ums.jpg)](https://www.cybertec-postgresql.com/en/pg_timetable-advanced-postgresql-cron-like-scheduler-released/) [pg_timetable 2.0: The Advanced Postgres Cron-Like Job Scheduler](https://www.cybertec-postgresql.com/en/pg_timetable-advanced-postgresql-cron-like-scheduler-released/) — We only linked to version one a few months ago, but v2 of [pg_timetable](https://www.cybertec-postgresql.com/en/products/pg_timetable/) is here. Why should you care? You can now mark jobs as `@reboot` to run when pg_timetable restarts or use `@every` or `@after` to runs job at intervals. Pavlo Golub [PGCon 2020 To Be Online, Not in Person](https://lists.pgcon.org/pipermail/pgcon-announce/2020-March/000169.html) — Given developments in the past week, this is perhaps no surprise, but it’ll be interesting to see what they come up with. _“Details will soon follow.”_ Dan Langille [![\](https://copm.s3.amazonaws.com/27b50531.png)](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklyPrimary) [Free eBook: How to Get a 3x Performance Improvement on Your Postgres Database](https://pganalyze.com/ebooks/optimizing-postgres-query-performance?utm_source=PostgresWeeklyPrimary) — Learn our best practices for optimizing Postgres query performance for customers like Atlassian and how to reduce data loaded from disk by 500x. pganalyze sponsor [PGSync: Sync Postgres Data Between Databases](https://github.com/ankane/pgsync) — Fast, aims to provide good security, and you can sync partial tables or groups of tables. The README shows off some interesting examples. Written in Ruby. Andrew Kane [A Look at Embedded SQL in C for Postgres with `ecpg`](https://www.cybertec-postgresql.com/en/embedded-sql-in-c-for-postgresql-with-ecpg-blog/) — A quick look at what is generously called a ‘vintage technology’ (i.e. old fashioned) where you write SQL directly inline within, say, a C program and compile it to handle all the database work behind the scenes. I’d never seen this style of programming before, so it’s interesting even if I’ll never use it. Laurenz Albe [Announcing an APT Package Archive for Postgres](http://www.df7cb.de/blog/2020/apt-archive.postgresql.org.html) — [apt-archive.postgresql.org](https://apt-archive.postgresql.org/) is a new official archive of old Postgres packages covering versions back to 8.2.23 and Debian and Ubuntu versions back to around 2010. Christoph Berg [Troubleshoot Postgres Performance with Datadog](https://www.datadoghq.com/dg/logs/postgresql/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyLogsS) — Collect Postgres metrics and correlate them with related traces and logs for fast troubleshooting. Optimize performance with Datadog. Datadog sponsor [The Big Difference Between `HAVING` and `WHERE` Clauses](https://www.postgresql.org/docs/9.3/tutorial-agg.html) — This is from the docs, but I saw it doing the rounds as an article that someone merely copied and pasted elsewhere (!) and found it useful nonetheless. In short, `WHERE` selects input rows before groups and aggregates are computed whereas `HAVING` selects group rows _after_ groups and aggregates are computed. PostgreSQL Documentation [Building and Testing a REST API in Go(lang) with Gorilla Mux and Postgres](https://semaphoreci.com/community/tutorials/building-and-testing-a-rest-api-in-go-with-gorilla-mux-and-postgresql) — A thorough walkthrough of how to build a simple and well-tested REST API backed by a Postgres database using [Gorilla/Mux](https://github.com/gorilla/mux), a popular Go request router. Kulshekhar Kabra 🗓**Upcoming Events** **Note:** Due to the disruption caused by the COVID-19 outbreak, it seems _very_ likely most in-person events in the near future will be postponed or cancelled, so please check the status of any events you are considering attending or have already booked. - [Swiss PGDay 2020](http://www.pgday.ch/2020/) (June 18-19 in Switzerland) — _This event has now been cancelled with a new date in 2021 to follow_. - [Postgres Vision 2020](https://www.postgresvision.com/) (June 22-24) — _This event was due to be held in Boston, MA but will now be a virtual event._ We'll update you on signing up to this later on. - [Postgres Ibiza 2020](https://pgibz.io/) (June 25-26 in Ibiza, Spain) — Seems like this two day conference on the island of Ibiza is hoping to go ahead at time of writing, but I'd keep checking in. - [PGCon 2020 to now be an online event.](https://lists.pgcon.org/pipermail/pgcon-announce/2020-March/000169.html) More details to follow on this one too. ℹ️ If you are running any _virtual_ events such as webinars, Twitch streams, and similar online get-togethers please do let us know so we can feature them here. Curated by [Cooperpress](https://cooperpress.com/), [Peter Cooper](https://twitter.com/peterc), and [Craig Kerstiens](https://twitter.com/craigkerstiens). [Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom