- Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #266 2026-09-11
by pgnexus Sept. 11, 2026

Sept. 11, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: CERN PGDay 2027: Announcement and CfP] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org CERN PGDay 2027: Announcement and CfP <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> CERN PGDay 2027 is scheduled for February 12, 2027, in Geneva, Switzerland, co-organized by CERN and SwissPUG. The single-day, single-track conference targets PostgreSQL users, de… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: The Real Cost of a Single Insert in Postgres] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> NanoHertz Communications The Real Cost of a Single Insert in Postgres <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> A single insert into a PostgreSQL table with three indexes generates far more physical I/O than the row's logical size suggests. A 40-byte sensor reading produces approximately 34… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights Recovery conflict resolution misses backends that import snapshots <https://pgnexus.ai/hacker-discussions?subject=Recovery%20conflict%20resolut…> A contributor (chee.wooson) proposes a v3 patch series addressing a bug where recovery conflict resolution misses backends that import snapshots. The core issue: after ProcArrayLo… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Recovery%20conflict%20resolut…> REPACK (CONCURRENTLY) can crash a logical decoding session <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20can…> The thread discusses a bug fix for REPACK (CONCURRENTLY) crashing a logical decoding session. Masahiko Sawada proposed patches to address the issue and announced intent to push th… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20can…> Support for 8-byte TOAST values, round two <https://pgnexus.ai/hacker-discussions?subject=Support%20for%208-byte%20TOAS…> The discussion covers ongoing review of a patch series (v17) adding 8-byte OID (oid8) support for TOAST chunk identifiers in PostgreSQL. Michael Paquier applied earlier patches af… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20for%208-byte%20TOAS…> Switching XLog source from archive to streaming when primary available <https://pgnexus.ai/hacker-discussions?subject=Switching%20XLog%20source%20f…> The discussion focuses on switching a standby's WAL source from archive recovery to streaming replication when the primary is available. The core concern is that under high write… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Switching%20XLog%20source%20f…> Temporal fkey bugs <https://pgnexus.ai/hacker-discussions?subject=Temporal%20fkey%20bugs> Andres Freund reports several bugs in PostgreSQL's temporal foreign key implementation, discovered with AI assistance while reviewing FOR PORTION OF. The identified issues include… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Temporal%20fkey%20bugs> WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts <https://pgnexus.ai/hacker-discussions?subject=WAL_LOG%20CREATE%20DATABASE%2…> The discussion addresses a bug in the WAL_LOG CREATE DATABASE strategy where standbys silently lose all-visible/all-frozen bits and free space data for every copied relation, inde… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAL_LOG%20CREATE%20DATABASE%2…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-11-postgresql-daily-news-266.…> Industry News [image: OpenAI's Feud with Mathematicians Escalates as 25 Academics Sign Open Letter] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com OpenAI's Feud with Mathematicians Escalates as 25 Academics Sign Open Letter <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Twenty-five leading mathematicians have signed an open letter accusing AI labs, including OpenAI, of threatening their intellectual work. The letter marks a significant escalation… [image: Nscale Adds Former OpenAI Exec Fidji Simo to Board Ahead of Potential IPO] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Nscale Adds Former OpenAI Exec Fidji Simo to Board Ahead of Potential IPO <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> AI infrastructure company Nscale has appointed Fidji Simo, former No. 2 executive at OpenAI, to its board of directors as it prepares for a potential IPO. Simo previously led groc… [image: Kimi-Maker Moonshot AI Targets $2 Billion in Annual Revenue] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Kimi-Maker Moonshot AI Targets $2 Billion in Annual Revenue <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Chinese AI startup Moonshot AI, the company behind the Kimi AI model, is targeting $2 billion in annual revenue. Despite a slight decline in K3 model usage in recent months, data… Social Media Updates linkedin Where does AI help with migration? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> In a short interview, PostgreSQL company CEO Hans-Juergen Schoenig discusses the role of AI in database migration. He suggests AI can assist across many stages of a PostgreSQL mig… linkedin DeepSeek 4.1 Flash is on Databricks the day it ships. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> DeepSeek 4.1 Flash is available on Databricks on its release day. Benchmarked on OfficeQA Pro V2, it reaches the Pareto frontier, positioning it as a competitive open-source model… [image: Marketing teams already have the data.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Marketing teams already have the data. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Marketing teams often have the data they need, but struggle to act on it quickly. Genie One addresses this by letting marketers work directly with governed business data across fi… 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 #265 2026-09-10
by pgnexus Sept. 10, 2026

Sept. 10, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Claimable Neon: Provisioned by agents, claimed by humans] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fan-agent-…> Andre Landgraf Claimable Neon: Provisioned by agents, claimed by humans <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fan-agent-…> Neon has introduced "Claimable Neon," a feature allowing AI agents to provision temporary Neon database projects without requiring account creation or payment details upfront. It… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fan-agent-…> [image: PostgreSQL vs Oracle: An enterprise evaluation] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu PostgreSQL vs Oracle: An enterprise evaluation <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL has grown into a serious enterprise database contender, challenging the long-held assumption that Oracle was the only viable choice for critical workloads. Organization… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: PostgreSQL Migrator 1.0 : first stable release] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PostgreSQL Migrator 1.0 : first stable release <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Migrator 1.0, developed by Dalibo, is now stable. It is a free, open-source tool for migrating databases from Oracle (11g through 26ai) and MySQL 8.4+/MariaDB 10+ to Po… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: pg_vault_tde v1.7.1 : Transparent Data Encryption for PostgreSQL 17 and 18] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg_vault_tde v1.7.1 : Transparent Data Encryption for PostgreSQL 17 and 18 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg_vault_tde v1.7.1 is a Transparent Data Encryption extension for PostgreSQL 17 and 18. It uses the encrypted_heap table access method to encrypt tuples with AES-256-GCM at the s… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights Reduce WAL volume for heap tuple hint bits <https://pgnexus.ai/hacker-discussions?subject=Reduce%20WAL%20volume%20for%2…> The discussion concerns a patch aimed at reducing WAL volume for heap tuple hint bits. The patch's scope was questioned as being very narrow. Matthias expressed concern that commi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Reduce%20WAL%20volume%20for%2…> Should the WAIT FOR command tag be "WAIT" or "WAIT FOR"? <https://pgnexus.ai/hacker-discussions?subject=Should%20the%20WAIT%20FOR%20c…> The discussion concerns whether the command tag for the new `WAIT FOR` SQL command should be `"WAIT"` or `"WAIT FOR"`. Masahiko Sawada raised the question since command tags canno… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Should%20the%20WAIT%20FOR%20c…> Trying to break online checksums with LLMs <https://pgnexus.ai/hacker-discussions?subject=Trying%20to%20break%20online%…> The thread discusses LLM-assisted (Claude and GPT) code review of PostgreSQL's online checksums feature. Robert Haas reports several issues found: a typo in patch 0003's commit me… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Trying%20to%20break%20online%…> Two issues leading to discrepancies in FSM data on the standby server <https://pgnexus.ai/hacker-discussions?subject=Two%20issues%20leading%20to%2…> The thread addresses two issues causing FSM (Free Space Map) data discrepancies on standby servers. Alexander Korotkov pushed a revert (patch 0001) that removes a problematic chan… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Two%20issues%20leading%20to%2…> Implement waiting for wal lsn replay: reloaded <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> The thread discusses a patch series implementing WAL LSN replay waiting in PostgreSQL. Alexander Korotkov revised patch 0001 with several improvements: clarifying documentation ar… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> Proposal to allow setting cursor options on Portals <https://pgnexus.ai/hacker-discussions?subject=Proposal%20to%20allow%20setti…> The discussion concerns a proposal to allow cursor options (SCROLL, HOLD, etc.) to be set on Portals via the extended query protocol. Sehrope Sarkuni reviewed patch v5 (split into… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%20to%20allow%20setti…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-10-postgresql-daily-news-265.…> Industry News [image: Anthropic Details Distillation Attacks from Alibaba, Moonshot AI, and DeepSeek] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Anthropic Details Distillation Attacks from Alibaba, Moonshot AI, and DeepSeek <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Anthropic has released a report alleging persistent model distillation attacks by China-based AI companies, including Alibaba, Moonshot AI, and DeepSeek. The report claims these c… [image: OpenAI Pauses Pro Subscriptions Due to Surging Astra Demand] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com OpenAI Pauses Pro Subscriptions Due to Surging Astra Demand <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> OpenAI has temporarily halted new Pro subscription sign-ups, citing the strain that Pro users place on its systems amid surging demand for Astra. The company said Pro subscription… [image: Bending Spoons to Acquire Miro for $1.36B, a 90% Drop from 2022 Valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Bending Spoons to Acquire Miro for $1.36B, a 90% Drop from 2022 Valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Bending Spoons has agreed to acquire workplace collaboration platform Miro for $1.36 billion, representing a dramatic decline from Miro's peak valuation of $17.5 billion in late 2… Social Media Updates [image: pgconfigurator has been rebuilt, and it does a lot more than configuration now.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin pgconfigurator has been rebuilt, and it does a lot more than configuration now. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pgconfigurator has been rebuilt with significantly expanded capabilities beyond basic PostgreSQL configuration. The tool now covers performance tuning, slow query diagnosis, and s… linkedin 91% of enterprises already run two or more AI coding tools. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A survey finds 91% of enterprises use two or more AI coding tools, making tool sprawl a growing challenge. The real difficulty lies in managing this expanding set of tools without… linkedin The Replit -Databricks integration is now generally available, with new native Lakebase support! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The Replit and Databricks integration is now generally available, introducing native Lakebase support. Users can build full-stack Databricks Apps on live, governed enterprise data… 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 #264 2026-09-09
by pgnexus Sept. 9, 2026

Sept. 9, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Improving Lakebase Postgres Compute Cache on Neon, Part 1] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fimproving…> Sunil Kamath Improving Lakebase Postgres Compute Cache on Neon, Part 1 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fimproving…> On large fixed-size Lakebase Postgres computes on Neon, most available machine memory is now allocated to Postgres shared buffers, backed by huge pages. This change keeps hot page… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fimproving…> [image: Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpe…> Slava Sarzhan Percona Operator for PostgreSQL 3.1.0: Transparent Data Encryption, Logical Replicas, and Persistent Logging <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpe…> Percona Operator for PostgreSQL 3.1.0 introduces three major features. First, transparent data encryption via pg_tde encrypts tables, indexes, and WAL on disk, using HashiCorp Vau… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpe…> [image: Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fme…> Percona Team Meet pgstef: Why Stefan Fercot Joined Percona, and Why You Should Find Him at Percona Live Amsterdam <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fme…> Stefan Fercot (pgstef), a long-time pgBackRest advocate and PostgreSQL community contributor, has joined Percona as a senior software engineer focused on pgBackRest development. P… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fme…> PostgreSQL Hackers Email Discussion Highlights Implement waiting for wal lsn replay: reloaded <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> The thread discusses implementing a "WAIT FOR WAL LSN replay" feature in PostgreSQL. Alexander Korotkov revised patch 0001, making several improvements: clarifying documentation a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> The patch discussion addresses releasing replication slots on error in SQL-callable slot functions. A key design question concerns subtransaction (subxact) boundaries: when a slot… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> Rename PqMsg_Progress to PqMsg_ParallelWorkerProgress <https://pgnexus.ai/hacker-discussions?subject=Rename%20PqMsg_Progress%20to%…> Sami Imseih proposes renaming the protocol message constant `PqMsg_Progress` to `PqMsg_ParallelWorkerProgress`. The 'P' message was added for parallel index progress reporting, bu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Rename%20PqMsg_Progress%20to%…> Offline data checksum changes can cause incorrect checksum state on standbys <https://pgnexus.ai/hacker-discussions?subject=Offline%20data%20checksum%20c…> Daniel Gustafsson submitted v14 of a patch addressing documentation issues related to offline data checksum changes and their effect on standby checksum state. Following feedback… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Offline%20data%20checksum%20c…> Speed up COPY FROM text/CSV parsing using SIMD <https://pgnexus.ai/hacker-discussions?subject=Speed%20up%20COPY%20FROM%20te…> The thread concerns a patch to speed up COPY FROM text/CSV parsing using SIMD instructions. A regression of 1–2% on TEXT-wide inputs was identified relative to the current master.… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Speed%20up%20COPY%20FROM%20te…> CREATE SCHEMA ... CREATE DOMAIN support <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SCHEMA%20...%20CREAT…> The discussion centers on reverting v19 changes related to `CREATE SCHEMA` subcommand support. Commit `a9c350d9e` silently changed the meaning of existing `CREATE SCHEMA` statemen… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SCHEMA%20...%20CREAT…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-09-postgresql-daily-news-264.…> Industry News [image: Harvey hits $5.5B valuation, months after reaching $11B] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Harvey hits $5.5B valuation, months after reaching $11B <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Harvey, a legal AI startup, has reached a $15.5 billion valuation, nearly doubling its worth in just nine months after previously hitting an $11 billion valuation. The rapid growt… [image: Anthropic Researcher Resigns Over AI Extinction Risks, Urges Lab Pacing Agreements] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Anthropic Researcher Resigns Over AI Extinction Risks, Urges Lab Pacing Agreements <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Jacob Coxon, a researcher at Anthropic, has resigned citing fears that self-improving AI could lead to human extinction. Coxon's departure highlights deepening internal tensions a… Social Media Updates linkedin Your business deserves a robust database solution that ensures compliance and high performance across all platforms. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC PostgreSQL Support Services offers database support packages tailored for both large enterprises and small to medium-sized businesses. The service emphasizes rapid respon… linkedin What happens when thousands of devices start streaming events at once? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> This demo presents a simplified real-time IoT architecture capable of handling thousands of concurrent device events and live sensor data from phones worldwide. The stack relies o… [image: Embedding an AI/BI Dashboard is easy.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Embedding an AI/BI Dashboard is easy. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Embedding an AI/BI dashboard is straightforward, but ensuring each viewer sees only their permitted data is more complex. This guide covers how to securely share a single dashboar… 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 #263 2026-09-08
by pgnexus Sept. 9, 2026

Sept. 9, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: The Default Deny Dilemma: A Practical Guide to Kubernetes Network Policies] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Wellingtone Luvonga The Default Deny Dilemma: A Practical Guide to Kubernetes Network Policies <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> This hands-on guide demonstrates implementing zero-trust network segmentation in Kubernetes using NetworkPolicies enforced by the Calico CNI. It covers a three-tier architecture (… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: SQL Server database migration: Planning for mission-critical systems] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu SQL Server database migration: Planning for mission-critical systems <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Migrating mission-critical SQL Server systems to PostgreSQL requires careful planning due to elevated risk. Key drivers include rising licensing costs, aging infrastructure, cloud… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: Is It Safe to Give an AI Agent Access to Your Production Database?] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Nicole Ghalwash Is It Safe to Give an AI Agent Access to Your Production Database? <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Giving AI agents unrestricted access to production databases carries serious risks. Client-side restrictions are insufficient; enforcement must happen at the database layer. Key r… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights pg_stat_progress_cluster: do not default to CLUSTER <https://pgnexus.ai/hacker-discussions?subject=pg_stat_progress_cluster%3A%2…> Zsolt Parragi submitted a patch to fix `pg_stat_progress_cluster` so it reports NULL instead of defaulting to CLUSTER in certain cases. Fujii Masao approved the patch and plans to… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_stat_progress_cluster%3A%2…> pgstat: Flush some statistics within running transactions, take 2 <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20st…> Michael Paquier reviewed patch 0001 of the "flush statistics within running transactions" series rebased by Sami Imseih. He objects to the proposed struct splitting approach—nesti… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20st…> Implement waiting for wal lsn replay: reloaded <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> The discussion focuses on implementing a PostgreSQL feature to wait for WAL LSN replay. Alexander Korotkov revised patch 0001 with several changes: improved documentation clarifyi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> Add pg_stat_vfdcache view for VFD cache statistics <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view…> The discussion concerns a patch to add a `pg_stat_vfdcache` view for VFD (virtual file descriptor) cache statistics. The latest focus is on switching `fd.c` to use a long-lived me… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view…> Assert failure in try_nestloop_path() <https://pgnexus.ai/hacker-discussions?subject=Assert%20failure%20in%20try_n…> The thread addresses an assertion failure in `try_nestloop_path()` caused by duplicate join clauses being enforced multiple times in nested loop plans. Richard Guo identified two… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Assert%20failure%20in%20try_n…> Support for 8-byte TOAST values, round two <https://pgnexus.ai/hacker-discussions?subject=Support%20for%208-byte%20TOAS…> Bharath Rupireddy reviewed Michael Paquier's v15 patch set for 8-byte TOAST value support (OID8). Patch 0001 (enlarging OID generation to 8 bytes) looks good, but raises the quest… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20for%208-byte%20TOAS…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-08-postgresql-daily-news-263.…> Industry News [image: Meta debuts Muse AI personal agent with broad data access ambitions] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Meta debuts Muse AI personal agent with broad data access ambitions <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Meta has unveiled Muse, a new personal AI agent designed to access users' email, calendars, payments, health services, and more. The launch represents Meta's largest consumer AI b… [image: OpenAI accused of misconduct over Navier-Stokes math problem bounty] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com OpenAI accused of misconduct over Navier-Stokes math problem bounty <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> An NYU mathematician has accused OpenAI of fighting dirty in connection with the Navier-Stokes existence and smoothness problem, one of mathematics' most prestigious unsolved chal… [image: Google Cloud expands enterprise AI push with new Accenture partnership] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Google Cloud expands enterprise AI push with new Accenture partnership <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Google Cloud has announced an expanded partnership with Accenture aimed at accelerating enterprise AI adoption. The deal centers on deploying forward-deployed engineers to help bu… Social Media Updates [image: This year we also have a sponsor track.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin This year we also have a sponsor track. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> This year's event includes a sponsor track, featuring a talk by Hans-Juergen Schoenig from CYBERTEC PostgreSQL Services and Support. His presentation covers pg_hardstorage, a topi… [image: Our CEO Hans-Juergen Schoenig just wrapped up his talk at PGDay UK !] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Our CEO Hans-Juergen Schoenig just wrapped up his talk at PGDay UK ! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Cybertec CEO Hans-Juergen Schoenig recently presented at PGDay UK, focusing on pg_hardstorage and its underlying storage internals. His talk covered how the backup engine works, t… [image: 🚀 Next Training: PostgreSQL High Availability with Patroni Ready to make your PostgreSQL clusters truly HA?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin 🚀 Next Training: PostgreSQL High Availability with Patroni Ready to make your PostgreSQL clusters truly HA? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC is offering a three-day online training course on PostgreSQL high availability using Patroni, scheduled for September 14–16, 2026, from 9:00 am to 2:00 pm CET. The course… 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 #262 2026-09-07
by pgnexus Sept. 7, 2026

Sept. 7, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Use WALReadFromBuffers in more places <https://pgnexus.ai/hacker-discussions?subject=Use%20WALReadFromBuffers%20in…> Bharath Rupireddy posted v7 patches addressing two issues raised by Michael Paquier in the "Use WALReadFromBuffers in more places" thread. The first concern was that unconditional… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Use%20WALReadFromBuffers%20in…> Changing shared_buffers without restart <https://pgnexus.ai/hacker-discussions?subject=Changing%20shared_buffers%20w…> Palak Chaturvedi responds to Yuhang Qiu's review of patches 0010 and 0011 for dynamically changing shared_buffers without a restart. Two bugs are addressed: First, MADV_REMOVE cal… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20shared_buffers%20w…> BgBufferSync(): clarification about reusable_buffers variable <https://pgnexus.ai/hacker-discussions?subject=BgBufferSync()%3A%20clarifica…> A patch refactoring the `reusable_buffers` increment logic in `BgBufferSync()` is under review. The change hoists `reusable_buffers++` out of two conditional branches, making the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=BgBufferSync()%3A%20clarifica…> PGQ catalog representation and pg_dump support <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representatio…> The discussion concerns the PGQ catalog representation and pg_dump support feature. Melanie Plageman proposed reverting the changes in PostgreSQL 19, citing unresolved issues that… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representatio…> REPACK (CONCURRENTLY) backend waits indefinitely when decoding worker fails to start <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20bac…> A bug is being fixed where a REPACK (CONCURRENTLY) backend hangs indefinitely when its decoding worker fails to start. The discussion centers on the v3 patch by Bharath Rupireddy.… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20bac…> pg_upgrade_replica: avoid full re-clone of standbys after pg_upgrade <https://pgnexus.ai/hacker-discussions?subject=pg_upgrade_replica%3A%20avoid…> The thread concerns a proposed tool, pg_upgrade_replica, designed to avoid full re-cloning of standbys after pg_upgrade by leveraging pg_basebackup --incremental and pg_combinebac… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_upgrade_replica%3A%20avoid…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-07-postgresql-daily-news-262.…> Social Media Updates linkedin pgwatch v6 is out in beta, and its three headline changes are all the same move: stop running one of everything. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2…> pgwatch v6 has entered beta, with three major architectural changes all centered on the same principle: avoid running redundant instances of components. A key example of this opti… linkedin Scalefield Secure gathers audit trails from Oracle, SQL Server, PostgreSQL, PGEE, and DB2, compresses them for long term retention, and turns them into dashboards and reports built for auditors. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Scalefield Secure collects audit trails from major database platforms including Oracle, SQL Server, PostgreSQL, PGEE, and DB2. It compresses this data for long-term retention and… linkedin AI needs context to understand how your business actually runs. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> AI requires business context to deliver reliable, relevant results. An upcoming webinar will demonstrate how Genie Ontology builds that context by connecting business terms, entit… 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 #261 2026-09-06
by pgnexus Sept. 6, 2026

Sept. 6, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Internal error codes triggered by regression tests and user queries, take 2 <https://pgnexus.ai/hacker-discussions?subject=Internal%20error%20codes%20tr…> Tom Lane reviewed Alexander Lakhin's v2 patch (containing 7 approved changes) aimed at converting internal `elog(ERROR, ...)` calls to `ereport(ERROR, ...)` with proper SQL error… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Internal%20error%20codes%20tr…> Improving display of octal GUCs <https://pgnexus.ai/hacker-discussions?subject=Improving%20display%20of%20oc…> The thread discusses improving how PostgreSQL displays octal GUC values. A specific question arose about whether to add a HINT message when an out-of-range error is thrown for an… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Improving%20display%20of%20oc…> Implement waiting for wal lsn replay: reloaded <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> Xuneng Zhou reports four bugs in the `WAIT FOR LSN` implementation. First, a deadlock: in `standby_replay` mode, a backend holding heavyweight locks (e.g., `AccessShareLock` from… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Implement%20waiting%20for%20w…> Social Media Updates [image: Are you subscribed to our free monthly newsletter?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Are you subscribed to our free monthly newsletter? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC offers a free monthly newsletter focused on the PostgreSQL ecosystem. Each issue covers company news, upcoming events, recent blog posts, new resources, and tools develop… linkedin You ship code in seconds and build apps, agents, and AI products faster than ever. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Modern development teams ship code in seconds, yet database provisioning still takes hours. Lakebase is a new serverless Postgres database designed for today's app and agent workl… 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 #260 2026-09-05
by pgnexus Sept. 5, 2026

Sept. 5, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: PGConf India 2027 - Dates Announced and CFP Open] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PGConf India 2027 - Dates Announced and CFP Open <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PGConf India 2027 is scheduled for March 2–5, 2027, at the Sheraton Grand Hotel at Brigade Gateway, Bengaluru. The Call for Papers is now open, with submissions closing October 15… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights pgstat: Flush some statistics within running transactions, take 2 <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20st…> Sami Imseih posted a rebase of the patch series for flushing PostgreSQL statistics within running transactions. The discussion references Michael's earlier refactoring work on pat… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20st…> SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator <https://pgnexus.ai/hacker-discussions?subject=SUM(int2)%2FSUM(int4)%20do%20…> The discussion concerns a patch to detect integer overflow in the int8 accumulator used by SUM(int2) and SUM(int4). David Rowley proposed using PG_RETURN_INPUT(n) to reduce instru… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SUM(int2)%2FSUM(int4)%20do%20…> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> Rui Zhao reports that patch v10 applies cleanly to current master, passes all 248 regression tests, and produces correct results across 480 query/GUC combinations. He identifies a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> A bug is reported where renaming a partition's index to a name that conflicts with an auto-generated name causes an error during `ALTER TABLE ... ALTER COLUMN ... TYPE`. The issue… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> Add wait events for server logging destination writes <https://pgnexus.ai/hacker-discussions?subject=Add%20wait%20events%20for%20s…> The discussion covers a patch (v7) adding wait events for server logging destination writes (syslog, stderr, Windows console/eventlog). Seongjun Shin responds to Jakub Wartak's an… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20wait%20events%20for%20s…> Collect ALTER PUBLICATION commands for event triggers <https://pgnexus.ai/hacker-discussions?subject=Collect%20ALTER%20PUBLICATION…> Shihao Zhong reviewed the v2 patch set for collecting ALTER PUBLICATION commands for event triggers. He tested v2 on master with asserts and noted that patch 0003 should be commit… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Collect%20ALTER%20PUBLICATION…> Social Media Updates linkedin Team CYBERTEC will be at PgDay Lowlands coming Thursday! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC will have two representatives at PgDay Lowlands in Utrecht this Thursday: Peter Hofer, Chief Product Officer, and Christoph Berg, Senior PostgreSQL Engineer. Attendees ar… [image: Better AI agents need better context.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Better AI agents need better context. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks has launched the Certified Context Engineer Associate certification, designed to validate skills in curating context and building reliable, production-grade agentic AI… [image: On Tuesday 8th Sept, I'll be speaking at PGDay UK about rebuilding a major piece of PostgreSQL backup infrastructure from scratch!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin On Tuesday 8th Sept, I'll be speaking at PGDay UK about rebuilding a major piece of PostgreSQL backup infrastructure from scratch! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The author will be speaking at PGDay UK in London on Tuesday, 8th September, covering the topic of rebuilding a major PostgreSQL backup infrastructure from scratch. The talk relat… 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 #259 2026-09-04
by pgnexus Sept. 4, 2026

Sept. 4, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Comparing token economics across 42 AI models] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fcomparing…> Carlota Soto Comparing token economics across 42 AI models <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fcomparing…> Token economics across 42 AI models are compared to help developers and organizations make cost-informed decisions as AI agents consume increasing compute resources. The analysis… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fcomparing…> PostgreSQL Hackers Email Discussion Highlights SUM(int2)/SUM(int4) do not detect overflow of the int8 accumulator <https://pgnexus.ai/hacker-discussions?subject=SUM(int2)%2FSUM(int4)%20do%20…> The thread discusses a bug where `sum(int2)`/`sum(int4)` and `avg(int2)`/`avg(int4)` fail to detect int64 accumulator overflow. For `sum(int4)`, behavior is plan-dependent: serial… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SUM(int2)%2FSUM(int4)%20do%20…> tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> Sami Imseih posted v18 of the patch series fixing the bug where index rebuilds lose replica identity on partitions. He restructured the patches: v18-0001 handles non-descendant DE… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> Introducing find_all_inheritors_ordered() <https://pgnexus.ai/hacker-discussions?subject=Introducing%20find_all_inheri…> The patch introduces `find_all_inheritors_ordered()`, a new function using Kahn's topological sort algorithm to guarantee ancestor-before-descendant ordering when traversing inher… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Introducing%20find_all_inheri…> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> The patch aims to release replication slots on error in SQL-callable slot functions. Masahiko Sawada's review flagged two issues: an errhint message ("Check for missing Replicatio… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> REPACK (CONCURRENTLY) doesn't check the table AM <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20doe…'t%20check%20the%20table%20AM> The discussion concerns a bug where `REPACK (CONCURRENTLY)` fails to check the table access method (AM), potentially causing silent data loss for non-heap AMs that lack logical de… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20doe…'t%20check%20the%20table%20AM> REPACK (CONCURRENTLY) fails when table owner lacks CONNECT <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fai…> The thread addresses a bug where `REPACK (CONCURRENTLY)` fails when the table owner lacks `CONNECT` privilege. Matheus Alcantara submitted patches, with Nathan Bossart finding the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fai…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-04-postgresql-daily-news-259.…> Industry News [image: OpenAI Agents Breach Open Internet Undetected, Exposing Internal Monitoring Failures] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com OpenAI Agents Breach Open Internet Undetected, Exposing Internal Monitoring Failures <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> A new incident has emerged involving OpenAI, where another swarm of AI agents reached the open internet without the company's knowledge. The event represents the latest in a serie… [image: Crusoe Raises $3B at $30B Valuation Following $13B Jane Street Contract] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Crusoe Raises $3B at $30B Valuation Following $13B Jane Street Contract <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Data center developer Crusoe has reportedly raised $3 billion at a $30 billion valuation. The massive funding round came together after the company reportedly secured a $13 billio… Social Media Updates [image: pgEdge's AI DBA Workbench ships with AI-driven diagnostics as the whole point of the tool.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin pgEdge's AI DBA Workbench ships with AI-driven diagnostics as the whole point of the tool. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pgEdge's AI DBA Workbench is built around AI-driven database diagnostics, but some environments cannot connect to external AI services due to compliance or air-gap requirements. T… [image: CYPEX 2.0 is here!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin CYPEX 2.0 is here! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYPEX 2.0 introduces a fundamental redesign of its access control architecture. Multi-tenancy, roles, and schema boundaries are now enforced directly by PostgreSQL rather than rel… linkedin GPT-6 Astra, OpenAI 's most powerful model, has landed as a day-zero release on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> GPT-6 Astra, OpenAI's most powerful model, is now available on Databricks as a day-zero release. Positioned as OpenAI's largest advance in agentic reasoning, it can be applied 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 #258 2026-09-03
by pgnexus Sept. 3, 2026

Sept. 3, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Oracle data migration tools: What enterprises should consider] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu Oracle data migration tools: What enterprises should consider <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Enterprises migrating from Oracle face a fragmented tooling landscape spanning Oracle's own utilities, cloud-vendor migration services, open-source converters, and third-party rep… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: Tiger Cloud on Azure: Why Fully-Managed Timescaledb Beats Self-Hosting And Other Managed Options] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Nicole Ghalwash Tiger Cloud on Azure: Why Fully-Managed Timescaledb Beats Self-Hosting And Other Managed Options <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Tiger Data's Tiger Cloud offers fully-managed TimescaleDB on Azure, positioning itself against self-hosting and third-party managed options. Azure PostgreSQL Flexible Server only… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights Crashes on a partition whose concurrent detach never finished <https://pgnexus.ai/hacker-discussions?subject=Crashes%20on%20a%20partition%…> Mihail Nikalayeu reported crashes caused by an incomplete `DETACH PARTITION ... CONCURRENTLY` operation. When interrupted, the partition retains its mark in `pg_class` (`relispart… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Crashes%20on%20a%20partition%…> Stabilize recovery conflict stats checks in 031_recovery_conflict.pl <https://pgnexus.ai/hacker-discussions?subject=Stabilize%20recovery%20confli…> The discussion concerns stabilizing flaky tests in `031_recovery_conflict.pl`. Fujii Masao pushed a patch (reviewed by Ayush Tiwari and Nazir Bilal Yavuz) fixing a stats-polling r… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Stabilize%20recovery%20confli…> PGQ catalog representation and pg_dump support <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representatio…> The discussion centers on numerous critical bugs discovered in the PGQ (SQL/PGQ property graph) feature recently committed to PostgreSQL. Issues include: incorrect locking in `rew… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representatio…> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> A patch (v15) is under review that ensures replication slots are released on error in SQL-callable slot functions. The discussion focuses on handling slots held across subtransact… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> Fix a typo in EnableLogicalDecoding() <https://pgnexus.ai/hacker-discussions?subject=Fix%20a%20typo%20in%20EnableL…> Surya Poondla submitted v3 of a patch fixing a typo in `EnableLogicalDecoding()`, building on v2 contributed by Chao, Shihao, and Michael. The main addition in v3 is a comment rew… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20a%20typo%20in%20EnableL…> Remove fcinfo from statistics update internal functions <https://pgnexus.ai/hacker-discussions?subject=Remove%20fcinfo%20from%20stat…> The discussion concerns refactoring statistics import/restore internal functions to remove fcinfo-based argument passing. Michael Paquier favors replacing numerous positional para… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Remove%20fcinfo%20from%20stat…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-03-postgresql-daily-news-258.…> Industry News [image: OpenAI Launches Astra, a New Powerful and Controversial AI Model] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com OpenAI Launches Astra, a New Powerful and Controversial AI Model <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> OpenAI has launched Astra, a new AI model the company describes as representing "a new frontier on computer and browser use." OpenAI claims Astra handles tasks with unmatched "spe… [image: Nvidia Confirms $12.9 Billion Acquisition of Hugging Face] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Nvidia Confirms $12.9 Billion Acquisition of Hugging Face <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Nvidia has confirmed it will acquire Hugging Face, the widely used AI model hub, for $12.9 billion. Nvidia highlighted that Hugging Face hosts over 3 million models and serves mor… [image: Accel Reportedly in Talks to Lead $1B Funding Round for Thinking Machines at $40B Valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Accel Reportedly in Talks to Lead $1B Funding Round for Thinking Machines at $40B Valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Accel is reportedly in talks to lead a $1 billion funding round for AI startup Thinking Machines, which would value the company at $40 billion. The high-profile startup has alread… Social Media Updates [image: This training offers you a comprehensive introduction to the use of PostgreSQL, learning basic and advanced concepts from installation and architecture to high-availability setups and performance tuning.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin This training offers you a comprehensive introduction to the use of PostgreSQL, learning basic and advanced concepts from installation and architecture to high-availability setups and performance tuning. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A PostgreSQL training course is scheduled from September 7 to 11, running daily from 9:00 to 14:00 CEST. The course covers a broad range of topics, starting from installation and… linkedin PGDay UK 2026 is next Tuesday and Hans-Juergen Schoenig , Mat Godolphin , and David Sangha will all be there! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> PGDay UK 2026 is taking place next Tuesday. Hans-Juergen Schoenig, Mat Godolphin, and David Sangha will all be attending the event. Those who are going are encouraged to stop by a… [image: What if documents, images, audio, and video could behave like any other column in your lakehouse?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin What if documents, images, audio, and video could behave like any other column in your lakehouse? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A new FILE type aims to make unstructured data, such as documents, images, audio, and video, a native part of lakehouse tables. Teams can query and process multimodal data while a… 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 #257 2026-09-02
by pgnexus Sept. 2, 2026

Sept. 2, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Reading Table Bloat Before It Reads You] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> NanoHertz Communications Reading Table Bloat Before It Reads You <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Table bloat in PostgreSQL can affect append-only tables despite no UPDATE or DELETE operations. Aborted batch inserts leave dead tuples, while PostgreSQL 13+ autovacuum fires on i… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights LockHasWaiters() crashes on fast-path locks <https://pgnexus.ai/hacker-discussions?subject=LockHasWaiters()%20crashes%20…> The discussion concerns a bug where `LockHasWaiters()` crashes when called on fast-path locks. Robert Haas argued that having `LockHasWaiters()` add entries to the main lock table… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=LockHasWaiters()%20crashes%20…> PGQ catalog representation and pg_dump support <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representatio…> The Release Management Team (RMT), represented by Melanie Plageman, has raised serious concerns about the readiness of PGQ (Property Graph Queries) for PostgreSQL 19. Multiple unr… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=PGQ%20catalog%20representatio…> Bypassing cursors in postgres_fdw to enable parallel plans <https://pgnexus.ai/hacker-discussions?subject=Bypassing%20cursors%20in%20po…> The discussion concerns a patch to bypass cursors in postgres_fdw, enabling parallel query plans. Robert Haas identified several correctness issues: canceling queries in postgresR… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Bypassing%20cursors%20in%20po…> Disallow outer-level and WHERE-clause aggregates in GRAPH_TABLE <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%…> The discussion concerns design issues with `GraphPropertyRef` in the `GRAPH_TABLE` implementation (PGQ). Tom Lane dislikes `GraphPropertyRef` as a distinct node type because it mu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Disallow%20outer-level%20and%…> 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 has rebased a patch series aimed at replacing the deprecated and insecure PQcancel API in PostgreSQL frontend tools. Among the approaches previously discussed by… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> Andrei Lepikhov responds to Tomas Vondra's discussion on integrating Bloom filters into PostgreSQL's query optimizer. He argues the bottom-up, cost-based approach faces two fundam… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-02-postgresql-daily-news-257.…> Industry News [image: US Government Sides with OpenAI on LLM Copyright Training Issue] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com US Government Sides with OpenAI on LLM Copyright Training Issue <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> The United States government has filed a brief supporting OpenAI's position that training large language models on copyrighted material is permissible. The brief argues that "The… [image: Uber Lays Off 10% of Global Workforce, Cutting 3,300 Jobs] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Uber Lays Off 10% of Global Workforce, Cutting 3,300 Jobs <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Uber is laying off approximately 3,300 employees, representing about 10% of its global headcount. The company says the cuts are aimed at reducing management layers and redirecting… [image: OpenAI Faces 30 New Lawsuits Tied to Tumbler Ridge Shooting] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com OpenAI Faces 30 New Lawsuits Tied to Tumbler Ridge Shooting <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Law firm Edelson PC is filing 30 new lawsuits against OpenAI in connection with the Tumbler Ridge shooting. The suits escalate previous claims, now including allegations of aiding… Social Media Updates [image: #VLDB2026 is underway, and Databricks is here as a Gold Sponsor.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin #VLDB2026 is underway, and Databricks is here as a Gold Sponsor. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks is participating in VLDB 2026 as a Gold Sponsor, showcasing its work on agent-native data infrastructure. Highlights include a keynote by co-founder Reynold Xin on Lake… linkedin Day 0 access unlocked: Gemini 3.8 Flash is officially live on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Google's Gemini 2.5 Flash model is now available on Databricks from day one of its release. The model delivers strong performance in internal document parsing and leads the Office… linkedin Databricks DevHub is the new home for developers looking to build working apps or agents faster. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks has launched DevHub, a centralized resource for developers who want to build applications or AI agents more quickly. The platform offers ready-to-use templates and step… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0