Postgres Weekly Issue 455: May 18, 2022

#455 — May 18, 2022

Google Cloud Introduces AlloyDB for PostgreSQL — It’s not a perfect comparison but think about Amazon Aurora except from Google who boast this is “PostgreSQL in a way that only Google can deliver it.” AlloyDB is a managed Postgres-compatible service (though it does seem like elements of Postgres live under the hood) which promises seamless scaling, for a price. There’s a more technical explanation here.

Google Cloud

Scale Postgres Globally in Minutes, Without Writing Code — PolyScale.ai is a plug-and-play serverless edge cache for Postgres. Scale globally in minutes without writing code or deploying infrastructure. Enable data-driven, serverless functions with ease.

PolyScale.ai sponsor

The Postgres 15 Draft Release Notes — Postgres 15 isn’t due for several months yet (though the first beta will be out within weeks) but Bruce Momjian has completed the first draft of PG 15’s release notes and lays out the main tweaks and improvements.

PostgreSQL Documentation

Quick bits:

⚠️ PostgreSQL 14.3, 13.7, 12.11, 11.16, and 10.21 have all been released to close a security vulnerability as well as fix around 50 bugs. Of note: "If you have any GiST indexes on columns using the ltree data type, you will need to reindex them after upgrading."
GitHub's Jaana Dogan notes that Google Cloud is 'betting big on Postgres.'
🎂 Npgsql is a .NET data provider for Postgres and it's celebrating its 20th birthday today. Congratulations to them.

CloudNativePG: A New Kubernetes Operator for Postgres — EDB has released an Apache 2.0 licensed Kubernetes operator that can handle the full lifecycle of a Postgres cluster. GitHub repo.

Gabriele Bartolini (EDB)

Postgres Index Scans Explained — Egor is back with a characteristically deep dive on index scans which should help clear things up if you’ve seen “Bitmap Index Scan” or “Parallel Index Only Scan” in your query plans and wondered what they really mean.

Egor Rogov

Observability Powered by SQL: Take OpenTelemetry Traces into Postgres — OpenTelemetry is a standard for instrumentation (traces, metrics, logs, etc.) and the Timescale folks have announced Promscale, a backend for Promethius and OpenTelemetry built on Postgres and TimescaleDB for analyzing such data with SQL.

Ramon Guiu (Timescale)

Build Any Internal Tool on Postgres in Minutes. Add Data from Other Sources or APIs with a Point and Click Interface

Retool — 10x faster internal tools sponsor

An Experience with Exporting Postgres RDS Partitioned Tables to S3 — We all love writing scripts to move data around, right?.. right? Well, it’s not always fun or easy, as we see here, and they ultimate had to put this approach on ice.

George Petropoulos

Adventures in Collating Text in Linux, Docker and Postgres — A text sorting error popped up in an app the author was working on and it required digging around much more in the collation settings than you’d expect.

Paul Cochrane