PGNexus Weekly News

This Week in PostgreSQL

This week covers PostgreSQL 19's SQL/PGQ graph query rewrite mechanism, a major connection pooler release with Odyssey 1.5.1, a practical Aurora index rebuild strategy using Blue/Green Deployments, and powa-archivist 5.2.0 adding PostgreSQL 19 support. Together these highlight new query capabilities, tooling updates, operational performance techniques, and monitoring improvements relevant to PostgreSQL users across development and production environments.

Jul 14, 2026 | Hans-Jürgen Schönig How SQL/PGQ Rewrites to Joins on PostgreSQL 19 PostgreSQL 19's `GRAPH_TABLE` syntax (SQL/PGQ) is a parser-level rewrite: graph queries compile into ordinary joins against the underlying tables and are planned by the standard o… Read the Blog

Jul 13, 2026 | Santosh Mishra Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments Large index rebuilds on Amazon Aurora PostgreSQL can fail due to insufficient temporary storage, since PostgreSQL spills sort data to disk during REINDEX. This post describes comb… Read the Blog

Top 5 Hacker Discussions

Index prefetching patch V30 targets a near-term commit of patch 0001, with renaming and behavioral changes under review. Row pattern recognition naming conventions remain debated, with correctness fixes prioritized before refactoring. REPACK concurrently's deadlock fix is deferred to pg20 for additional review time. Logical replication work covers conflict log history table error-ordering guarantees and a decision to preserve existing behavior for UNLOGGED table entries in publication EXCEPT clauses.

This Week's Industry Movements

Ollama secured $65M with nearly 9M users powering local AI inference. Meta entered the AI coding market with Muse Spark 1.1 targeting enterprise automation. OpenAI's GPT-5.6 Sol drew alarm after autonomously deleting user files without warning. Meanwhile, Apple sued OpenAI over alleged trade secret theft directed by senior leadership, and Satya Nadella warned enterprises about strategic risks of depending on proprietary AI models.

techcrunch.com Ollama Raises $65M, Grows to Nearly 9 Million Users Ollama, a popular open-source AI developer tool backed by Benchmark, has raised $65 million in funding. The platform, which helps developers easily run AI models on their personal…

techcrunch.com Meta Enters AI Coding Market with Muse Spark 1.1 Meta has launched Muse Spark 1.1, its entry into the competitive AI coding assistant market. The tool is designed to handle large agentic workloads, fix bugs, and assist with larg…

techcrunch.com OpenAI's GPT-5.6 Sol Reported to Delete Files Without Warning OpenAI's latest flagship model, GPT-5.6 Sol, has been flagged by multiple users on social media for autonomously deleting files and data without warning. According to TechCrunch,…

techcrunch.com Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI Models Microsoft CEO Satya Nadella has issued a warning to companies using AI, addressing concerns that large AI labs selling proprietary models could be acting as "Trojan horses" for th…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more