pg_plan_advice: Plan Stability and User Planner Control for Postgres? — Prolific Postgres contributor/committer Robert Haas proposes an “ambitious” patch set for Postgres 19 to let admins control query planner behavior system-wide, without touching application code, by storing and automatically applying “plan advice” strings to specific queries.

Robert Haas

Production Query Plans Without Production Data — Postgres 18 has two new functions that make optimizer statistics portable, meaning it's possible to export stats from a production database and inject them into a test database so you can reproduce production query plans locally without the actual data!

Radim Marek (boringSQL)

Enterprise Grade Postgres for Agentic AI, High Availability and More — pgEdge delivers open-source, 100% Postgres infrastructure for Agentic AI and enterprise apps that demand high availability, reliability, and data sovereignty. We make it easy to build, deploy and manage enterprise‑grade Postgres apps at scale.

pgEdge sponsor

Migrating a Production Database from Heroku to AWS — A practical post covering the techniques behind migrating a 300GB database from Heroku to RDS. An interesting detail is the use of a temporary EC2 instance as a bridge, necessary because Heroku’s restrictions meant WAL archives were the only escape hatch, and RDS can’t receive physical WAL replication directly.

Greg Bergé (Argos)

Fixing Connection Pooling on Serverless with PgDog — When Circleback's serverless workloads hit PgBouncer's single-threaded limitation, deploy-time traffic spikes caused connection issues. PgDog, a multi-threaded pooler, resolved their problem.

Stephen van Son (Circleback)

Using Rust & Postgres for Everything — Practical patterns, distilled from years of production use, for building backend services with Rust and Postgres "which may be particularly handy in a world where hardware prices are skyrocketing."

Sylvain Kerkour

pg_plan_alternatives: Tracing Query Plan Alternatives with eBPF — EXPLAIN shows you the final chosen plan, not what was considered. This tool uses eBPF to instrument Postgres' optimizer and trace alternative plans and cost estimates during the planning phase. The catch is it's Linux only and the Postgres binary needs debug symbols, but it's a fascinating read nonetheless.

Jan Nidzwetzki

Using json_schema_validate to Validate the Shape of Your JSON — Andrew explores the topic of validating JSON at the database level and shares his new json_schema_validate extension that's designed to make it both easy and fast versus pg_jsonschema.

Andrew Dunstan (EDB)

pgconsole: A Minimal Self-Hosted Postgres Editor for Teams — An attractive Web-based Postgres editor with built-in access control, audit logging, and AI assistance that you can quickly deploy via Docker. There’s a live demo here if you want to see how it looks. Note that it's source available, rather than open source.

Bytebase