PGNexus Daily News PostgreSQL Technical Articles [image: How SQL/PGQ Rewrites to Joins on PostgreSQL 19] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> Hans-Jürgen Schönig How SQL/PGQ Rewrites to Joins on PostgreSQL 19 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com%...> [image: Odyssey 1.5.1 released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> www.postgresql.org Odyssey 1.5.1 released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> Odyssey 1.5.1, an advanced multi-threaded connection pooler for PostgreSQL and Apache Cloudberry, has been released. This version introduces several new features including simple… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%2...> PostgreSQL Hackers Email Discussion Highlights SQL/JSON json_table plan clause <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20plan...> The thread discusses a patchset fixing multiple issues with the SQL/JSON `JSON_TABLE` PLAN clause. Thom Brown tested patches 0001–0003: 0001 fixes ERROR ON EMPTY dumping in pg_dum… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20plan...> Proposal: new file format for hba/ident/hosts configuration? <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20for...> The discussion concerns adopting a structured file format (TOML, JSON5, or JSONC) for PostgreSQL's hba/ident/hosts configuration files. Andrew Dunstan expressed reluctance toward… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20for...> pg_buffercache: Add per-relation summary stats <https://pgnexus.ai/hacker-discussions?subject=pg_buffercache%3A%20Add%20per-...> A patch adding per-relation summary statistics to pg_buffercache is under iterative review. The v4 patch removes a memory cap that had previously been proposed, following Robert H… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_buffercache%3A%20Add%20per-...> Grab bag of smaller OpenSSL fixups <https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20Op...> The thread discusses a set of small OpenSSL-related fixes in PostgreSQL's `be-secure-openssl.c`. Key patches include replacing the deprecated `X509_NAME_get_text_by_NID` API (depr… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20Op...> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20relis...> The discussion addresses a bug where `REASSIGN OWNED` incorrectly processes `pg_subscription` rows belonging to other databases, because `pg_subscription` is a shared catalog. The… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20relis...> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> The discussion centers on how PostgreSQL should integrate Bloom filters (or similar predicate pushdown mechanisms) into query planning. Tomas Vondra compares approaches: v1 applie… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20filt...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-14-postgresql-daily-news-207.m...> Industry News [image: OpenAI's GPT-5.6 Sol Reported to Delete Files Without Warning] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com OpenAI's GPT-5.6 Sol Reported to Delete Files Without Warning <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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,… [image: Reflection AI Signs $1 Billion Compute Deal with Nebius] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Reflection AI Signs $1 Billion Compute Deal with Nebius <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Reflection AI has signed a $1 billion compute deal with Nebius, securing significant infrastructure resources for its open-source AI development efforts. Founded in 2024, Reflecti… [image: DeepMind CEO Proposes Independent AI Standards Body Modeled After FINRA] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com DeepMind CEO Proposes Independent AI Standards Body Modeled After FINRA <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> DeepMind CEO Demis Hassabis has called for the creation of an independent AI standards body to regulate frontier AI models. Hassabis proposes modeling the organization after FINRA… Social Media Updates [image: Chances are you're already running Postgres somewhere.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Chances are you're already running Postgres somewhere. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> pgEdge has released four open source tools built on top of PostgreSQL, all under the PostgreSQL License. pgedge-postgres-mcp is an MCP server enabling read-only database queries t… [image: Databricks consulting and SI partners are bringing an impressive range of cross-industry and function-specific solutions built using Databricks Lakebase, helping organizations accelerate modernization, agentic AI, and operational application development.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Databricks consulting and SI partners are bringing an impressive range of cross-industry and function-specific solutions built using Databricks Lakebase, helping organizations accelerate modernization, agentic AI, and operational application development. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Databricks consulting and SI partners have developed a broad set of industry and function-specific solutions built on Databricks Lakebase. These cover areas including automated da… [image: Every Postgres database accumulates history that nobody queries but everybody pays for - event logs, audit trails, user activity going back years, all sitting on SSD storage at full price.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Every Postgres database accumulates history that nobody queries but everybody pays for - event logs, audit trails, user activity going back years, all sitting on SSD storage at full price. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> ColdFront is a data tiering tool for Postgres that automatically moves old rows to Apache Iceberg on S3, while keeping the same table name and SQL interface with no application ch… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more