Query Plan Rewriting in Postgres — A tour of the Postgres 18 planner's query transformations, including constant folding, inlining, subquery flattening, and join elimination. It's also useful to learn about the cases it won't rewrite, some of which can trip up experienced users (though Postgres 19 adds NOT IN rewriting when NULLs can be ruled out).

Phil Eaton

Govern EDB Postgres at Scale with Red Hat Ansible — Managing users, privileges, schemas, extensions and pg_hba by hand across a big Postgres fleet? See how edb.epas_postgresql, a Red Hat-certified Ansible Collection, enforces consistency at scale. Live with Red Hat and EDB, Oct 15.

EDB sponsor

Query Plan Hints in Postgres 19 — It may be “a new Postgres feature you will probably never need” but pg_plan_advice and pg_stash_advice are worth having on your radar for when you do need to steer the planner the right way. EXPLAIN (PLAN_ADVICE) will also let you see what's going on.

Elizabeth Garrett Christensen

'PlanetScale Released Text Search and We Have a Lot to Say' — PlanetScale recently unveiled TIN, a full-text search extension, with benchmarks showing it to be much faster in queries than the open source ParadeDB. So ParadeDB got to work, and say they've “closed the gap”.

Ming Ying (ParadeDB)

Upgrading a 56TB Database by Mostly Not Moving It — Facing downtime due to a mandatory reboot deadline on Aurora, Trigger's engineers moved just 2% of their data to PlanetScale, leaving the rest behind. A candid postmortem involving a pgcopydb patch and a failed first cutover.

Daniel Sutton (Trigger)

Running Apache Cloudberry as Postgres Extensions — An experiment to run Apache Cloudberry (an open source descendant of Greenplum, the Postgres-based parallel data warehouse) as a set of extensions on a lightly patched Postgres 19. It surfaces some interesting limitations to Postgres' extension mechanism.

Igor Suhorukov

🤖 Microsoft Unveils an MCP Server for Postgres — They’re far from the first, but it’s interesting to see Microsoft step into this area with a Rust-powered (but installed via npm) MCP server to allow AI coding agents to work with Postgres, whether you’re on Azure or not.

Aditi Gupta (Microsoft)

📊 pgwatch 6.0: Prometheus Sources, Rebuilt Dashboards, and a Sturdier Collector — The popular Postgres metrics collector and Grafana visualizer (demo) adds Prometheus exporters as sources, rebuilds its dashboards on Grafana 13, and copes better with databases that stop responding.

CYBERTEC PostgreSQL

pgx-bm25 1.0: A Pure C BM25 Index Extension — A new PostgreSQL-licensed BM25 ranked full-text search extension whose indexes live in the index relation's pages so WAL logging, replication, and VACUUM all work as usual with no separate engine or runtime to manage.

PGX Inc.