Issue 455 - The draft release notes for Postgres 15 (9)

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.

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.

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.

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.

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.

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.

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.

Custom Dashboards, Admin Panels, CRUD Apps — Build an Internal Tool on Any SQL Database 10x Faster

App Performance Blocked By Your Database? — Scaling Postgres databases can mean cost and complexity. PolyScale provides a plug-and-play serverless edge cache for Postgres. Scale globally in minutes without writing code or deploying infrastructure.