--- title: "Robert Haas proposes pg_plan_advice for Postgres 19" publication: "Postgres Weekly" issue: 639 published_at: "2026-03-11" canonical_url: "https://postgresweekly.com/issues/639" --- Plus an interesting multi-step Heroku to AWS migration, and native JSON schema validation in Postgres. #​639 — March 11, 2026 [Web Version](https://postgresweekly.com/issues/639) Together with [![pgEdge\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_294/e_make_transparent/co_white,e_outline:17/fnv5xiqc6lewnu21fbch.png)](https://www.pgedge.com/?pgweeklymasthead) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/nluazltiueyof85sqwog.jpg)](https://rhaas.blogspot.com/2026/03/pgplanadvice-plan-stability-and-user.html) [pg_plan_advice: Plan Stability and User Planner Control for Postgres?](https://rhaas.blogspot.com/2026/03/pgplanadvice-plan-stability-and-user.html) — 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](https://boringsql.com/posts/portable-stats/) — 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) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/8d1b3557.png)](https://www.pgedge.com/) [Enterprise Grade Postgres for Agentic AI, High Availability and More](https://www.pgedge.com/) — 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](https://argos-ci.com/blog/heroku-to-aws-migration) — 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) **IN BRIEF:** - Supabase has [added log drains](https://supabase.com/blog/log-drains-now-available-on-pro) as a feature for Pro users so you can send logs to your own logging backend. - Bruce Momjian has [shared the slide deck](https://momjian.us/main/writings/pgsql/wal.pdf) for his new talk, _The Wonderful World of WAL_. [Fixing Connection Pooling on Serverless with PgDog](https://circleback.ai/blog/how-we-fixed-postgres-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](https://pgdog.dev/), a multi-threaded pooler, resolved their problem. Stephen van Son (Circleback) [Using Rust & Postgres for Everything](https://kerkour.com/rust-postgres-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 📄 [Just Use Postgres (Taken to the Extreme)](https://nesbitt.io/2026/03/10/just-use-postgres.html) – Think Heroku, except everything is the database. Andrew Nesbitt 📄 [The MySQL Shadow](https://momjian.us/main/blogs/pgblog/2026.html#March_11_2026) – Bruce reflects on the long, slow decline of MySQL. Bruce Momjian 📄 [Building a High-Performance Postgres Time Series Stack with Iceberg](https://www.snowflake.com/en/engineering-blog/postgres-time-series-iceberg/) Christensen and Slot (Snowflake) 📄 [How ParadeDB Optimized Top K in Postgres](https://www.paradedb.com/blog/optimizing-top-k) Ming Ying (ParadeDB) **TOOLS, RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/zwxzi1qjry1ypl5tm60h.jpg)](https://jnidzwetzki.github.io/2026/03/04/pg-plan-alternatives.html) [pg_plan_alternatives: Tracing Query Plan Alternatives with eBPF](https://jnidzwetzki.github.io/2026/03/04/pg-plan-alternatives.html) — `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](https://www.enterprisedb.com/blog/validating-shape-your-json-data) — Andrew explores the topic of validating JSON at the database level and shares his new [json_schema_validate](https://github.com/adunstan/json_schema_validate) extension that's designed to make it both easy and fast versus[pg_jsonschema.](https://github.com/supabase/pg_jsonschema) Andrew Dunstan (EDB) [pgconsole: A Minimal Self-Hosted Postgres Editor for Teams](https://www.pgconsole.com/) — 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](https://demo.pgconsole.com/) if you want to see how it looks. Note that it's _source available_, rather than open source. Bytebase - [Marten 8.23](https://github.com/JasperFx/marten) – .NET library providing a document database and ACID-compliant event store atop Postgres. - [Databasus 3.19](https://github.com/databasus/databasus) – Self-hosted backup tool for Postgres, MySQL and MongoDB. - [psql-wire 0.18](https://github.com/jeroenrinzema/psql-wire) – Pure Go implementation of the Postgres server wire protocol. - [PgBulkInsert 9.0](https://github.com/PgBulkInsert/PgBulkInsert) – Java library for efficient bulk inserts using binary[COPY](https://www.postgresql.org/docs/current/sql-copy.html). - [PostgREST 14.6](https://docs.postgrest.org/en/v14/) – Serves a fully RESTful API from a Postgres database. **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|*).