PGNexus Daily News

PostgreSQL Technical Articles

Meeting EU Data Sovereignty Requirements While Speeding-Up Innovation

enterprisedb.com

Meeting EU Data Sovereignty Requirements While Speeding-Up Innovation

EU data sovereignty has become a board-level priority following the European Commission's June 2026 European Tech Sovereignty package, which encourages organizations—especially in…

Read the Blog
Inside EDB’s New Principles for Responsible AI: Sovereign, Governed, Trusted and Beneficial

enterprisedb.com

Inside EDB’s New Principles for Responsible AI: Sovereign, Governed, Trusted and Beneficial

EDB has updated its Principles for Responsible AI, originally released in 2024, in response to growing enterprise concerns around governance, transparency, security, and data cont…

Read the Blog
Postgres Sorting at Scale Needs More Than ORDER BY

NanoHertz Communications

Postgres Sorting at Scale Needs More Than ORDER BY

Sorting large PostgreSQL tables by timestamp degrades significantly at scale. A query running in 180ms at 10 million rows can take 4 seconds at 500 million, even with an existing…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Handle concurrent drop when doing whole database vacuum

The discussion focuses on how whole-database VACUUM handles concurrent relation drops. The patch (v3) fixes the issue by emitting a WARNING when a relation is concurrently dropped…

Read Discussion
Small patch to improve safety of utf8_to_unicode().

Jeff Davis posted v5 of a patch series improving UTF-8 safety in `utf8_to_unicode()`. The series includes: a backportable defensive fix for invalid UTF-8 handling, a logic bug fix…

Read Discussion
Add MIN/MAX aggregate support for uuid

Tristan Partin proposed adding MIN/MAX aggregate support for the uuid type in PostgreSQL, motivated primarily by the UUIDv7 use case where lexicographic ordering corresponds to ti…

Read Discussion
glob support in extension_control_path/dynamic_library_path?

A patch by Jakob Egger proposes adding glob/wildcard support to `extension_control_path` and `dynamic_library_path`, falling back to existing behavior on Windows. David E. Wheeler…

Read Discussion
uuidv7 improperly accepts dates before 1970-01-01

The discussion addresses a bug where `uuidv7()` improperly accepts timestamps outside its valid range. Baji Shaik submitted a three-patch series: rejecting timestamps before the U…

Read Discussion
Adding basic NUMA awareness

Tomas Vondra posted an updated patch series for adding basic NUMA awareness to PostgreSQL. The two key fixes address mbind issues: correcting the nodemask size so partitions bind…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

OpenAI Unveils First Custom AI Chip "Jalapeño" Built by Broadcom

techcrunch.com

OpenAI Unveils First Custom AI Chip "Jalapeño" Built by Broadcom

OpenAI has revealed its first custom-designed processor, named Jalapeño, developed in partnership with Broadcom. The chip was purpose-built to meet the specific demands of OpenAI'…

Facebook Launches AI Companion App for Content Creators

techcrunch.com

Facebook Launches AI Companion App for Content Creators

Facebook is rolling out a new AI companion app aimed at content creators, currently being tested with a select group. The app integrates Facebook's recently launched AI creator as…

Social Media Updates

Every database eventually runs into the same wall: storage costs money, and the data nobody queries anymore costs exactly as much as the data everyone does.

linkedin

Every database eventually runs into the same wall: storage costs money, and the data nobody queries anymore costs exactly as much as the data everyone does.

All databases face the same cost problem: rarely accessed data occupies the same expensive block storage as frequently queried data. The common proposed solution is to move cold d…

linkedin

Less than a week to go until GITEX AI EUROPE - Europe's Leading Tech & AI Event and our team is super excited to attend!

GITEX AI EUROPE, described as Europe's leading technology and AI event, is less than a week away. The team is looking forward to attending and invites visitors to meet them at the…

linkedin

CYBERTEC CEO Hans-Juergen Schoenig introduces pg_hardstorage, a new open-source backup and point-in-time recovery tool for PostgreSQL, released under the Apache 2.0 license.

CYBERTEC CEO Hans-Juergen Schoenig has announced pg_hardstorage, an open-source backup and point-in-time recovery tool for PostgreSQL. Originally developed internally at CYBERTEC,…

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