#332 — November 20, 2019

Read on the Web

Postgres Weekly

📄 JSONPath: A Query Language for JSON – [PDF] — If you’ve heard that Postgres 12 has support for SQL/JSON (which Markus Winand has called "the most complete and correct .. implementation I've seen.") and wondered why that’s a big deal, this set of code-rich slides should fill you with ideas. I’m always a bit wary of linking to slidedecks, but these deserve a look as they're very good.

Oleg Bartunov

PostgreSQL 12.1, 11.6, 10.11, 9.6.16, 9.5.20, and 9.4.25 Released — A wide variety of releases to fix over 60 bugs that were reported in the last several months (including many which only affect Postgres 12). This is also a good time to note 9.4 will no longer receive such fixes after February 2020, so consider getting an upgrade plan into place if you’re still using it.

PostgreSQL Global Development Group

Whitepaper: Harden Your PostgreSQL Database — Learn about Database Security and develop a deep understanding of industry best practices. Explore how to harden your PostgreSQL cluster and have confidence that your data is adequately protected from malicious attacks.

2ndQuadrant PostgreSQL Whitepapers sponsor

An Interview on What Makes Postgres Unique (Extensions) — Dimitri Fontaine interviewed Craig Kerstiens about the importance of extensions in the Postgres ecosystem and what his favorites are.

Craig Kerstiens

Dealing with Similarity in Postgres and Rails using Trigrams — A tutorial aimed at the Rubyists amongst us (yes, we have a newsletter for that) but the lessons can be used by any Postgres user as it leans upon pg_trgm, a core Postgres module that provides functions for determining the similarity of strings based on trigram matching.

Leigh Halliday

effective_cache_size: What It Means in Postgres — A brief explainer of what the effective_cache_size config setting is for and how it helps Postgres’s query planner.

Hans-Jürgen Schönig

Avoiding 'OR' for Better Query Performance — A look at different kinds of queries using SQL’s OR and how to rewrite them without OR for better performance.

Laurenz Albe

Downloading Large Heroku Postgres Backups — The Heroku PaaS provides a variety of tools for working with Postgres databases including creating forks of your database, scheduling backups, downloading dumps, and more.

Justin Searls

📂 Code and Projects

check_pgbackrest 1.6 Released — pgBackRest is a Postgres backup and restore tool but check_pgbackrest is a Nagios plugin that monitors the backups pgBackRest takes.


Crunchy High-Availability PostgreSQL Keeps Critical Applications Up — Leverage trusted open source software to ensure your PostgreSQL data is always available.

Crunchy Data sponsor

Scaledger: A Double-Entry Accounting Database with a Typed GraphQL API — The API is introspected directly from a Postgres schema.


pg-minify: Minifies PostgreSQL Scripts, Reducing IO Usage

Vitaly Tomilov

🗓 Upcoming Events

  • 2Q PGCONF 2019 (December 4-5, 2019 in Chicago) — A conference dedicated to exchanging knowledge about the world’s most advanced open source database: PostgreSQL.
  • PgDay SF (January 21, 2020 in San Francisco) — A 1-day, single-track Postgres event. The CFP deadline is this Friday on 22 November — and they want your talk proposals ASAP.
  • PgConf.Russia (Febuary 3-5, 2020 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions.
  • PGConf India (Febuary 26-28, 2020 in Bengaluru, Maharashtra, India) — A dedicated training day and a multi-track two-day conference.
  • pgDay Paris 2020 (March 26, 2020 in Paris, France) — Learn more about the world’s most advanced open source database among your peers.
  • Swiss PGDay 2020 (June 18-19, 2020 in Switzerland) — A two track conference (one in English, one in German) aimed at the entire Postgres community.