--- title: "There's a new powerful Postgres job scheduler in town" publication: "Postgres Weekly" issue: 340 published_at: "2020-01-29" canonical_url: "https://postgresweekly.com/issues/340" --- This week's Postgres news, views, and tools. #340 — January 29, 2020 [Read on the Web](https://postgresweekly.com/issues/340) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/xxm49ug3ihgxbnuxapku.jpg)](https://postgresqlco.nf/en/doc/param/) [PostgresqlCO.NF: Postgres Config Settings for Humans](https://postgresqlco.nf/en/doc/param/) — _“Our mission is to help you tune and optimize your PostgreSQL configuration.”_ And this is certainly a good place to start doing that as this epic resource lets you dig into all the different settings Postgres provides, explains what they’re about, and links to further resources. Here’s [the story](https://www.ongres.com/blog/postgresqlconf-configuration-for-humans/) behind its creation. OnGres [pg_timetable: Advanced Postgres Job Scheduling](https://www.cybertec-postgresql.com/en/pg_timetable-advanced-postgresql-job-scheduling/) — A new job scheduler for Postgres implemented from scratch in Go that’s not just about running single queries at set times but that can also execute more complicated sequences of operations. [GitHub repo.](https://github.com/cybertec-postgresql/pg_timetable) Hans-Jürgen Schönig [![\](https://copm.s3.amazonaws.com/23a52e43.png)](https://pgexperts.com/) [Your Data Is Your Business](https://pgexperts.com/) — PGX is a full-service database consultancy focused around PostgreSQL systems. Let us help you architect, build, troubleshoot and scale your PostgreSQL data systems on any platform or hosting environment. PostgreSQL Experts, Inc. sponsor [Which Tables Should Be Auto Vacuumed or Auto Analyzed?](https://www.depesz.com/2020/01/29/which-tables-should-be-auto-vacuumed-or-auto-analyzed/) — Hubert wanted a way to know _which_ tables were waiting for autovacuum to work on them. So he came up with this approach. Hubert depesz Lubaczewski [pgWikiDont: Check You're Not Doing Bad Things in Postgres](https://www.depesz.com/2020/01/28/dont-do-these-things-in-postgresql/) — We’ve linked to the [Don’t Do This (in Postgres)](https://wiki.postgresql.org/wiki/Don't_Do_This) wiki page a few times, but Hubert has come up with [pgWikiDont](https://gitlab.com/depesz/pgWikiDont), a way to check compliance with some of the tips. Hubert depesz Lubaczewski ▶['Nothing Compares To VACUUM': A Postgres Song](https://www.youtube.com/watch?v=2NxIngqq1y0) — A Postgres-themed cover of Sinead O’Connor’s _Nothing Compares to You_ but with a `[GRANT](https://www.postgresql.org/docs/9.0/sql-grant.html)` flavored twist. Gabriel Cafa [Migrating from Oracle to Postgres: Tips and Tricks](https://info.crunchydata.com/blog/migrating-from-oracle-to-postgresql-questions-and-considerations) — Covers a handful of common tripping points like checking for `NOT NULL` columns and the `GRANT` command, plus using [Orafce](https://github.com/orafce/orafce), an extension containing numerous compatibility functions to make an Oracle to Postgres transition smoother. Yorvi Arias [Introducing Backup Ninja - Simple & Secure Database Backups](https://backup.ninja/?utm_campaign=Backup_Ninja_Launch&utm_content=pg_weekly&utm_medium=Paid_Search&utm_source=banner) — A cost-effective SaaS service you can use to backup the most popular open source databases; locally or in the cloud. Backup Ninja sponsor [Understanding Prepared Transactions and Handling the Orphans](https://www.highgo.ca/2020/01/28/understanding-prepared-transactions-and-handling-the-orphans/?utm_source=rss&utm_medium=rss&utm_campaign=understanding-prepared-transactions-and-handling-the-orphans) — Prepared transactions _“require careful set up of the environment with a fall back notifier or cleanser that can easily ensure that these transactions are not taking up key resources unnecessarily”_ Hamid Akhtar [How To Deploy Postgres on OpenShift Backed by OpenShift Container Storage](https://blog.openshift.com/deploy-postgresql-in-openshift-backed-by-openshift-container-storage/) Sagy Volkov [Postgres 13 to Get GCD and LCM Functions](https://www.depesz.com/2020/01/28/waiting-for-postgresql-13-add-functions-gcd-and-lcm-for-integer-and-numeric-types/) — The `gcd` and `lcm` functions will let you get the greatest common divisor and least common multiple for pairs of integers respectively. Hubert depesz Lubaczewski [pgagroal: High-Performance Connection Pool for Postgres](https://github.com/agroal/pgagroal) — No, I’m not sure how to pronounce it either, but it’s written in C, looks small and easy to run, and claims to be [faster than 3 other common options](https://github.com/agroal/pgagroal/blob/master/doc/PERFORMANCE.md) (which go unnamed). Agroal 🗓**Upcoming Events** - [PgConf India](https://pgconf.in/conferences/pgconfin2020) (Febuary 26-28 in Bengaluru, India) — A dedicated training day and a multi-track two-day conference. - [Postgres Conference 2020](https://postgresconf.org/conferences/2020) (March 23-27 in New York, United States) — A broad and large scale (indeed, the largest, they say) Postgres event. - [Nordic PgDay 2020](https://2020.nordicpgday.org/) (March 24 in Helsinki, Finland) - [pgDay Paris 2020](https://2020.pgday.paris/#%2319) (March 26 in Paris, France) — [The schedule for this event](https://www.postgresql.eu/events/pgdayparis2020/schedule/) is now available. - [Swiss PGDay 2020](http://www.pgday.ch/2020/) (June 18-19 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community. If you are running a Postgres related event that's beyond the scale of a small local meetup or user group (so, say, 50+ people with many attendees likely to travel to your event from 100+ miles away), let us know and we can include it here in future issues. 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