#360 — June 17, 2020

Read on the Web

Postgres Weekly

Jepsen Finds a Bug in Postgres 12.3 — The name ‘Jepsen’ is sure to stir emotions in any database server creator as their analyses of distributed systems (such as databases!) often reveal all sorts of edge cases and flaws. And so it goes with Postgres with a bug in serializable isolation being found. This is technical stuff, but it’s great to see systems like Postgres placed under such rigorous analysis.

Kyle Kingsbury

How One Word in Postgres Unlocked a 9x Performance Improvement — The creator of a personal finance tool experienced a user whose data caused a flood of INSERTs large enough to cause a problem. Here’s the tale of how a simple RETURNING clause enabled a huge optimization in the process.

James Long

Webinar | Distributed SQL: A Modern, Cloud-Native PostgreSQL — Hitting challenges scaling PostgreSQL, deploying it in the cloud, or using it with microservice architecture? A Distributed SQL database might be a better fit for your workload. Tune in tomorrow, June 18, for an architecture review and live demo.

COCKROACH LABS sponsor

Citus 9.3 Released: The Postgres Horizontal Scaling Extension — Citus is the now Microsoft-owned Postgres extension that turns Postgres into a distributed database that can be more powerfully used across multiple servers. 9.3 improves the distributed SQL support, now with full support for window functions.

citusdata

XgeneCloud: Instant REST and GraphQL APIs on any Database — Where ‘any’ includes Postgres, naturally :-) There’s quite a lot of pieces to this and they seem to be forming a company around the tech, but it’s open source nonetheless.

xgenecloud

Understanding User Management in PgBouncerPgBouncer is a popular connection proxy and pooler for Postgres, but it doesn’t just pass things straight through to Postgres, it can handle authentication directly itself. This article clears up how that works.

Peter Eisentraut

Controlling Runaway Queries with Statement Timeouts — A well tuned database on good hardware is easily capable of many thousands of queries per second but long lived queries can quickly cause things to back up. Here’s one defense against queries that want to live forever.

Craig Kerstiens

A Free, Multi-Node, Petabyte Scale, Time-Series Database on PostgresRead more about Timescale’s multi-node time-series database and why they’re making it available for free.

Timescale sponsor

Controlling Server Variables at Connection Time — A brief tip, this. For example: psql 'options=-cwork_mem=100MB dbname=test'

Bruce Momjian

Composite Data Type Performance Issues in Postgres

Hans-Jürgen Schönig

Running pgbackrest on FreeBSDpgbackrest is a backup and restore system for Postgres.

Luca Ferrari

pq: The Pure Go(lang) Postgres Driver for database/sql — Now supports GSS authentication.

Blake Mizerany and contributors

🗓 Upcoming Online Events

  • Postgres Vision 2020 on June 23-24. A full attempt at an online Postgres conference across multiple days with multiple tracks.
  • Postgres Pulse - Zoom-based sessions with folks like Bruce Momjian, Vibhor Kumar, and other people at EnterpriseDB. Now running every other week at 11am ET on Mondays. The next is on June 29.