PGNexus Daily News

PostgreSQL Technical Articles

CERN PGDay 2027: Announcement and CfP

www.postgresql.org

CERN PGDay 2027: Announcement and CfP

CERN PGDay 2027 is scheduled for February 12, 2027, in Geneva, Switzerland, co-organized by CERN and SwissPUG. The single-day, single-track conference targets PostgreSQL users, de…

Read the Blog
The Real Cost of a Single Insert in Postgres

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

PostgreSQL Hackers Email Discussion Highlights

Recovery conflict resolution misses backends that import snapshots

A contributor (chee.wooson) proposes a v3 patch series addressing a bug where recovery conflict resolution misses backends that import snapshots. The core issue: after ProcArrayLo…

Read Discussion
REPACK (CONCURRENTLY) can crash a logical decoding session

The thread discusses a bug fix for REPACK (CONCURRENTLY) crashing a logical decoding session. Masahiko Sawada proposed patches to address the issue and announced intent to push th…

Read Discussion
Support for 8-byte TOAST values, round two

The discussion covers ongoing review of a patch series (v17) adding 8-byte OID (oid8) support for TOAST chunk identifiers in PostgreSQL. Michael Paquier applied earlier patches af…

Read Discussion
Switching XLog source from archive to streaming when primary available

The discussion focuses on switching a standby's WAL source from archive recovery to streaming replication when the primary is available. The core concern is that under high write…

Read Discussion
Temporal fkey bugs

Andres Freund reports several bugs in PostgreSQL's temporal foreign key implementation, discovered with AI assistance while reviewing FOR PORTION OF. The identified issues include…

Read Discussion
WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts

The discussion addresses a bug in the WAL_LOG CREATE DATABASE strategy where standbys silently lose all-visible/all-frozen bits and free space data for every copied relation, inde…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

OpenAI's Feud with Mathematicians Escalates as 25 Academics Sign Open Letter

techcrunch.com

OpenAI's Feud with Mathematicians Escalates as 25 Academics Sign Open Letter

Twenty-five leading mathematicians have signed an open letter accusing AI labs, including OpenAI, of threatening their intellectual work. The letter marks a significant escalation…

Nscale Adds Former OpenAI Exec Fidji Simo to Board Ahead of Potential IPO

techcrunch.com

Nscale Adds Former OpenAI Exec Fidji Simo to Board Ahead of Potential IPO

AI infrastructure company Nscale has appointed Fidji Simo, former No. 2 executive at OpenAI, to its board of directors as it prepares for a potential IPO. Simo previously led groc…

Kimi-Maker Moonshot AI Targets $2 Billion in Annual Revenue

techcrunch.com

Kimi-Maker Moonshot AI Targets $2 Billion in Annual Revenue

Chinese AI startup Moonshot AI, the company behind the Kimi AI model, is targeting $2 billion in annual revenue. Despite a slight decline in K3 model usage in recent months, data…

Social Media Updates

linkedin

Where does AI help with migration?

In a short interview, PostgreSQL company CEO Hans-Juergen Schoenig discusses the role of AI in database migration. He suggests AI can assist across many stages of a PostgreSQL mig…

linkedin

DeepSeek 4.1 Flash is on Databricks the day it ships.

DeepSeek 4.1 Flash is available on Databricks on its release day. Benchmarked on OfficeQA Pro V2, it reaches the Pareto frontier, positioning it as a competitive open-source model…

Marketing teams already have the data.

linkedin

Marketing teams already have the data.

Marketing teams often have the data they need, but struggle to act on it quickly. Genie One addresses this by letting marketers work directly with governed business data across fi…

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