PGNexus Daily News PostgreSQL Technical Articles [image: How Small Postgres Metadata Tables Quietly Throttle Your Largest Queries] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fs...> NanoHertz Communications How Small Postgres Metadata Tables Quietly Throttle Your Largest Queries <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fs...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fs...> PostgreSQL Hackers Email Discussion Highlights Optimize UUID parse using SIMD <https://pgnexus.ai/hacker-discussions?subject=Optimize%20UUID%20parse%20usin...> 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 <https://pgnexus.ai/hacker-discussions?subject=Optimize%20UUID%20parse%20usin...> implement CAST(expr AS type FORMAT 'template') <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%20type%20FORMAT%20'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 <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%20type%20FORMAT%20'template')> Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements <https://pgnexus.ai/hacker-discussions?subject=Revisiting%20%7BCREATE%20INDEX...> 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 <https://pgnexus.ai/hacker-discussions?subject=Revisiting%20%7BCREATE%20INDEX...> [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Add%20pg_get_tab...> 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 <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Add%20pg_get_tab...> [PATCH] Don't call ereport(ERROR) from recovery target GUC assign hooks <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Don't%20call%20ereport(ERROR)%20from%20recovery%20target%20GUC%20assign%20hooks> 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 <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Don't%20call%20ereport(ERROR)%20from%20recovery%20target%20GUC%20assign%20hooks> pg_createsubscriber --dry-run logging concerns <https://pgnexus.ai/hacker-discussions?subject=pg_createsubscriber%20--dry-ru...> 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 <https://pgnexus.ai/hacker-discussions?subject=pg_createsubscriber%20--dry-ru...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-06-29-postgresql-daily-news-192.m...> Industry News [image: Arena AI Leaderboard Startup Reaches $100M Revenue Milestone] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Arena AI Leaderboard Startup Reaches $100M Revenue Milestone <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> 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… [image: Anthropic Partners with California Government to Offer Claude at Half Price] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Anthropic Partners with California Government to Offer Claude at Half Price <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> 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… [image: Chamath Palihapitiya Raises $135M Series A for AI Coding Startup, Takes CEO Role] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> techcrunch.com Chamath Palihapitiya Raises $135M Series A for AI Coding Startup, Takes CEO Role <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2F...> 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 [image: #SwissPGDay 2026 has come and gone, and Laurenz Albe was there to soak it all in (lake Zürich included).] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin #SwissPGDay 2026 has come and gone, and Laurenz Albe was there to soak it all in (lake Zürich included). <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… [image: 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!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin 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! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… [image: Building beautiful dashboards just got easier.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Building beautiful dashboards just got easier. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more