#340 — January 29, 2020

Read on the Web

Postgres Weekly

PostgresqlCO.NF: Postgres Config Settings for Humans“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 behind its creation.


pg_timetable: Advanced Postgres 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.

Hans-Jürgen Schönig

Your Data Is Your Business — 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? — 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 — We’ve linked to the Don’t Do This (in Postgres) wiki page a few times, but Hubert has come up with pgWikiDont, a way to check compliance with some of the tips.

Hubert depesz Lubaczewski

▶  'Nothing Compares To VACUUM': A Postgres Song — A Postgres-themed cover of Sinead O’Connor’s Nothing Compares to You but with a GRANT flavored twist.

Gabriel Cafa

Migrating from Oracle to Postgres: Tips and Tricks — Covers a handful of common tripping points like checking for NOT NULL columns and the GRANT command, plus using Orafce, an extension containing numerous compatibility functions to make an Oracle to Postgres transition smoother.

Yorvi Arias

Introducing Backup Ninja - Simple & Secure Database Backups — 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 — 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

Sagy Volkov

Postgres 13 to Get GCD and LCM Functions — 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 — 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 (which go unnamed).


🗓 Upcoming Events

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.