PGNexus Daily News #195 2026-07-02
PGNexus Daily News PostgreSQL Technical Articles [image: Lakebase Search: vector and BM25 on Neon] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Flakebase-s...> Savannah Longoria Lakebase Search: vector and BM25 on Neon <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Flakebase-s...> Neon has released a beta of Lakebase Search, introducing two PostgreSQL extensions—lakebase_vector and lakebase_text—that enable hybrid vector and full-text search. The vector com… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Flakebase-s...> [image: 10 enterprise database features that regulated industries should prioritize in 2026] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Timothy Steward 10 enterprise database features that regulated industries should prioritize in 2026 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Timothy Steward outlines ten PostgreSQL features that regulated industries should prioritize heading into 2026. As data volumes increase and compliance requirements tighten, organ… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> [image: AI's Physical Constraints: How AI Rewired the Data Center] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fh...> Hien Phan AI's Physical Constraints: How AI Rewired the Data Center <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fh...> AI infrastructure has hit fundamental physical limits that reshape data center design. Modern AI racks like NVIDIA's GB300 NVL72 draw up to 140 kW, roughly ten times traditional r… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fh...> PostgreSQL Hackers Email Discussion Highlights Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20syst...> The discussion concerns adding a `pg_stat_kind_info` system view to PostgreSQL. A specific point of contention was whether to include an `entry_size` field to help calculate memor… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20syst...> 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. Haibo Yan updated the patch to use `CREATE FORMAT CAST` and a separate `pg_format_cast` cat… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%20type%20FORMAT%20'template')> remove VersionedQuery support from psql tab completion <https://pgnexus.ai/hacker-discussions?subject=remove%20VersionedQuery%20supp...> Nathan Bossart proposed removing the `VersionedQuery` infrastructure from psql tab completion, noting it was introduced by commit 722408bcd1 solely for publications and subscripti… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=remove%20VersionedQuery%20supp...> Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows <https://pgnexus.ai/hacker-discussions?subject=Fix%20RLS%20checks%20for%20UPD...> The discussion addresses a security gap in temporal table operations: `UPDATE/DELETE FOR PORTION OF` can implicitly insert "leftover" rows to preserve history outside the target r… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20RLS%20checks%20for%20UPD...> Report bytes and transactions actually sent downtream <https://pgnexus.ai/hacker-discussions?subject=Report%20bytes%20and%20transac...> The discussion centers on a patch to report bytes and transactions actually sent downstream via logical replication, tracked through new statistics fields. Masahiko Sawada previou… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Report%20bytes%20and%20transac...> SQL:2011 Application Time Update & Delete <https://pgnexus.ai/hacker-discussions?subject=SQL%3A2011%20Application%20Tim...> Paul A Jungwirth is working on SQL:2011 application-time (temporal) UPDATE FOR PORTION OF support in PostgreSQL. The current patch discussion focuses on whether PostgreSQL should… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%3A2011%20Application%20Tim...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-02-postgresql-daily-news-195.m...> Industry News [image: Microsoft launches its own AI deployment company with $2.5 billion commitment] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Microsoft launches its own AI deployment company with $2.5 billion commitment <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Microsoft has launched a new AI deployment company backed by a $2.5 billion commitment, joining Amazon, OpenAI, and Anthropic in establishing dedicated AI deployment operations. T… [image: Meta quietly launches vibe-coded gaming app Pocket] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Meta quietly launches vibe-coded gaming app Pocket <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Meta has quietly launched Pocket, an experimental AI-powered app that enables users to generate and share interactive mini games using text prompts. The low-key release suggests M… [image: Anthropic is discussing a new custom chip with Samsung] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Anthropic is discussing a new custom chip with Samsung <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> Anthropic is in discussions with Samsung to develop a new custom AI chip, according to reports. The talks come roughly a week after OpenAI announced its own custom AI chip partner… Social Media Updates [image: Too many tables in a single PostgreSQL database can quietly cause memory starvation, OOM crashes, and long-running metadata queries.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Too many tables in a single PostgreSQL database can quietly cause memory starvation, OOM crashes, and long-running metadata queries. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Having too many tables in a single PostgreSQL database can lead to serious hidden problems, including memory starvation, out-of-memory crashes, and slow metadata queries. CYBERTEC… linkedin #DataAISummit 2026 was packed with product announcements, hands-on training, and technical insights. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> DataAISummit 2026 featured a range of product announcements, hands-on training sessions, and technical insights. For those who missed the event, keynotes and select breakout sessi… linkedin [DEMO] Agentic coding is moving faster than ever. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Agentic coding is accelerating, and databases must keep pace. Lakebase Branching addresses this by creating isolated, ephemeral database environments that allow AI coding agents t… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more
participants (1)
-
pgnexus