PostgreSQL Technical Articles

NanoHertz Communications

How Small Postgres Metadata Tables Quietly Throttle Your Largest Queries

Stale statistics on small metadata tables can silently degrade PostgreSQL query performance. When a devices table grows from 600 to 10,000 rows but pg_statistic reflects outdated…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Optimize UUID parse using SIMD

Masahiko Sawada proposed optimizing UUID parsing in the `uuid_in()` function by reusing the SIMD-aware `hex_decode_safe()` introduced in commit ec8719ccbfcd. Benchmarks show parsi…

Read Discussion

implement CAST(expr AS type FORMAT 'template')

The thread discusses implementing `CAST(expr AS type FORMAT 'template')` in PostgreSQL. Robert Haas rejected the earlier v7 patch as too narrow—it hardcoded calls to `to_date`, `t…

Read Discussion

Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements

The thread concerns proposed improvements to CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY in PostgreSQL. The latest message from Mihail Nikalayeu is brief, simply noting tha…

Read Discussion

[PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements

The patch adds a new server-side function `pg_get_table_ddl()` to reconstruct `CREATE TABLE` statements. Reviewer Rui Zhao tested v11 and identified several issues: a real bug in…

Read Discussion

[PATCH] Don't call ereport(ERROR) from recovery target GUC assign hooks

JoongHyuk Shin submitted v7 of a patch that prevents `ereport(ERROR)` calls from recovery target GUC assign hooks. The revised approach moves conflict detection into `validateReco…

Read Discussion

pg_createsubscriber --dry-run logging concerns

Peter Eisentraut proposed a follow-up patch to improve the `pg_createsubscriber` dry-run info message formatting. Earlier in the thread, a request had been made to combine the dry…

Read Discussion

Industry News

techcrunch.com

Arena AI Leaderboard Startup Reaches $100M Revenue Milestone

Arena, the startup behind a widely used AI model leaderboard, has reached $100 million in annual revenue, according to TechCrunch. The company launched its commercial service only…

techcrunch.com

Anthropic Partners with California Government to Offer Claude at Half Price

Anthropic has struck a deal with California Governor Gavin Newsom to provide state government agencies access to its Claude AI at half the standard price. The agreement deepens An…

techcrunch.com

Chamath Palihapitiya Raises $135M Series A for AI Coding Startup, Takes CEO Role

Investor Chamath Palihapitiya has raised a $135 million Series A round for his AI coding startup and has assumed the role of CEO. The funding round reflects continued strong inves…

Social Media Updates

#SwissPGDay 2026 has come and gone, and Laurenz Albe was there to soak it all in (lake Zürich included).

SwissPGDay 2026 has concluded, and Laurenz Albe attended the event in Zürich. He has written a personal and candid reflection on his experience, exploring what continues to draw p…

The Countdown to GITEX AI EUROPE - Europe's Leading Tech & AI Event has officially moved from days to hours – and our team is making their way to Berlin to talk tech with you!

CYBERTEC is heading to GITEX AI EUROPE in Berlin, one of Europe's leading technology and AI events. The team will be available at Stand H2.2-22, Hall 2.2, Messe Berlin, on June 30…

Building beautiful dashboards just got easier.

AI/BI has introduced new dashboard and workspace theme options that allow users to customize fonts, colors, and visualization palettes for a consistent, on-brand appearance. Theme…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates