New SQL Standard Features with Postgres Implications — Postgres contributor and SQL standards committee member Peter Eisentraut reports from the latest standardization meeting, where QUALIFY, INSERT ... BY NAME, and JOIN TO ONE were adopted into the draft standard. Plus an update on the still under discussion ‘key joins’ proposal.

Peter Eisentraut

Buy and Upgrade EDB Postgres, No Sales Call — Buying or upgrading Postgres used to mean a sales call and a contract. Now you can do it yourself. The store lets technical teams purchase and scale on their own terms, no waiting on a quote. Pick your product and check out.

EDB sponsor

Why Slow Postgres Checkpoints Make Restarts Risky — Restarting a struggling Postgres instance feels like a safe move, but a veteran engineer explains why it can be the opposite, using two real, extended outages on databases with checkpoint problems. He also shares a practical starting threshold for alerts, so you don’t have to learn the hard way.

Jeremy Schneider

Running pgvector in Production on Amazon Aurora — A dense guide to working with pgvector, from index choices, quantization, and query operators to config settings and operational aspects. It’s Aurora-focused, but still highly useful for both existing and potential pgvector users elsewhere.

Aichholzer and Pareek (AWS)

Too Many Tables are Bad for You — A new performance consulting tale from Laurenz. This time demonstrating how having too many tables can not only spike memory usage, but also slow down queries against Postgres own system catalog.

Laurenz Albe

🤖 pgrust: An AI-Assisted Rewrite of Postgres in Rust — It's not production ready, and AI did much of the work, but it's neat to see that producing an implementation that passes Postgres' own regression tests is possible. The author has spun up a Web-compiled demo so you can kick the tires.

Michael Malis

Noisia 0.3: A Harmful Workload Generator for Postgres — Creates things like deadlocks, transactions that do nothing, and queries that produce on-disk temporary files for stress-testing your setup. Use with care! The latest version adds a ‘backend killer’ workload (via OOM) and a ‘slot-bloat’ workload.

Alexey Lesovsky

Biscuit: A High-Performance Pattern Matching Index — An experimental specialized index access method for speeding up LIKE/ILIKE pattern matching.

Sivaprasad Murali