PGNexus Weekly News

This Week in PostgreSQL

This week covers PostgreSQL tooling and security highlights: PostgreSQL Migrator 1.0 brings a stable, open-source path for migrating Oracle and MySQL databases to Postgres. pg_vault_tde v1.7.1 delivers AES-256-GCM transparent encryption for PG 17 and 18. A deep dive into WAL write amplification reveals real insert costs and mitigation strategies. CYPEX v2.0.0 moves multi-tenancy enforcement from application queries into native row-level security policies.

The Real Cost of a Single Insert in Postgres

Sep 11, 2026 | NanoHertz Communications

The Real Cost of a Single Insert in Postgres

A single insert into a PostgreSQL table with three indexes generates far more physical I/O than the row's logical size suggests. A 40-byte sensor reading produces approximately 34…

Read the Blog
What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog

Sep 15, 2026 | Svitlana Lytvynenko

What's new in CYPEX v2.0.0: tenancy moves from the query to the catalog

CYPEX v2.0.0, CYBERTEC's PostgreSQL-based application platform, replaces application-enforced multi-tenancy with PostgreSQL row-level security (RLS). Previously, tenant isolation…

Read the Blog

Top 5 Hacker Discussions

Logical replication dominates this cycle's discussions, covering conflict log history tables with TupleTableSlot serialization size constraints, EXCEPT clause support for TABLES IN SCHEMA publications with partition and inheritance interaction rules validated across ~300 combinations, and handling of stale pg_publication_rel entries for UNLOGGED tables—ultimately left unchanged. REPACK CONCURRENTLY is deferred to PG20. Row Pattern Recognition sees minor cleanup debate around pg_nodiscard usage on static functions.

Proposal: Conflict log history table for Logical Replication

The thread discusses a proposal for a conflict log history table for logical replication, focusing on a critical problem: serializing TupleTableSlots to JSON can exceed PostgreSQL…

Read Discussion
Row pattern recognition

The discussion concerns whether `pg_nodiscard` annotations on static functions in the Row Pattern Recognition (RPR) patch series are appropriate. Tatsuo Ishii observed that Postgr…

Read Discussion
Skipping schema changes in publication

Vignesh C proposed a patch to handle UNLOGGED table conversions in PostgreSQL publications. The issue occurs when tables listed in publication EXCEPT clauses are converted to UNLO…

Read Discussion
Adding REPACK [concurrently]

The discussion concerns the proposed `REPACK [CONCURRENTLY]` feature for PostgreSQL. Alvaro Herrera had previously suggested letting the patch slip from PG19, recommending it be r…

Read Discussion
Support EXCEPT for TABLES IN SCHEMA publications

The discussion centers on adding EXCEPT clause support for TABLES IN SCHEMA publications in PostgreSQL logical replication. Shveta malik proposed rules governing how exclusions in…

Read Discussion

This Week's Industry Movements

Anthropic alleges distillation attacks by Chinese AI firms including DeepSeek and Moonshot AI, as both companies race toward billion-dollar revenue targets. OpenAI acquires camera tech startup Glass Imaging for $300M, signaling a hardware push. Salesforce and Nvidia jointly launch Koa, a domain-specific enterprise reasoning model. Meanwhile, OpenAI, Anthropic, and Google DeepMind hold rare multi-week AI safety talks amid uncertain policy support from the Trump administration.

Anthropic Details Distillation Attacks from Alibaba, Moonshot AI, and DeepSeek

techcrunch.com

Anthropic Details Distillation Attacks from Alibaba, Moonshot AI, and DeepSeek

Anthropic has released a report alleging persistent model distillation attacks by China-based AI companies, including Alibaba, Moonshot AI, and DeepSeek. The report claims these c…

OpenAI Acquires Smartphone Camera Maker Glass Imaging for $300 Million

techcrunch.com

OpenAI Acquires Smartphone Camera Maker Glass Imaging for $300 Million

OpenAI has acquired Glass Imaging, a smartphone camera technology company, for approximately $300 million, according to reports. Glass Imaging was founded by two former Apple engi…

Salesforce and Nvidia Launch Joint Reasoning Model "Salesforce Koa" for Enterprise AI

techcrunch.com

Salesforce and Nvidia Launch Joint Reasoning Model "Salesforce Koa" for Enterprise AI

Salesforce and Nvidia have jointly unveiled a new reasoning model called Salesforce Koa, built on Nvidia's open-weight Nemotron model. The system is specifically trained to handle…

OpenAI, Anthropic, and Google DeepMind Hold Weeks of AI Safety Talks

techcrunch.com

OpenAI, Anthropic, and Google DeepMind Hold Weeks of AI Safety Talks

OpenAI has confirmed that it, along with Anthropic and Google DeepMind, has been engaged in weeks of discussions focused on AI safety. The talks come as the Trump administration r…

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