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

www.postgresql.org

Odyssey 1.5.1 released

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

SQL/JSON json_table plan clause

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

Proposal: new file format for hba/ident/hosts configuration?

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

pg_buffercache: Add per-relation summary stats

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

Grab bag of smaller OpenSSL fixups

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

REASSIGN OWNED vs. relisshared dep on !relisshared

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

hashjoins vs. Bloom filters (yet again)

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

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

Reflection AI Signs $1 Billion Compute Deal with Nebius

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…

techcrunch.com

DeepMind CEO Proposes Independent AI Standards Body Modeled After FINRA

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…

Chances are you're already running Postgres somewhere.

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…

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.

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…

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.

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…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates