PGNexus Daily News

PostgreSQL Technical Articles

powa-archivist 5.2.0 is out!

www.postgresql.org

powa-archivist 5.2.0 is out!

powa-archivist 5.2.0 has been released by the PoWA team. This version adds support for PostgreSQL 19, including the new statistical views pg_stat_recovery and pg_stat_lock, contri…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Add pg_stat_vfdcache view for VFD cache statistics

The thread discusses adding a `pg_stat_vfdcache` view to expose VFD (Virtual File Descriptor) cache statistics for tuning `max_files_per_process`. Key design questions include whe…

Read Discussion
allow spread checkpoints when changing checksums online

The discussion concerns a patch to allow spread checkpoints during online checksum changes. Fujii Masao questioned whether reading `DataChecksumState->fast_checkpoint` without hol…

Read Discussion
Introduce XID age based replication slot invalidation

The discussion concerns a patch to invalidate replication slots based on XID age. The key design decision is how to handle slots held by active walsenders. Masahiko Sawada and Bha…

Read Discussion
SQL/JSON json_table plan clause

The discussion focuses on a multi-patch series fixing bugs in the SQL/JSON `JSON_TABLE` plan clause implementation. Thom Brown tested patches 0001–0003: 0001 fixes `ERROR ON EMPTY…

Read Discussion
Batching in executor

Denis Smirnov posted a WIP patch as a heap-only experiment related to the broader "Batching in executor" discussion. The patch modifies heap_getnextslot() to reuse visible tuple o…

Read Discussion
support create index on virtual generated column.

A patch to support creating indexes on virtual generated columns is under development (now at V6). ZizhuanLiu reports that CFBot test results reveal a truncation issue in the gene…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

Apple Sues OpenAI Over Alleged Trade Secret Theft

techcrunch.com

Apple Sues OpenAI Over Alleged Trade Secret Theft

Apple has filed a lawsuit against OpenAI, alleging the theft of trade secrets. According to Apple, the misconduct was directed by OpenAI's senior leadership, including a longtime…

Meta Removes Controversial AI Feature on Instagram After User Backlash

techcrunch.com

Meta Removes Controversial AI Feature on Instagram After User Backlash

Meta has pulled a controversial AI feature from Instagram following significant user backlash. The company stated in a blog post that the feature was intended as a useful creative…

Social Media Updates

linkedin

CYBERTEC CEO Hans-Juergen Schoenig on why self-healing, always-on infrastructure matters when the data actually matters, and why open source gives you options a vendor never will.

CYBERTEC CEO Hans-Juergen Schoenig discusses the importance of self-healing, always-on infrastructure for organizations where data reliability is critical. He argues that when dat…

linkedin

Pavlo Golub of Cybertec shares his talk "pgcov: Bringing Real Test Coverage to PostgreSQL Code" at POSETTE: An Event for Postgres 2026.

At POSETTE 2026, Pavlo Golub from Cybertec presented pgcov, a tool aimed at filling a gap in the PostgreSQL ecosystem. While developers rely heavily on PostgreSQL functions, proce…

linkedin

Thanks to everyone who stopped by and interacted with us at GITEX AI EUROPE 2026.

The author expresses gratitude to all attendees who visited and engaged with them at GITEX AI EUROPE 2026, reflecting briefly on the event as an incredible experience. No further…

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