#337 — January 8, 2020

Read on the Web

Postgres Weekly

▶  8 Talks from pgDay Paris 2019pgDay Paris was a one day Postgres conference in France’s biggest city last March. The videos of the sessions are now available. This year’s edition is coming on March 26, 2020.

All of the talks are worth checking out, but these may be of particular technical interest:


Using the Postgres HyperLogLog ExtensionHyperLogLog is a way to efficiently approximating cardinality and Citus Data offers a Postgres extension for bringing HyperLogLog functions into Postgres.

Wisdom Devs

Introducing Automated Postgres EXPLAIN Plan Insights on pganalyze — pganalyze now can automatically collect EXPLAIN plans and provide a visual representation of your costliest plan nodes and more helpful insights into your Postgres database. Learn more about all new EXPLAIN plan features in this blog post.

pganalyze sponsor

The Curious Case of the Table-Locking UPDATE Query“Your database has locks (think mutexes but with varying scope), and those locks can mess up your day if they’re doing something different than you’re expecting.”

Richard Schneeman

Amazon RDS User? Time to Rotate Your Certificates — Every five years, the certificates used by AWS RDS, Aurora and DocumentDB expire and are replaced with new ones, so if you’re using SSL/TLS connections or certificate validation, you may have some work to do before March 5, 2020.

Jeff Barr (AWS)

The Top Postgres Links of 2019 — Postgres highlights from the past twelve months, as clicked on by readers of Postgres Weekly.

Za'e Johnson

Why You Might Need to Increase max_locks_per_transaction — If you’ve ever seen the “out of shared memory” error, this is a parameter you might want to consider tweaking.

Hans-Jürgen Schönig

One Developer's 'Go To' Postgres Configuration for Web Services — This is essentially a developer jotting down all of his notes for setting up Postgres, but.. I like posts like that because there’s often a tip or two to pick up :-)

Peter Bui

How to Effectively Dump Postgres Databases — Some useful notes and scripting around pg_dumpall and pg_dump.

Hubert depesz Lubaczewski

Setting Postgres's Configuration Parameters — Tweaking things in postgresql.conf is one thing but there are other options that are relevant, including changing certain settings on a user or session level.

Hans-Jürgen Schönig

recovery.conf is Gone in Postgres 12 — In Postgres 12, recovery.conf’s settings have been ‘absorbed’ into postgresql.conf – here’s more on the changes and how to handle it for yourself.

Laurenz Albe

Automate Your Postgres & TimescaleDB Schema Design — Built by the team at Timescale, PGSchema is an easy-to-use tool that generates your SQL schema in 3 simple steps: upload, format, copy.

Timescale sponsor

RDS's Price Premium over EC2 Can Be More Than You'd Expect — RDS is Amazon’s Relational Database Service which can provide a fully managed Postgres (or MySQL, Oracle, and others) service on AWS. The increasing price premium of RDS over EC2, however, surprised this developer.

Rick Branson

Message DB: An Event Store and Message Store for Postgres — Aimed at pub/sub, event sourcing and evented microservices use cases, Message DB can help you take advantage of the benefits of evented architecture but without going all the way to something like Apache Kafka.

Eventide Project

Postgres.js: A Fast, Full-Featured Postgres Client for Node.js — Claims to be the fastest even (at 2-10x faster than the popular pg module) but we’ll let you be the judge of that :-)

Rasmus Porsager

🗓 Upcoming Events

If you're in the majority of Postgres users who haven't attended a Postgres event yet, there are lots coming up in the new year:

  • PgDay SF (January 21 in San Francisco) — A one-day, single-track event.
  • PgDay FOSDEM (January 31 in Brussels, Belgium) — Not only is there this Postgres event surrounding the popular open source event, but there's a Postgres room at FOSDEM itself on February 2 too.
  • PgConf.Russia (Febuary 3-5 in Moscow, Russia) — One day of tutorials and two days of talks in three parallel sessions.
  • PgConf India (Febuary 26-28 in Bengaluru, India) — A dedicated training day and a multi-track two-day conference.
  • Nordic PgDay 2020 (March 24 in Helsinki, Finland)
  • pgDay Paris 2020 (March 26 in Paris, France) — Learn more about the world’s most advanced open source database among your peers.
  • Swiss PGDay 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 people likely to travel to your event from afar), let us know and we can include it here in future issues.