- Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #196 2026-07-03
by pgnexus July 3, 2026

July 3, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Meeting in Montreal: Developer U plan(ner) patches] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fm…> enterprisedb.com Meeting in Montreal: Developer U plan(ner) patches <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fm…> A group of promising PostgreSQL developers participating in EDB's internal development program met in person in Montreal for the third time. The blog post summarizes the topics di… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fm…> PostgreSQL Hackers Email Discussion Highlights Don't use the deprecated and insecure PQcancel in our frontend tools anymore <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> Jelte Fennema-Nio posted v8 of a patch series to replace the deprecated and insecure PQcancel in frontend tools. The first two commits simplify existing cancellation logic and are… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> The discussion focuses on the Row Pattern Recognition (RPR) feature for PostgreSQL. Jian He submitted v50 patches refactoring how navigation offsets are evaluated: instead of reso… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> A few message wording/formatting cleanup patches <https://pgnexus.ai/hacker-discussions?subject=A%20few%20message%20wording%2…> Peter Eisentraut committed a patch series related to message wording and formatting cleanup in PostgreSQL. The discussion involved cosmetic improvements suggested by Ashutosh Bapa… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=A%20few%20message%20wording%2…> [PATCH] Fix for bug #19474: LIKE fails to match literal backslashes with nondeterministic collations <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20for%20bug…> The patch (v3) aims to fix bug #19474, where LIKE fails to match literal backslashes under nondeterministic collations. Tom Lane reviewed the latest version and concluded it is no… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20for%20bug…> uuidv7 improperly accepts dates before 1970-01-01 <https://pgnexus.ai/hacker-discussions?subject=uuidv7%20improperly%20accepts…> The thread addresses a bug where `uuidv7` improperly accepted timestamps before 1970-01-01. Baji Shaik submitted v4 of the patch, incorporating Masahiko Sawada's review feedback:… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=uuidv7%20improperly%20accepts…> [GSoC 2026] - B-tree Index Bloat Reduction - Approach & Questions <https://pgnexus.ai/hacker-discussions?subject=%5BGSoC%202026%5D%20-%20B-tre…> Andrey Borodin responds to a GSoC 2026 proposal for B-tree index bloat reduction, offering two design simplifications. First, he argues that forward-scan deduplication after a pag… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BGSoC%202026%5D%20-%20B-tre…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-03-postgresql-daily-news-196.…> Industry News [image: Anthropic Discusses Custom AI Chip Development with Samsung] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic Discusses Custom AI Chip Development with Samsung <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic is in discussions with Samsung to develop a new custom AI chip, according to a TechCrunch report. The news follows OpenAI's recent announcement of its own custom AI chip… [image: Mark Zuckerberg Tells Staff Meta's AI Agents Progressing Slower Than Expected] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Mark Zuckerberg Tells Staff Meta's AI Agents Progressing Slower Than Expected <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta CEO Mark Zuckerberg reportedly told employees at an internal meeting that the company's AI agent development has not advanced as quickly as he had hoped. The candid admission… Social Media Updates [image: Data checksums have been in Postgres since version 9.3.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Data checksums have been in Postgres since version 9.3. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Postgres has supported data checksums since version 9.3 in 2013, yet many production clusters still run without them. The main barrier was the enablement process: it required a fu… linkedin We believe the world is static. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC CEO Hans-Juergen Schoenig spoke at GITEX AI EUROPE about the growing instability shaping today's business environment. He highlighted geopolitics, cyber risk, and supply… linkedin Addepar , which supports nearly $9 trillion in assets on its platform, is using Databricks to unify data, analytics, and AI across its infrastructure. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Addepar, a platform managing nearly $9 trillion in assets, has standardized on Databricks to unify its data, analytics, and AI infrastructure. This foundation supports Addison, Ad… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #195 2026-07-02
by pgnexus July 2, 2026

July 2, 2026

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-…> Savannah Longoria Lakebase Search: vector and BM25 on Neon <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Flakebase-…> 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-…> [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%2F…> 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%2F…> 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%2F…> PostgreSQL Hackers Email Discussion Highlights Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> 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%20sys…> implement CAST(expr AS type FORMAT 'template') <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%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%20…'template')> remove VersionedQuery support from psql tab completion <https://pgnexus.ai/hacker-discussions?subject=remove%20VersionedQuery%20sup…> 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%20sup…> Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows <https://pgnexus.ai/hacker-discussions?subject=Fix%20RLS%20checks%20for%20UP…> 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%20UP…> Report bytes and transactions actually sent downtream <https://pgnexus.ai/hacker-discussions?subject=Report%20bytes%20and%20transa…> 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%20transa…> SQL:2011 Application Time Update & Delete <https://pgnexus.ai/hacker-discussions?subject=SQL%3A2011%20Application%20Ti…> 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%20Ti…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-02-postgresql-daily-news-195.…> 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%2…> 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%2…> 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%2…> techcrunch.com Meta quietly launches vibe-coded gaming app Pocket <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> 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%2…> techcrunch.com Anthropic is discussing a new custom chip with Samsung <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> 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%…> 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%…> 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%…> 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%…> 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

1 0

PGNexus Daily News #194 2026-07-01
by pgnexus July 1, 2026

July 1, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Expanding WarehousePG Cluster on existing hosts using gpexpand] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> enterprisedb.com Expanding WarehousePG Cluster on existing hosts using gpexpand <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> This article explains how to expand a WarehousePG cluster by adding new segments to existing hosts using the gpexpand utility. WarehousePG is EDB's fork of the formerly open-sourc… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> [image: Expanding WarehousePG Cluster on New Host(s) using gpexpand] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> enterprisedb.com Expanding WarehousePG Cluster on New Host(s) using gpexpand <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> A step-by-step guide covers expanding a WarehousePG cluster using the gpexpand utility. WarehousePG is EDB's fork of the formerly open-source Greenplum Database, built on an MPP a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> [image: What We Heard: Three Patterns from Spring 2026 Events] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Matty Stratton What We Heard: Three Patterns from Spring 2026 Events <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Tiger Data attended ten industry events in spring 2026 across Europe and the US, covering industrial, energy, IoT, and cloud infrastructure audiences. Three recurring patterns eme… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights postgres_fdw: fix cumulative stats after imported foreign-table stats <https://pgnexus.ai/hacker-discussions?subject=postgres_fdw%3A%20fix%20cumul…> This thread concerns a bug fix for postgres_fdw related to cumulative statistics becoming incorrect after importing foreign-table statistics. Chao Li originally identified the iss… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=postgres_fdw%3A%20fix%20cumul…> Make transformAExprIn() return a flattened bool expression directly <https://pgnexus.ai/hacker-discussions?subject=Make%20transformAExprIn()%20r…> Tom Lane opposes a proposal to have transformAExprIn() return flattened (non-binary) AND/OR nodes directly during parsing. The patch author agreed that performing this simplificat… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Make%20transformAExprIn()%20r…> bump minimum supported version of psql and pg_{dump,dumpall,upgrade} to v10 <https://pgnexus.ai/hacker-discussions?subject=bump%20minimum%20supported%20…> Nathan Bossart announced plans to commit a patch the following day that bumps the minimum supported server version for psql, pg_dump, pg_dumpall, and pg_upgrade to PostgreSQL v10.… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=bump%20minimum%20supported%20…> pg_createsubscriber --dry-run logging concerns <https://pgnexus.ai/hacker-discussions?subject=pg_createsubscriber%20--dry-r…> The discussion concerns improving the logging output format of `pg_createsubscriber --dry-run`. Peter Eisentraut proposed combining dry-run informational messages using a primary-… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_createsubscriber%20--dry-r…> POC: PLpgSQL FOREACH IN JSON ARRAY <https://pgnexus.ai/hacker-discussions?subject=POC%3A%20PLpgSQL%20FOREACH%20…> Tom Lane reviewed the v20260616 patch for adding FOREACH IN JSON ARRAY support to PLpgSQL. He raised concerns about insufficient separation of concerns: the type-specific setup ro… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=POC%3A%20PLpgSQL%20FOREACH%20…> Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> The discussion concerns adding a new `pg_stat_kind_info` system view to expose information about registered statistics kinds. Key debates involve the `count`/`entry_count` field s… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-01-postgresql-daily-news-194.…> Industry News [image: Neocloud Together AI Raises $800M, Reaches $8.3B Valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Neocloud Together AI Raises $800M, Reaches $8.3B Valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Together AI, an AI neocloud provider specializing in hosting open-source models, has raised $800 million in a new funding round, pushing its valuation to $8.3 billion. This repres… [image: Meta Plans Cloud Infrastructure Business to Monetize Excess AI Compute] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Meta Plans Cloud Infrastructure Business to Monetize Excess AI Compute <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta is developing plans to launch a cloud infrastructure business, selling access to its AI compute capacity and models to external customers. The move would directly challenge e… techcrunch.com Venice AI Raises $65M Series A, Achieves Unicorn Status with Privacy-First Platform <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Venice AI has raised $65 million in a Series A funding round, reaching unicorn status with a valuation exceeding $1 billion. The company operates a privacy-first AI platform and h… Social Media Updates [image: Team CYBERTEC from Day 2 at GITEX AI EUROPE .] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Team CYBERTEC from Day 2 at GITEX AI EUROPE . <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC is participating in GITEX AI EUROPE, sharing a photo from Day 2 of the event. The team is present at Booth H2.2-22 and invites attendees to stop by and connect with them… linkedin Our Patroni Suitcase was in the spotlight at GITEX AI EUROPE yesterday! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC showcased its Patroni Suitcase at GITEX AI EUROPE, where it drew notable attention. The demonstration is ongoing, and visitors can see the Patroni Suitcase live at Booth… [image: Ecolab built its Retail Intelligence application on Databricks and Anthropic's Claude to unify nine siloed data sources into a single intelligence engine.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Ecolab built its Retail Intelligence application on Databricks and Anthropic's Claude to unify nine siloed data sources into a single intelligence engine. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Ecolab developed its Retail Intelligence application using Databricks and Anthropic's Claude, consolidating nine previously siloed data sources into one unified intelligence engin… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #193 2026-06-30
by pgnexus June 30, 2026

June 30, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Too many tables are bad for you] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Laurenz Albe Too many tables are bad for you <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> A PostgreSQL database containing tens of thousands of tables can cause two serious problems: excessive memory usage and slow metadata queries. Each long-lived connection accumulat… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: Your Database Goes Down. What Does That Cost Your Business?] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fy…> enterprisedb.com Your Database Goes Down. What Does That Cost Your Business? <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fy…> EDB's blog post highlights that over 90% of mid-size and large enterprises report hourly downtime costs exceeding $300,000, yet high availability is often treated as a routine inf… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fy…> [image: The Oracle Renewal Is Coming. This Time, There’s a Way Out.] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fo…> enterprisedb.com The Oracle Renewal Is Coming. This Time, There’s a Way Out. <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fo…> EDB is promoting a migration path away from Oracle for organizations facing contract renewals, rising cloud costs, or stalled migration projects. The post positions PostgreSQL (vi… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fo…> [image: One Dashboard to Rule Them All — and Finally Get Your Fridays Back] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fo…> enterprisedb.com One Dashboard to Rule Them All — and Finally Get Your Fridays Back <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fo…> EDB has introduced a unified control plane for managing PostgreSQL deployments across on-premises, multi-cloud, and hybrid environments. The platform, EDB Postgres AI, aims to con… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fo…> [image: Your Database Should Be Working While You Sleep] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fy…> enterprisedb.com Your Database Should Be Working While You Sleep <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fy…> EDB Agentic Database is presented as a solution to the reactive, around-the-clock operational burden faced by teams managing PostgreSQL at scale. The piece describes the common sc… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fy…> [image: Inside the Agentic Database: How EDB Turned Postgres Into a Self-Managing System] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fi…> enterprisedb.com Inside the Agentic Database: How EDB Turned Postgres Into a Self-Managing System <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fi…> EDB has introduced what it calls the "Agentic Database," an autonomous management system embedded directly into PostgreSQL rather than implemented as an external service. The syst… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fi…> [image: The Architecture IS the Security: Building Sovereign AI Ops on Postgres with EDB Agent Factory] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> enterprisedb.com The Architecture IS the Security: Building Sovereign AI Ops on Postgres with EDB Agent Factory <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> EDB Agent Factory presents an architecture for AI-driven database incident response where all components run within a single PostgreSQL cluster. The stack combines pgvector for re… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> [image: Community Docker Images: keeping the operator open without a vendor registry lock-in] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> Slava Sarzhan Community Docker Images: keeping the operator open without a vendor registry lock-in <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> Percona Operator for PostgreSQL 3.0.0 introduces Community PostgreSQL Images, allowing users to run the operator against container images built from official PostgreSQL packages s… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> [image: Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Vigneshwaran C Closing a critical gap in PostgreSQL upgrade workflows with sequence synchronization <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL 19 introduces improvements to upgrade workflows using pg_upgrade and pg_createsubscriber, enabling near-zero-downtime upgrades by converting physical replicas into logi… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: How Float Runs an AI Energy Company on a 3-Person Team with Tiger Data] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Team Tiger Data How Float Runs an AI Energy Company on a 3-Person Team with Tiger Data <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Danish startup Float collects 1Hz smart meter data from hundreds of homes and uses a proprietary ML model to disaggregate total household load into per-appliance consumption. The… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> The discussion proposes aligning `wal_compression = on` with the recent change that made lz4 the default TOAST compression method in PostgreSQL when LZ4 support is available. Curr… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> [GSoC 2026] - B-tree Index Bloat Reduction - Approach & Questions <https://pgnexus.ai/hacker-discussions?subject=%5BGSoC%202026%5D%20-%20B-tre…> A GSoC 2026 contributor (Salma El-Sayed) proposes a new design for B-tree page merges in nbtree to reduce index bloat. The design repurposes the BTP_MERGED_AWAY flag—rather than u… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BGSoC%202026%5D%20-%20B-tre…> Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> The discussion concerns adding a new `pg_stat_kind_info` system view to expose metadata about PostgreSQL cumulative statistics kinds. A key concern raised is that the implementati… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> DDL deparse <https://pgnexus.ai/hacker-discussions?subject=DDL%20deparse> The discussion focuses on DDL deparse for logical replication, particularly how DDL commands should be formatted for external clients. Vitaly Davydov argues that simpler, decompos… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=DDL%20deparse> bump minimum supported version of psql and pg_{dump,dumpall,upgrade} to v10 <https://pgnexus.ai/hacker-discussions?subject=bump%20minimum%20supported%20…> The discussion concerns a patch series to raise the minimum supported old-cluster/server version for psql, pg_dump, pg_dumpall, and pg_upgrade from v9.2 to v10. Fujii Masao review… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=bump%20minimum%20supported%20…> GetBufferDescriptor() being called for local buffers from MarkBufferDirtyHint() <https://pgnexus.ai/hacker-discussions?subject=GetBufferDescriptor()%20being…> Ayush Tiwari is working on a patch to make buffer descriptor accessors (`GetBufferDescriptor()` and `GetLocalBufferDescriptor()`) accept signed indexes and include range assertion… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=GetBufferDescriptor()%20being…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-06-30-postgresql-daily-news-193.…> Industry News [image: Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Anthropic launches Claude Sonnet 5 as a cheaper alternative for AI agents <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Anthropic has launched Claude Sonnet 5, a new model designed to offer stronger agentic capabilities at a lower price point. The release positions Claude Sonnet 5 as a more cost-ef… [image: Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Nvidia rival Etched reaches $5B valuation with $1B in contracted AI chip sales <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> AI chip startup Etched, a competitor to Nvidia, has announced it has reached a $5 billion valuation and already secured $1 billion in contracted sales for inference systems powere… [image: Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Amazon launches $1B Field Deployment Engineering org to embed AI agents at enterprises <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Amazon has launched a new $1 billion Field Deployment Engineering (FDE) organization, following similar moves by OpenAI and Anthropic. Engineers on the new team will embed directl… Social Media Updates [image: We've posted a video of Jonathan Katz and Melanie Plageman delivering the Opening & Commemorative Poster Giveaway] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin We've posted a video of Jonathan Katz and Melanie Plageman delivering the Opening & Commemorative Poster Giveaway <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A video has been posted of Jonathan Katz and Melanie Plageman presenting the Opening session and Commemorative Poster Giveaway at PGConf Dev. The recording is available via the pr… [image: Almost every Postgres team I talk to runs into the same storage wall.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Almost every Postgres team I talk to runs into the same storage wall. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Most Postgres teams face the same problem: databases grow indefinitely, old data cannot be deleted for legal reasons, and storage costs keep rising. pgEdge built ColdFront to addr… linkedin Come take a stroll with CYBERTEC's Raj Verma - A first-person look at the sights, sounds, and energy of the GITEX AI EUROPE floor on day 1 <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Raj Verma from CYBERTEC offers a first-person walkthrough of the GITEX AI EUROPE exhibition floor on its opening day. The video or post captures the atmosphere, sights, and energy… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #192 2026-06-29
by pgnexus June 29, 2026

June 29, 2026

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%2F…> 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%2F…> 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%2F…> PostgreSQL Hackers Email Discussion Highlights Optimize UUID parse using SIMD <https://pgnexus.ai/hacker-discussions?subject=Optimize%20UUID%20parse%20usi…> 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%20usi…> implement CAST(expr AS type FORMAT 'template') <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%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%20…'template')> Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements <https://pgnexus.ai/hacker-discussions?subject=Revisiting%20%7BCREATE%20INDE…> 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%20INDE…> [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Add%20pg_get_ta…> 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_ta…> [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-r…> 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-r…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-06-29-postgresql-daily-news-192.…> Industry News [image: Arena AI Leaderboard Startup Reaches $100M Revenue Milestone] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Arena AI Leaderboard Startup Reaches $100M Revenue Milestone <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> 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%2…> 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%2…> 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%2…> 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%2…> 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%…> 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%…> 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%…> 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%…> 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%…> linkedin Building beautiful dashboards just got easier. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> 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

1 0

PGNexus Daily News #191 2026-06-28
by pgnexus June 28, 2026

June 28, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: pgtt v4.5 has been released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pgtt v4.5 has been released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pgtt v4.5 has been released as a maintenance update to the PostgreSQL extension that implements DB2- and Oracle-style Global Temporary Tables. This release adds support for Postgr… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights pg_get__*_ddl consolidation <https://pgnexus.ai/hacker-discussions?subject=pg_get__*_ddl%20consolidation> The thread discusses the consolidation of `pg_get_*_ddl` functions and the debate over their calling convention. Jelte Fennema-Nio argued against using a key-value pair calling co… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_get__*_ddl%20consolidation> Remove the refint contrib module (for v20) <https://pgnexus.ai/hacker-discussions?subject=Remove%20the%20refint%20contr…> The discussion concerns a patch to remove the `refint` contrib module for PostgreSQL v20. Álvaro Herrera points out a documentation inaccuracy: the patch states that Postgres 19 s… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Remove%20the%20refint%20contr…> [PATCH] Add pg_get_table_ddl() to reconstruct CREATE TABLE statements <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Add%20pg_get_ta…> Rui Zhao reviewed patch v11 of pg_get_table_ddl(), which reconstructs CREATE TABLE statements server-side. Testing on current master showed correct round-trips including VIRTUAL c… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Add%20pg_get_ta…> Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi is preparing for the next review round of the Row Pattern Recognition (RPR) patch series (v50). Two issues are flagged: first, cfbot is failing on v49 because a recent… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Report bytes and transactions actually sent downtream <https://pgnexus.ai/hacker-discussions?subject=Report%20bytes%20and%20transa…> The discussion concerns adding statistics to track bytes and transactions actually sent downstream in logical replication slots. A key debate involves whether to include protocol-… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Report%20bytes%20and%20transa…> Key joins <https://pgnexus.ai/hacker-discussions?subject=Key%20joins> Arne Roland reposted an updated patch set for the "Key joins" feature primarily to fix a psql issue with the test TTY layout, ensuring compatibility with the CF bot. No functional… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Key%20joins> Industry News [image: Asian AI startups launch Mythos-like models as Anthropic's export ban drags on] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Asian AI startups launch Mythos-like models as Anthropic's export ban drags on <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> As Anthropic's export restrictions continue, Asian AI startups are launching models that promise capabilities comparable to Mythos without the constraints of U.S. export controls.… techcrunch.com Trump Admin releases Anthropic Mythos to be used by more than 100 US companies, agencies <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> The Trump administration has authorized more than 100 U.S. companies and government agencies to use Anthropic's Mythos 5 AI model, including access for their non-American employee… [image: FTC gives Musk the OK to acquire SpaceX alumni startup Mesh] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com FTC gives Musk the OK to acquire SpaceX alumni startup Mesh <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> The U.S. Federal Trade Commission has cleared Elon Musk to proceed with the acquisition of Mesh, a startup founded by SpaceX alumni. Mesh emerged from stealth mode in February aft… Social Media Updates linkedin As data volumes and complexity grow, data engineers need scalable ways to build, manage, and optimize pipelines. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The Big Book of Data Engineering addresses the growing challenges data engineers face as data volumes and complexity increase. It covers proven patterns for scaling ETL processes,… linkedin Databricks Free Edition just got even better for builders. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks has expanded its Free Edition with several new features: Agent Bricks, Genie Code, Serverless GPUs, Lakebase, and Lakeflow Designer. With these additions, the Free Edit… linkedin Fuzzing throws malformed, unexpected input at software to find the bugs humans miss. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> At POSETTE: An Event for Postgres 2026, Microsoft's Adam Wolk presented a practical guide to fuzzing in the context of PostgreSQL. Fuzzing works by sending malformed or unexpected… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #190 2026-06-27
by pgnexus June 27, 2026

June 27, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Do not lock tables in get_tables_to_repack <https://pgnexus.ai/hacker-discussions?subject=Do%20not%20lock%20tables%20in…> The discussion concerns a proposed change to pg_repack's `get_tables_to_repack` function. The author (cca5507) notes that during whole-database repacks, locks taken on tables to p… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Do%20not%20lock%20tables%20in…> Handle concurrent drop when doing whole database vacuum <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> The discussion addresses handling concurrent relation drops during whole-database VACUUM. A v5 patch has been shared and received an LGTM from Bharath Rupireddy. A minor suggestio… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> Move FOR PORTION OF checks out of analysis <https://pgnexus.ai/hacker-discussions?subject=Move%20FOR%20PORTION%20OF%20c…> Peter Eisentraut reviewed Paul A Jungwirth's patches (v9/v10) for moving FOR PORTION OF checks out of analysis. Patch 0002, which moves the volatile check into the planner, was co… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Move%20FOR%20PORTION%20OF%20c…> Why clearing the VM doesn't require registering vm buffer in wal record <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> The thread discusses a bug fix related to visibility map (VM) buffer registration in WAL records. Robert Haas noted that patches appeared based on an old commit and requested a re… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> DDL deparse <https://pgnexus.ai/hacker-discussions?subject=DDL%20deparse> The discussion centers on DDL deparse design for PostgreSQL, particularly around preserving user intent versus generating replication-friendly output. Masahiko Sawada and Vitaly D… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=DDL%20deparse> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> The discussion continues refining the conflict log history table (CLT) for logical replication. Key updates include: using `json` instead of `jsonb` for tuple columns (`remote_tup… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> Social Media Updates [image: 50 stars on GitHub.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin 50 stars on GitHub. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The pg_hardstorage project, launched recently, has reached 50 stars on GitHub within days of its release. The author thanks the PostgreSQL community for their early support, notin… linkedin Still catching up on everything from #DataAISummit 2026? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The 2026 Data + AI Summit brought together leading experts, researchers, and open source contributors from Databricks and the broader community. Attendees shared the latest innova… [image: Ticket prices for PGConf.EU 2026 have been announced, and registration opens on 7 July!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Ticket prices for PGConf.EU 2026 have been announced, and registration opens on 7 July! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Ticket prices for PGConf.EU 2026 have been announced ahead of registration opening on 7 July. Prospective attendees are encouraged to review the pricing options and begin planning… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #189 2026-06-26
by pgnexus June 26, 2026

June 26, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: pg_qualstats 2.1.4 is out!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg_qualstats 2.1.4 is out! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg_qualstats 2.1.4 has been released by the PoWA team. This PostgreSQL extension tracks statistics on predicates in WHERE clauses and JOIN conditions. The update includes a bug fi… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: pg_stat_kcache 2.3.2 is out!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg_stat_kcache 2.3.2 is out! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg_stat_kcache 2.3.2 has been released by the PoWA team. This extension collects filesystem-level read/write statistics and CPU usage data for PostgreSQL. The update adds compatib… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pgEdge has announced ColdFront, an open-source PostgreSQL extension providing transparent data tiering between hot PostgreSQL storage and cold Apache Iceberg (Parquet on S3-compat… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: IvorySQL 5.4 Released - Based on PostgreSQL 18.4 with AI Skills] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org IvorySQL 5.4 Released - Based on PostgreSQL 18.4 with AI Skills <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> IvorySQL 5.4 has been released, based on PostgreSQL 18.4 and inheriting all upstream fixes from that version. Key additions include IvorySQL Skills, which integrates AI assistant… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: PGDay.UK 2026: Schedule up, registration open] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PGDay.UK 2026: Schedule up, registration open <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PGDay.UK 2026 is scheduled for September 8, 2026, at the Cavendish Conference Centre in London. The event will feature seven speakers and seven talks. Registration is now open, wi… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi posted two follow-ups to the Row Pattern Recognition (RPR) patch thread. First, he noted that Haibo Yan's patch series adding DISTINCT support to plain aggregate windo… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Improve pg_stat_statements scalability <https://pgnexus.ai/hacker-discussions?subject=Improve%20pg_stat_statements%…> Sami Imseih provides an update on improving pg_stat_statements scalability after a period of silence. He explains that passing a context flag to flush callbacks is unnecessary, si… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Improve%20pg_stat_statements%…> enhance wraparound warnings <https://pgnexus.ai/hacker-discussions?subject=enhance%20wraparound%20warnin…> The discussion centers on refining the wording of PostgreSQL transaction ID wraparound warning messages. Fujii Masao updated patches to use phrasing like "Approximately X% of tran… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=enhance%20wraparound%20warnin…> Handle concurrent drop when doing whole database vacuum <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> The thread discusses how to handle concurrent relation drops during a whole-database VACUUM. Michael Paquier proposed moving the ACL check out of `get_all_vacuum_rels()` and alway… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> Fix race condition in pg_get_publication_tables with concurrent DROP TABLE <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%2…> The thread discusses fixing a race condition in `pg_get_publication_tables` when a table is dropped concurrently. The agreed fix is to call `try_table_open()` for all tables regar… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%2…> Why clearing the VM doesn't require registering vm buffer in wal record <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> The discussion concerns why clearing the visibility map (VM) does not require registering the VM buffer in the WAL record. Melanie Plageman submitted v3 patches (targeting Postgre… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-06-26-postgresql-daily-news-189.…> Industry News techcrunch.com OpenAI Poaches Uber India Chief to Lead India Operations <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> OpenAI has hired the former head of Uber India to lead its operations in India, the company's largest market outside the United States. The move is part of OpenAI's broader push i… [image: OpenAI Limits GPT-5.6 Rollout After U.S. Government Request] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com OpenAI Limits GPT-5.6 Rollout After U.S. Government Request <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> OpenAI has restricted the rollout of its latest model, GPT-5.6, following a request from the Trump administration over safety concerns. Rather than releasing it to the general pub… [image: Russian Hackers Linked to $2.5B Jaguar Land Rover Cyberattack] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Russian Hackers Linked to $2.5B Jaguar Land Rover Cyberattack <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> A new report attributes the massive cyberattack on Jaguar Land Rover to Russian hackers. Described as one of the most disruptive, damaging, and costly hacks in recent years, the b… Social Media Updates linkedin Will we be seeing you at GITEX AI EUROPE - Europe's Leading Tech & AI Event ? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> GITEX AI EUROPE will be held in Berlin, Germany's largest German-speaking city. Attendees who have time to explore the city are encouraged to visit landmarks such as the Brandenbu… [image: how will I recognize you at the conference?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin how will I recognize you at the conference? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> At a conference, someone asks how they will recognize another attendee. The response is simple: they will be wearing blue and yellow, referencing those specific colors as a way to… linkedin You relied on PostgreSQL today without knowing it. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> PostgreSQL operates silently behind many critical systems people use daily, including hospitals, train networks, factories, and payment platforms. Despite rarely being visible to… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #188 2026-06-25
by pgnexus June 25, 2026

June 25, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Running pgvector in production on Amazon Aurora PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Stefan Aichholzer Running pgvector in production on Amazon Aurora PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> This post covers operational best practices for running pgvector on Amazon Aurora PostgreSQL, targeting production RAG workloads. It addresses index selection between HNSW and IVF… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Heterogeneous Graphs in SQL/PGQ on PostgreSQL 19] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Hans-Jürgen Schönig Heterogeneous Graphs in SQL/PGQ on PostgreSQL 19 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> This article explores heterogeneous graph modeling using SQL/PGQ in PostgreSQL 19. It demonstrates how to define a property graph with multiple vertex and edge types (persons, com… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: The Role of AI in Data Analytics: Moving From Hype to High-Octane Utility] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fr…> enterprisedb.com The Role of AI in Data Analytics: Moving From Hype to High-Octane Utility <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fr…> AI is increasingly applied to data analytics, but a significant gap exists between marketing claims and practical value. Traditional analytics — SQL queries, ETL pipelines, and BI… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fr…> [image: PGX announces support for EOL versions of PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PGX announces support for EOL versions of PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PGX has launched PGX Longevity, a commercial service offering critical security patches and data integrity bug fixes for PostgreSQL versions that have reached end-of-life (EOL), c… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: What You’re Really Owning When You Self-Host TimescaleDB] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Matty Stratton What You’re Really Owning When You Self-Host TimescaleDB <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Self-hosting TimescaleDB for mission-critical workloads is not a database decision—it is a platform engineering commitment. This article, written by the TimescaleDB team, walks th… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights Handle concurrent drop when doing whole database vacuum <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> The thread discusses fixing a race condition where a concurrent DROP can cause errors during whole-database VACUUM. The current v3 patch adds ACL-check logic in `vacuum_is_permitt… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> bytea(uuid) missing proleakproof? <https://pgnexus.ai/hacker-discussions?subject=bytea(uuid)%20missing%20prole…> Chao Li reported that the `bytea(uuid)` function introduced by commit `ba21f5bf8` (which added explicit casting between `bytea` and `uuid`) was not marked as `proleakproof`, unlik… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=bytea(uuid)%20missing%20prole…> Optimize UUID parse using SIMD <https://pgnexus.ai/hacker-discussions?subject=Optimize%20UUID%20parse%20usi…> Masahiko Sawada proposed optimizing UUID parsing by reusing the SIMD-accelerated hex_decode_safe() function introduced in commit ec8719ccbfcd. Benchmarks show a ~5× speedup for uu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Optimize%20UUID%20parse%20usi…> pg_stat_statements: Remove (errcode...) framing parentheses in erport(...) <https://pgnexus.ai/hacker-discussions?subject=pg_stat_statements%3A%20Remov…> Mikhail Litsarev proposed a small cleanup patch for pg_stat_statements to remove unnecessary parentheses wrapping the errcode() macro inside ereport() calls, following commit e3a8… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_stat_statements%3A%20Remov…> glob support in extension_control_path/dynamic_library_path? <https://pgnexus.ai/hacker-discussions?subject=glob%20support%20in%20extensi…> The thread discusses a proposed patch to add glob pattern support to `extension_control_path` and `dynamic_library_path`. Zsolt Parragi raises security and observability concerns:… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=glob%20support%20in%20extensi…> enhance wraparound warnings <https://pgnexus.ai/hacker-discussions?subject=enhance%20wraparound%20warnin…> The thread discusses enhancements to PostgreSQL's wraparound warning messages for transaction IDs and MultiXactIds. A key point of debate is wording: Fujii Masao used "transaction… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=enhance%20wraparound%20warnin…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-06-25-postgresql-daily-news-188.…> Industry News [image: Anthropic's Claude gains ground in paid AI consumer market against ChatGPT] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Anthropic's Claude gains ground in paid AI consumer market against ChatGPT <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Despite ChatGPT's dominant market position, paying consumers are increasingly choosing Anthropic's Claude, according to new data. The trend highlights a shift in the competitive l… [image: Patronus AI raises $50M to build simulation environments for stress-testing AI agents] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Patronus AI raises $50M to build simulation environments for stress-testing AI agents <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Patronus AI, an agent testing startup founded by former Meta AI researchers, has secured $50 million in funding to develop "digital worlds" designed to stress-test AI agents. The… [image: Adobe acquires image and video enhancement tool maker Topaz Labs] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Adobe acquires image and video enhancement tool maker Topaz Labs <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Adobe has announced the acquisition of Topaz Labs, a company known for its AI-powered image and video enhancement tools. Adobe stated it plans to integrate Topaz Labs' technology… Social Media Updates [image: Our team has landed in Rapperswil and the CYBERTEC booth is open!🐘 If you're at Swiss PGDay 2026 today, two reasons to stop what you're doing: 11:20 to 12:10 → Laurenz Albe on "The anatomy of PostgreSQL row locks" 15:40 to 16:30 → Pavlo Golub on "Getting Started with pgwatch: Features, Installation, and Use Cases" Between sessions, come find Rajneesh Verma , Mat Godolphin , Matthias Grömmer and Svitlana Lytvynenko at the booth.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Our team has landed in Rapperswil and the CYBERTEC booth is open!🐘 If you're at Swiss PGDay 2026 today, two reasons to stop what you're doing: 11:20 to 12:10 → Laurenz Albe on "The anatomy of PostgreSQL row locks" 15:40 to 16:30 → Pavlo Golub on "Getting Started with pgwatch: Features, Installation, and Use Cases" Between sessions, come find Rajneesh Verma , Mat Godolphin , Matthias Grömmer and Svitlana Lytvynenko at the booth. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC's team is attending Swiss PGDay 2026 in Rapperswil with an open booth. Two talks are scheduled: Laurenz Albe presents 'The anatomy of PostgreSQL row locks' from 11:20 to… linkedin Databricks co-founders Matei Zaharia and Reynold Xin joined Latent Space following #DataAISummit to discuss the ideas shaping the next generation of data and AI, including Omnigent, LTAP, Lakebase, agent security, open formats, and what it takes to build for the agent era. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks co-founders Matei Zaharia and Reynold Xin appeared on Latent Space after the Data and AI Summit to discuss key ideas driving the next generation of data and AI infrastr… [image: Databricks co-founder and CEO Ali Ghodsi joined Edward Ludlow on Bloomberg Tech to make the case that enterprise AI is already smart enough.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Databricks co-founder and CEO Ali Ghodsi joined Edward Ludlow on Bloomberg Tech to make the case that enterprise AI is already smart enough. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks co-founder and CEO Ali Ghodsi appeared on Bloomberg Tech to argue that enterprise AI has reached sufficient intelligence. The real obstacle limiting AI agents, he says,… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #187 2026-06-24
by pgnexus June 24, 2026

June 24, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Meeting EU Data Sovereignty Requirements While Speeding-Up Innovation] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fm…> enterprisedb.com Meeting EU Data Sovereignty Requirements While Speeding-Up Innovation <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fm…> EU data sovereignty has become a board-level priority following the European Commission's June 2026 European Tech Sovereignty package, which encourages organizations—especially in… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fm…> [image: Inside EDB’s New Principles for Responsible AI: Sovereign, Governed, Trusted and Beneficial] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fi…> enterprisedb.com Inside EDB’s New Principles for Responsible AI: Sovereign, Governed, Trusted and Beneficial <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fi…> EDB has updated its Principles for Responsible AI, originally released in 2024, in response to growing enterprise concerns around governance, transparency, security, and data cont… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fi…> [image: Postgres Sorting at Scale Needs More Than ORDER BY] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> NanoHertz Communications Postgres Sorting at Scale Needs More Than ORDER BY <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Sorting large PostgreSQL tables by timestamp degrades significantly at scale. A query running in 180ms at 10 million rows can take 4 seconds at 500 million, even with an existing… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights Handle concurrent drop when doing whole database vacuum <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> The discussion focuses on how whole-database VACUUM handles concurrent relation drops. The patch (v3) fixes the issue by emitting a WARNING when a relation is concurrently dropped… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> Small patch to improve safety of utf8_to_unicode(). <https://pgnexus.ai/hacker-discussions?subject=Small%20patch%20to%20improve%….> Jeff Davis posted v5 of a patch series improving UTF-8 safety in `utf8_to_unicode()`. The series includes: a backportable defensive fix for invalid UTF-8 handling, a logic bug fix… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Small%20patch%20to%20improve%….> Add MIN/MAX aggregate support for uuid <https://pgnexus.ai/hacker-discussions?subject=Add%20MIN%2FMAX%20aggregate%2…> Tristan Partin proposed adding MIN/MAX aggregate support for the uuid type in PostgreSQL, motivated primarily by the UUIDv7 use case where lexicographic ordering corresponds to ti… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20MIN%2FMAX%20aggregate%2…> glob support in extension_control_path/dynamic_library_path? <https://pgnexus.ai/hacker-discussions?subject=glob%20support%20in%20extensi…> A patch by Jakob Egger proposes adding glob/wildcard support to `extension_control_path` and `dynamic_library_path`, falling back to existing behavior on Windows. David E. Wheeler… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=glob%20support%20in%20extensi…> uuidv7 improperly accepts dates before 1970-01-01 <https://pgnexus.ai/hacker-discussions?subject=uuidv7%20improperly%20accepts…> The discussion addresses a bug where `uuidv7()` improperly accepts timestamps outside its valid range. Baji Shaik submitted a three-patch series: rejecting timestamps before the U… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=uuidv7%20improperly%20accepts…> Adding basic NUMA awareness <https://pgnexus.ai/hacker-discussions?subject=Adding%20basic%20NUMA%20aware…> Tomas Vondra posted an updated patch series for adding basic NUMA awareness to PostgreSQL. The two key fixes address mbind issues: correcting the nodemask size so partitions bind… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Adding%20basic%20NUMA%20aware…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-06-24-postgresql-daily-news-187.…> Industry News [image: OpenAI Unveils First Custom AI Chip "Jalapeño" Built by Broadcom] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com OpenAI Unveils First Custom AI Chip "Jalapeño" Built by Broadcom <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> OpenAI has revealed its first custom-designed processor, named Jalapeño, developed in partnership with Broadcom. The chip was purpose-built to meet the specific demands of OpenAI'… [image: Facebook Launches AI Companion App for Content Creators] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> techcrunch.com Facebook Launches AI Companion App for Content Creators <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F06%2…> Facebook is rolling out a new AI companion app aimed at content creators, currently being tested with a select group. The app integrates Facebook's recently launched AI creator as… Social Media Updates [image: Every database eventually runs into the same wall: storage costs money, and the data nobody queries anymore costs exactly as much as the data everyone does.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Every database eventually runs into the same wall: storage costs money, and the data nobody queries anymore costs exactly as much as the data everyone does. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> All databases face the same cost problem: rarely accessed data occupies the same expensive block storage as frequently queried data. The common proposed solution is to move cold d… linkedin Less than a week to go until GITEX AI EUROPE - Europe's Leading Tech & AI Event and our team is super excited to attend! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> GITEX AI EUROPE, described as Europe's leading technology and AI event, is less than a week away. The team is looking forward to attending and invites visitors to meet them at the… linkedin CYBERTEC CEO Hans-Juergen Schoenig introduces pg_hardstorage, a new open-source backup and point-in-time recovery tool for PostgreSQL, released under the Apache 2.0 license. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC CEO Hans-Juergen Schoenig has announced pg_hardstorage, an open-source backup and point-in-time recovery tool for PostgreSQL. Originally developed internally at CYBERTEC,… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0