Issue 360 - How 'RETURNING' yielded a 9x performance improvement (12)

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...

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.

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.

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.

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.

Understanding User Management in PgBouncer — PgBouncer 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.

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.

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

pq: The Pure Go Postgres Driver for database/sql — v1.1 came out last week dropping support for Go 1.8 and below.