--- title: "PlanetScale joins the Postgres party" publication: "Postgres Weekly" issue: 606 published_at: "2025-07-03" canonical_url: "https://postgresweekly.com/issues/606" --- Plus the trickiness around optimal query planning and plan caching. | #​606 — July 3, 2025 [Web Version](https://postgresweekly.com/issues/606) Together with [![Redgate\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_800,h_192/e_make_transparent/co_white,e_outline:9/juuaxaie2hv6pua7rl7k.png)](https://www.red-gate.com/redgate-foundry/projects/pgnow/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/airmujwtkqsnko34s0al.jpg)](https://planetscale.com/blog/benchmarking-postgres) [PlanetScale Enters the Postgres World with Benchmarks-a-Plenty](https://planetscale.com/blog/benchmarking-postgres) — The big news in the commercial Postgres space this week is that [PlanetScale](https://planetscale.com/), best known for its high performance, scalable MySQL service, has [decided to get into the Postgres game too.](https://planetscale.com/blog/planetscale-for-postgres) 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) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/0f25e9d2.png)](https://www.red-gate.com/redgate-foundry/projects/pgnow/) [PostgreSQL Performance? Diagnose It with pgNow](https://www.red-gate.com/redgate-foundry/projects/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](https://www.red-gate.com/redgate-foundry/projects/pgnow/) and get started in seconds. Redgate sponsor [On Postgres Plan Cache Mode Management](https://danolivo.substack.com/p/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?](https://vondra.me/posts/how-often-is-the-query-plan-optimal/) — While we're on the topic.. Tomas Vondra **IN BRIEF:** - [PostgreSQL 17 is now generally available](https://techcommunity.microsoft.com/blog/adforpostgresql/postgresql-17-general-availability-with-in-place-upgrade-support/4427284) on _Azure Database for PostgreSQL Flexible Server._ - [Samed Yildirim](https://postgresql.life/post/samed_yildirim/) is this week's _PostgreSQL Person of the Week_interviewee. [Building Replication-Safe LSM Trees in Postgres](https://www.paradedb.com/blog/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](https://www.enterprisedb.com/blog/streamline-how-your-code-interacts-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 `pgroll`](https://neon.com/guides/pgroll) Dhanush Reddy (Neon) 📄 [Behind the Scenes: Speeding Up `pgstream` Snapshots](https://xata.io/blog/behind-the-scenes-speeding-up-pgstream-snapshots-for-postgresql) Sanz (Xata) 📄 [Archiving Postgres Partitions to Iceberg](https://www.crunchydata.com/blog/archive-postgres-partitions-to-iceberg) Craig Kerstiens 🛠 Code and Tools [Squawk: A Linter for Postgres Migrations](https://squawkhq.com/) — Imagine something like ESLint but for Postgres migrations and other SQL. There’s [an online playground](https://play.squawkhq.com/) if you want to test it on some SQL without installing anything. Steve Dignam [pgrx 0.15: Build Postgres Extensions with Rust](https://github.com/pgcentralfoundation/pgrx/releases/tag/v0.15.0) — The popular, long standing framework for building extensions in Rust gains initial Postgres 18 support. [GitHub repo.](https://github.com/pgcentralfoundation/pgrx) PgCentral Foundation, Inc. - [pgtt 4.4](https://github.com/darold/pgtt/) – Create, manage and use Oracle-style Global Temporary Tables. - [Barman 3.14.1](https://www.postgresql.org/about/news/barman-3141-released-3096/) – Remote backup and disaster recovery tool. - [PGSync 4.1](https://github.com/toluaina/pgsync) – Postgres to Elasticsearch/OpenSearch sync. - [pgAdmin 4 v9.5](https://www.postgresql.org/about/news/pgadmin-4-v95-released-3095/) – Popular Web-based admin interface. - [Prisma 6.11](https://github.com/prisma/prisma/releases/tag/6.11.0) – Next-gen Node.js + TypeScript ORM. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).