PGNexus Daily News PostgreSQL Technical Articles [image: How Castform + Neon Beats Frontier Models on Price and Efficiency] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fhow-castfo...> Pranav Aurora How Castform + Neon Beats Frontier Models on Price and Efficiency <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fhow-castfo...> Castform, an AI data pipeline tool, integrates with Neon's serverless PostgreSQL to generate high-quality training datasets directly from existing database content. According to C… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fhow-castfo...> PostgreSQL Hackers Email Discussion Highlights Fix archive restore race that could unlink WAL before rename <https://pgnexus.ai/hacker-discussions?subject=Fix%20archive%20restore%20race...> The discussion concerns a race condition in archive restore where a WAL segment could be unlinked before a rename completes. Neil Chen tested the v2 patch and found that the walse… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20archive%20restore%20race...> postgres_fdw: Use COPY to speed up batch inserts <https://pgnexus.ai/hacker-discussions?subject=postgres_fdw%3A%20Use%20COPY%2...> Matheus Alcantara proposes a new patch for speeding up `postgres_fdw` batch inserts by using the COPY protocol. After off-list discussion with Masahiko, the approach adds a dedica… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=postgres_fdw%3A%20Use%20COPY%2...> ri_Fast* crash w/ nullable UNIQUE constraint <https://pgnexus.ai/hacker-discussions?subject=ri_Fast*%20crash%20w%2F%20null...> The thread discusses a bug fix for ri_Fast* crashes with nullable UNIQUE constraints. Ayush Tiwari reviewed Amit Langote's v2 patch series (0001–0006). Patches 0001–0003, 0005, an… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=ri_Fast*%20crash%20w%2F%20null...> Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements <https://pgnexus.ai/hacker-discussions?subject=Revisiting%20%7BCREATE%20INDEX...> Matthias van de Meent provides a partial review of Mihail Nikalayeu's rebased patch series for improving CREATE INDEX / REINDEX CONCURRENTLY. Patch 0001 is skipped. For 0002, issu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Revisiting%20%7BCREATE%20INDEX...> [PATCH] Rebuild CHECK constraints after generated column SET EXPRESSION <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Rebuild%20CHECK%...> The discussion concerns a patch committed in PG19 to rebuild CHECK constraints after a generated column's SET EXPRESSION. Nathan Bossart questioned whether it should remain on the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Rebuild%20CHECK%...> CREATE OR REPLACE MATERIALIZED VIEW <https://pgnexus.ai/hacker-discussions?subject=CREATE%20OR%20REPLACE%20MATERI...> Paul A Jungwirth, along with Warda Bibi and Khoa Nguyen, reviewed the v8 patch for `CREATE OR REPLACE MATERIALIZED VIEW`. Key issues raised include: a segfault when event triggers… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=CREATE%20OR%20REPLACE%20MATERI...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-05-postgresql-daily-news-229.m...> Industry News [image: Jeff Dean and Other Top AI Researchers Leave Google to Launch AI Startup] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Jeff Dean and Other Top AI Researchers Leave Google to Launch AI Startup <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Legendary Google executive Jeff Dean, joined by other senior Google researchers, is departing the company to launch an independent AI startup. The venture is focused on using arti… [image: Trump's DOJ Gains Oversight of OpenAI's Green-Card Employee Sponsorships] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Trump's DOJ Gains Oversight of OpenAI's Green-Card Employee Sponsorships <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> The U.S. Department of Justice under the Trump administration has gained oversight authority over OpenAI's green-card sponsorship program for immigrant employees. The DOJ has alle… [image: Anthropic Begins Hiring for Custom AI Chip Design Team] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Anthropic Begins Hiring for Custom AI Chip Design Team <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Anthropic, the company behind the Claude AI models, is building a dedicated team to design its own custom AI chips. The company stated it plans to co-design both hardware and AI m… Social Media Updates [image: Next Tuesday: the engineer who built open-source, transparent hot/cold tiering for PostgreSQL (ColdFront) will be discussing the architecture live.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Next Tuesday: the engineer who built open-source, transparent hot/cold tiering for PostgreSQL (ColdFront) will be discussing the architecture live. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> On August 19 at 8 AM Pacific, the engineers behind ColdFront will host a live session covering the architecture of this open-source hot/cold tiering extension for PostgreSQL. Cold… [image: Legacy applications get expensive in two directions at once: they need more effort to maintain, and they're harder to change when the business needs something new.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Legacy applications get expensive in two directions at once: they need more effort to maintain, and they're harder to change when the business needs something new. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Legacy applications create a double burden: rising maintenance costs and increasing difficulty adapting to new business requirements. CYPEX offers a path forward by migrating appl… linkedin Move from tokenmaxxing to valuemaxxing. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Databricks Co-founder and CTO Matei Zaharia and Product Director Kasey Uhlenhuth will host a live session on August 13 covering Unity AI Gateway, a tool designed to give IT leader… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more