#606 — July 3, 2025 |
|
Postgres Weekly |
|
|
PlanetScale Enters the Postgres World with Benchmarks-a-Plenty — The big news in the commercial Postgres space this week is that PlanetScale, best known for its high performance, scalable MySQL service, has decided to get into the Postgres game too. It’s in “private preview” for now, but they seem prepared to present a challenge to other providers from the get-go. Ben Dicken (PlanetScale) |
PostgreSQL Performance? Diagnose It with pgNow — New to Postgres or just short on time? pgNow delivers fast, focused diagnostics helping you tune configs, fix slowdowns, and spot issues instantly. No setup, no agents, minimal permissions. Download for free and get started in seconds. Redgate sponsor |
|
On Postgres Plan Cache Mode Management — An interesting look into the world of query plans, the balancing of upsides vs downsides when using generic plans (i.e. query plans generated for a prepared statement ahead of time that can be reused quickly), and whether there’s a way forward for switching/updating plans efficiently at the appropriate time. Andrei Lepikhov |
|
How Often is the Query Plan Optimal? — While we're on the topic..
|
|
IN BRIEF:
|
|
Building Replication-Safe LSM Trees in Postgres — A look behind the scenes at the engineering it takes to bring Elasticsearch-style search to Postgres in a way that goes far beyond Postgres’ standard full-text search implementation. Hood, Ying, Pregasen and Ratliff (ParadeDB) |
|
📄 Streamline Your Code and Interactions with Postgres – “When it comes to interacting with Postgres, it may be time to ask yourself: are you doing it in the most streamlined way possible?” Manni Wood 📄 Zero Downtime Schema Migrations with 📄 Behind the Scenes: Speeding Up 📄 Archiving Postgres Partitions to Iceberg Craig Kerstiens |
🛠 Code and Tools |
|
Squawk: A Linter for Postgres Migrations — Imagine something like ESLint but for Postgres migrations and other SQL. There’s an online playground if you want to test it on some SQL without installing anything. Steve Dignam |
|
pgrx 0.15: Build Postgres Extensions with Rust — The popular, long standing framework for building extensions in Rust gains initial Postgres 18 support. GitHub repo. PgCentral Foundation, Inc. |
|