https://peter.eisentraut.org/blog/2026/06/30/waiting-for-sql-202y-stockholm-meeting-report
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.
about 2 months ago
https://store.enterprisedb.com/category/shop-database-options/0ZGPP0000004HVJ4A2
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.
about 2 months ago
https://ardentperf.com/2026/06/24/happiness-hint-alarm-on-checkpoint-time/
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.
about 2 months ago
https://aws.amazon.com/blogs/database/running-pgvector-in-production-on-amazon-aurora-postgresql/
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.
#advanced (300)
#amazon aurora
#amazon bedrock
#amazon titan
#postgresql compatible
#technical how-to
about 2 months ago
https://www.cybertec-postgresql.com/en/too-many-tables-are-bad/
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.
about 2 months ago
https://www.youtube.com/playlist?list=PLOBORF8Y_l8g
▶  44 Talks from POSETTE 2026 — Microsoft has shared all the talks from its recent POSETTE virtual Postgres conference on YouTube. Highlights include:
about 2 months ago
https://github.com/malisper/pgrust
🤖 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.
about 2 months ago
https://github.com/lesovsky/noisia
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.
about 2 months ago
https://github.com/CrystallineCore/Biscuit
Biscuit: A High-Performance Pattern Matching Index — An experimental specialized index access method for speeding up LIKE/ILIKE pattern matching.
about 2 months ago