PGNexus Daily News

PostgreSQL Technical Articles

Running pgvector in production on Amazon Aurora PostgreSQL

Stefan Aichholzer

Running pgvector in production on Amazon Aurora PostgreSQL

This post covers operational best practices for running pgvector on Amazon Aurora PostgreSQL, targeting production RAG workloads. It addresses index selection between HNSW and IVF…

Read the Blog
Heterogeneous Graphs in SQL/PGQ on PostgreSQL 19

Hans-Jürgen Schönig

Heterogeneous Graphs in SQL/PGQ on PostgreSQL 19

This article explores heterogeneous graph modeling using SQL/PGQ in PostgreSQL 19. It demonstrates how to define a property graph with multiple vertex and edge types (persons, com…

Read the Blog
The Role of AI in Data Analytics: Moving From Hype to High-Octane Utility

enterprisedb.com

The Role of AI in Data Analytics: Moving From Hype to High-Octane Utility

AI is increasingly applied to data analytics, but a significant gap exists between marketing claims and practical value. Traditional analytics — SQL queries, ETL pipelines, and BI…

Read the Blog
PGX announces support for EOL versions of PostgreSQL

www.postgresql.org

PGX announces support for EOL versions of PostgreSQL

PGX has launched PGX Longevity, a commercial service offering critical security patches and data integrity bug fixes for PostgreSQL versions that have reached end-of-life (EOL), c…

Read the Blog
What You’re Really Owning When You Self-Host TimescaleDB

Matty Stratton

What You’re Really Owning When You Self-Host TimescaleDB

Self-hosting TimescaleDB for mission-critical workloads is not a database decision—it is a platform engineering commitment. This article, written by the TimescaleDB team, walks th…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Handle concurrent drop when doing whole database vacuum

The thread discusses fixing a race condition where a concurrent DROP can cause errors during whole-database VACUUM. The current v3 patch adds ACL-check logic in `vacuum_is_permitt…

Read Discussion
bytea(uuid) missing proleakproof?

Chao Li reported that the `bytea(uuid)` function introduced by commit `ba21f5bf8` (which added explicit casting between `bytea` and `uuid`) was not marked as `proleakproof`, unlik…

Read Discussion
Optimize UUID parse using SIMD

Masahiko Sawada proposed optimizing UUID parsing by reusing the SIMD-accelerated hex_decode_safe() function introduced in commit ec8719ccbfcd. Benchmarks show a ~5× speedup for uu…

Read Discussion
pg_stat_statements: Remove (errcode...) framing parentheses in erport(...)

Mikhail Litsarev proposed a small cleanup patch for pg_stat_statements to remove unnecessary parentheses wrapping the errcode() macro inside ereport() calls, following commit e3a8…

Read Discussion
glob support in extension_control_path/dynamic_library_path?

The thread discusses a proposed patch to add glob pattern support to `extension_control_path` and `dynamic_library_path`. Zsolt Parragi raises security and observability concerns:…

Read Discussion
enhance wraparound warnings

The thread discusses enhancements to PostgreSQL's wraparound warning messages for transaction IDs and MultiXactIds. A key point of debate is wording: Fujii Masao used "transaction…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

Anthropic's Claude gains ground in paid AI consumer market against ChatGPT

techcrunch.com

Anthropic's Claude gains ground in paid AI consumer market against ChatGPT

Despite ChatGPT's dominant market position, paying consumers are increasingly choosing Anthropic's Claude, according to new data. The trend highlights a shift in the competitive l…

Patronus AI raises $50M to build simulation environments for stress-testing AI agents

techcrunch.com

Patronus AI raises $50M to build simulation environments for stress-testing AI agents

Patronus AI, an agent testing startup founded by former Meta AI researchers, has secured $50 million in funding to develop "digital worlds" designed to stress-test AI agents. The…

Adobe acquires image and video enhancement tool maker Topaz Labs

techcrunch.com

Adobe acquires image and video enhancement tool maker Topaz Labs

Adobe has announced the acquisition of Topaz Labs, a company known for its AI-powered image and video enhancement tools. Adobe stated it plans to integrate Topaz Labs' technology…

Social Media Updates

linkedin

Databricks co-founders Matei Zaharia and Reynold Xin joined Latent Space following #DataAISummit to discuss the ideas shaping the next generation of data and AI, including Omnigent, LTAP, Lakebase, agent security, open formats, and what it takes to build for the agent era.

Databricks co-founders Matei Zaharia and Reynold Xin appeared on Latent Space after the Data and AI Summit to discuss key ideas driving the next generation of data and AI infrastr…

Databricks co-founder and CEO Ali Ghodsi joined Edward Ludlow on Bloomberg Tech to make the case that enterprise AI is already smart enough.

linkedin

Databricks co-founder and CEO Ali Ghodsi joined Edward Ludlow on Bloomberg Tech to make the case that enterprise AI is already smart enough.

Databricks co-founder and CEO Ali Ghodsi appeared on Bloomberg Tech to argue that enterprise AI has reached sufficient intelligence. The real obstacle limiting AI agents, he says,…

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