- Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #256 2026-09-01
by pgnexus Sept. 1, 2026

Sept. 1, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Neon is now available in Grok Bot] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-is-n…> Dominik Koch Neon is now available in Grok Bot <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-is-n…> Neon, the serverless PostgreSQL platform, is now available as a plugin in Grok Bot. Users can connect their Neon account once to enable the integration, after which they can inter… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-is-n…> [image: Enterprise PostgreSQL Support: What mission-critical operations require] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu Enterprise PostgreSQL Support: What mission-critical operations require <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Enterprise PostgreSQL support is often assessed during stable operations, when procurement teams compare contracts, SLAs, and response times. However, the true value of such suppo… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: Why a 40-Year-Old Database Is Still Winning in the AI Era] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Ajay Kulkarni Why a 40-Year-Old Database Is Still Winning in the AI Era <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL, now 40 years old, continues to dominate even as AI reshapes software development. Industry analysts and engineers attribute this to its foundational strengths: transac… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights Changing the state of data checksums in a running cluster <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> Alexander Lakhin confirmed that a previously proposed fix (adding a wait) resolves both test reliability issues he had observed in the "changing data checksums in a running cluste… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> right() returns the whole string for the most negative n <https://pgnexus.ai/hacker-discussions?subject=right()%20returns%20the%20who…> A bug was reported where the `right()` string function returns the whole string when passed the most negative 32-bit integer (`PG_INT32_MIN`) as the argument `n`. The fix involves… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=right()%20returns%20the%20who…> Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master <https://pgnexus.ai/hacker-discussions?subject=Routed%20ON%20CONFLICT%20inse…> The thread discusses two related regressions in PostgreSQL 19 affecting `ON CONFLICT` inserts. The primary issue involves routed inserts into partitioned tables failing when parti… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Routed%20ON%20CONFLICT%20inse…> Add starelid, attnum to pg_stats and leverage this in pg_dump <https://pgnexus.ai/hacker-discussions?subject=Add%20starelid%2C%20attnum%20…> A patch restoring a previously removed filter clause in the pg_stats area was committed. The clause had been dropped as part of an earlier commit (4b5ba0c4ca52), but its absence c… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20starelid%2C%20attnum%20…> Two issues leading to discrepancies in FSM data on the standby server <https://pgnexus.ai/hacker-discussions?subject=Two%20issues%20leading%20to%2…> Noah Misch argues that commit c06d1a4 is incorrect. With checksums and full-page writes enabled, the commit allows FSM pages to be dirtied via `heap_xlog_*` during recovery after… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Two%20issues%20leading%20to%2…> timeout value overflow in wait for lsn <https://pgnexus.ai/hacker-discussions?subject=timeout%20value%20overflow%20…> The thread discusses a timeout value overflow issue in the `WAIT FOR LSN` feature. A key question is whether to use `parse_int()` for timeout parsing (consistent with existing int… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=timeout%20value%20overflow%20…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-09-01-postgresql-daily-news-256.…> Industry News [image: Anthropic's New Fable 5.1 Model Release: Cheaper and Less Restrictive] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Anthropic's New Fable 5.1 Model Release: Cheaper and Less Restrictive <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Anthropic has released Fable 5.1, an updated AI model designed to reduce token costs and minimize false-positive restrictions triggered by the model's built-in safeguards. The rel… [image: Microsoft 365 Outage Causes Prolonged Service Degradation for Outlook Users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com Microsoft 365 Outage Causes Prolonged Service Degradation for Outlook Users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> Microsoft 365 and Outlook experienced an extended service outage on Tuesday, with users facing continued degradation even as the company reported gradual improvements. Microsoft's… [image: GoPro to Be Acquired for $285M by AI Infrastructure Company] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> techcrunch.com GoPro to Be Acquired for $285M by AI Infrastructure Company <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F09%2…> GoPro has agreed to be acquired for $285 million by a company that builds AI infrastructure. Despite the acquisition, GoPro will remain a publicly traded company and continue supp… Social Media Updates linkedin Ahead of PGDay Lowlands 2026 in Utrecht we're sitting down with our Partner-level sponsors to talk about their contributions to the #PostgreSQL project and community, and to get a preview of their sponsor track session. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> In advance of PGDay Lowlands 2026 in Utrecht, organizers are interviewing Partner-level sponsors about their involvement with the PostgreSQL project and community. This installmen… linkedin AI assistants are spreading fast, but 50% of enterprise agents operate in data silos. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> AI assistants are proliferating across enterprises, yet half of enterprise agents operate in isolated data silos, limiting their usefulness for consequential decisions. A new eBoo… linkedin Claude Fable 5.1, Anthropic 's most capable model, is available as a day 0 release on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Claude Fable 5.1, Anthropic's most capable model, is now available on Databricks as a day-zero release. It joins an existing lineup that includes Claude Opus 5, Claude Sonnet 5, 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 #255 2026-08-31
by pgnexus Aug. 31, 2026

Aug. 31, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Autoscaling Lakebase Postgres] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fautoscali…> Carlota Soto Autoscaling Lakebase Postgres <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fautoscali…> Lakebase Postgres, offered by Neon, eliminates the need to pre-select a database instance size by incorporating autoscaling. Traditional database provisioning requires workload es… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fautoscali…> [image: Database migration tools: An enterprise buyer's guide] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu Database migration tools: An enterprise buyer's guide <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Enterprise database migration tools often appear comparable in feature matrices, but real differences surface under production conditions: stored procedures that resist automated… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Tristan Vermeesch How Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Companion.energy migrated real-time energy sensor telemetry from Azure PostgreSQL with a limited Apache 2 TimescaleDB extension to Tiger Cloud's fully featured managed TimescaleDB… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> The discussion centers on a patch to release replication slots on error in SQL-callable slot functions, particularly fixing a crash and slot leak when slot creation fails inside a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> another autovacuum scheduling thread <https://pgnexus.ai/hacker-discussions?subject=another%20autovacuum%20schedu…> Nathan Bossart identified a corner case in the autovacuum scheduling feature, discovered with help from Claude. The issue is that when freeze score weights are sufficiently high,… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=another%20autovacuum%20schedu…> REPACK (ANALYZE) within transaction block segfaults <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> Osama Abdul Qader posted an update to the "REPACK (ANALYZE) within transaction block segfaults" thread, but it was actually intended for a different discussion about replication s… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> Routed ON CONFLICT inserts broken by partition-local deferrable unique constraints in 19 and master <https://pgnexus.ai/hacker-discussions?subject=Routed%20ON%20CONFLICT%20inse…> Zsolt Parragi reported a regression introduced by commit 90eae926abbb, which broke routed ON CONFLICT inserts on partitioned tables when a leaf partition has a deferrable unique c… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Routed%20ON%20CONFLICT%20inse…> Reducing relcache memory usage: deduping index shapes <https://pgnexus.ai/hacker-discussions?subject=Reducing%20relcache%20memory%…> Matthias van de Meent proposes a patchset to reduce relcache memory usage by deduplicating shared index data fields (rd_opfamily, rd_opcintype, rd_support, rd_supportinfo) across… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Reducing%20relcache%20memory%…> REPACK (CONCURRENTLY) fails with wrong error for materialized views <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fai…> The discussion addresses a bug where `REPACK (CONCURRENTLY)` produces a misleading "has no identity index" error when applied to a materialized view. Bharath Rupireddy submitted a… 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-08-31-postgresql-daily-news-255.…> Industry News [image: Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Nvidia's $3.5B Investment in MediaTek to Counter Big Tech's Custom AI Chips <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Nvidia has invested $3.5 billion into Taiwanese chipmaker MediaTek, signaling a strategic move to stay central to AI infrastructure as major tech companies increasingly develop th… [image: Microsoft Tests Fix After Hours-Long Outlook Outage] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Microsoft Tests Fix After Hours-Long Outlook Outage <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Microsoft is testing a fix for a widespread Outlook outage that caused hours of email delays and delivery failures. The incident affected a significant number of users and drew at… Social Media Updates linkedin pg_hardstorage is an open-source PostgreSQL backup tool, developed by our team at CYBERTEC. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pg_hardstorage is an open-source PostgreSQL backup tool developed by the team at CYBERTEC. A brief walkthrough of the tool is available, and the source code is publicly accessible… linkedin Genie is a game changer. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Users describe Genie as a transformative tool that accelerates their workflow from ideation to production with fewer errors. According to firsthand accounts, Genie helps users ask… [image: Databricks has been named to Madrona 's 2026 Intelligent Applications 40 list!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Databricks has been named to Madrona 's 2026 Intelligent Applications 40 list! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks has been named to Madrona's 2026 Intelligent Applications 40 list, which recognizes top private companies building and enabling AI applications. Notably, Databricks is… 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 #254 2026-08-30
by pgnexus Aug. 30, 2026

Aug. 30, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights WAIT FOR command should do some query jumbling <https://pgnexus.ai/hacker-discussions?subject=WAIT%20FOR%20command%20should…> The discussion addresses making the `WAIT FOR LSN` command participate in query jumbling so that repeated calls with different LSN values don't flood `pg_stat_statements` with sep… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAIT%20FOR%20command%20should…> Changing the state of data checksums in a running cluster <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> A fix for test flakiness in the data checksum state-change feature is being discussed. Daniel Gustafsson proposed changing a `disable_data_checksums($node)` call to `disable_data_… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> convert various variables to atomics <https://pgnexus.ai/hacker-discussions?subject=convert%20various%20variables…> The thread concerns a commitfest entry for converting various variables to atomics. Andrey Borodin moved the entry from "Ready for Committer" back to "Needs Review" because a prio… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=convert%20various%20variables…> GIN pageinspect support for entry tree and posting tree <https://pgnexus.ai/hacker-discussions?subject=GIN%20pageinspect%20support%2…> The thread concerns adding pageinspect support for GIN entry trees and posting trees. Kirill Reshke rebased the patches and polished error messages. However, Andrey Borodin notes… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=GIN%20pageinspect%20support%2…> REPACK (ANALYZE) within transaction block segfaults <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> The thread concerns a segfault when executing REPACK (ANALYZE) inside a transaction block. Antonin Houska proposed aligning REPACK (ANALYZE) behavior with VACUUM (FULL, ANALYZE) b… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> Proposal: Conflict log history table for Logical Replication <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> A bug was found in patch 0002 for the logical replication conflict log history table proposal. The original assumption that a column's maximum size grows at most 6x during JSON co… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20Conflict%20log%…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-30-postgresql-daily-news-254.…> Industry News [image: Sony Music, Warner Sue Anthropic for Alleged Intellectual Property Theft] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Sony Music, Warner Sue Anthropic for Alleged Intellectual Property Theft <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Sony Music and Warner have filed a lawsuit against Anthropic, accusing the AI company of conducting a "brazen campaign" of intellectual property theft. The lawsuit is described as… [image: Anthropic Researcher Demonstrates Self-Improving AI System] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Anthropic Researcher Demonstrates Self-Improving AI System <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> An Anthropic researcher has revealed early results from a self-improving AI system. Given 10 benchmarks targeting specific misaligned behaviors, the automated system improved perf… Social Media Updates [image: Ready to move away from proprietary databases without the headache?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Ready to move away from proprietary databases without the headache? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Nicholas Hape from Redgate and Bernd Helmle from CYBERTEC are hosting a German-language webinar on September 1 at 2pm CEST focused on the realities of database migration. The sess… linkedin 🆕 We've been busy shipping new features! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Nick Karpov and Holly Smith present the latest Databricks updates in a new Over Architected episode. They walk through how the newest features work individually and how they fit 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 #253 2026-08-29
by pgnexus Aug. 29, 2026

Aug. 29, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights REPACK (CONCURRENTLY) fails with wrong error for materialized views <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fai…> Bharath Rupireddy reports that `REPACK (CONCURRENTLY)` produces a misleading "no identity index" error when run against a materialized view. A patch is proposed that adds a proper… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fai…> remove_useless_joins vs. bug #19560 <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20…> A crash was reported by Tender Wang (found via SQLSmith) after commit 2ebf25e7d70a8, which was part of the `remove_useless_joins` fix for bug #19560. The crash occurs when a subqu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=remove_useless_joins%20vs.%20…> Randomize B-Tree page split location to avoid oscillating patterns <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20s…> The thread discusses a patch proposal to randomize B-Tree page split locations in PostgreSQL's nbtree code to reduce oscillating split patterns. Andrey Borodin supports restrictin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20s…> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> The thread discusses a structural issue with `pg_subscription`, a shared catalog that contains database-specific OIDs, causing problems with `REASSIGN OWNED` and dependency tracki… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> PG19 FK fast path: OOB write and missed FK checks during batched <https://pgnexus.ai/hacker-discussions?subject=PG19%20FK%20fast%20path%3A%20…> The thread discusses bugs in PostgreSQL 19's FK fast-path batching layer. Amit Langote previously fixed an out-of-bounds write and missed FK checks, keying the cache by (constrain… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=PG19%20FK%20fast%20path%3A%20…> Changing the state of data checksums in a running cluster <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> Alexander Lakhin confirmed that Daniel Gustafsson's proposed fix—changing `disable_data_checksums($node)` to `disable_data_checksums($node, wait => 1)`—resolves a timing-related t… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-29-postgresql-daily-news-253.…> Social Media Updates linkedin Genie is changing how teams get answers from their data. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> In a DataFramed conversation, Databricks Co-Founder and Chief Architect Reynold Xin discusses how Genie is transforming how teams query and explore data. He explains how he person… linkedin GLM 5.3 is available as a day 0 release on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> GLM 5.3 is now available on Databricks as a day-zero release, positioned as the most capable open-weight model currently available. It joins GLM 5.3 Flash and over 30 open-source… 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 #252 2026-08-28
by pgnexus Aug. 28, 2026

Aug. 28, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: PostgreSQL security best practices for regulated environments] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu PostgreSQL security best practices for regulated environments <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL security in regulated environments goes beyond standard controls like authentication, encryption, and access restrictions. Compliance frameworks such as HIPAA, PCI DSS,… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Damaso Sanoja Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Adding a single indexed column to a wide time-series table in PostgreSQL costs far more than adding a million rows. A benchmark using 100 million rows on PostgreSQL 17.10 with Tim… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> The discussion centers on a patch to release replication slots on error in SQL-callable slot functions, specifically addressing crash behavior during subtransaction aborts. Key de… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> Error handling in after-startup shmem requests <https://pgnexus.ai/hacker-discussions?subject=Error%20handling%20in%20after…> A patch addressing error handling in after-startup shared memory requests was reviewed by Ayush Tiwari, who confirmed the tests passed when run in parallel, and subsequently commi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Error%20handling%20in%20after…> Randomize B-Tree page split location to avoid oscillating patterns <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20s…> The discussion focuses on randomizing B-Tree page split location selection to avoid oscillating patterns. The thread examines a reservoir-sampling-style algorithm: instead of coll… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20s…> pg_stat_get_autovacuum_scores ignores the main table's reloptions for TOAST tables <https://pgnexus.ai/hacker-discussions?subject=pg_stat_get_autovacuum_scores…'s%20reloptions%20for%20TOAST%20tables> Masahiko Sawada reported that `pg_stat_get_autovacuum_scores()` computes incorrect scores for TOAST tables when the main table has `autovacuum_*` reloptions set but the TOAST tabl… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_stat_get_autovacuum_scores…'s%20reloptions%20for%20TOAST%20tables> REPACK (ANALYZE) within transaction block segfaults <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> The discussion addresses a segfault when `REPACK (ANALYZE)` is executed inside a transaction block. Fujii Masao initially proposed rejecting only non-top-level executions (e.g., i… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> timeout value overflow in wait for lsn <https://pgnexus.ai/hacker-discussions?subject=timeout%20value%20overflow%20…> The discussion addresses two bugs in the `WAIT FOR LSN` timeout handling: an integer overflow when timeout values exceed INT_MAX across multiple sleep iterations, and incorrect be… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=timeout%20value%20overflow%20…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-28-postgresql-daily-news-252.…> Industry News [image: Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> According to TechCrunch, open-weight AI companies have become among the most sought-after acquisition targets in Silicon Valley. Significant capital is flowing into businesses tha… [image: a16z Launches $1.1B 'Machine Age' Fund to Back AI Physical Infrastructure] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com a16z Launches $1.1B 'Machine Age' Fund to Back AI Physical Infrastructure <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Andreessen Horowitz (a16z), the prominent venture capital firm long associated with software investing, has created a $1.1 billion fund called the "Machine Age" fund. The fund is… [image: Anthropic Wins First Court Ruling Against Pentagon's Supply-Chain Risk Designation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Anthropic Wins First Court Ruling Against Pentagon's Supply-Chain Risk Designation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> A federal judge has ruled that the Trump administration illegally labeled Anthropic a supply-chain risk, handing the AI company its first legal victory in an ongoing dispute with… Social Media Updates [image: pgwatch v6.0.0-beta can now scrape a Prometheus exporter directly, as a first-class source, side by side with your regular PostgreSQL sources.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin pgwatch v6.0.0-beta can now scrape a Prometheus exporter directly, as a first-class source, side by side with your regular PostgreSQL sources. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pgwatch v6.0.0-beta introduces the ability to scrape a Prometheus exporter directly as a first-class monitoring source, placing it on equal footing with regular PostgreSQL sources… linkedin Your data. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Data AI World Tour 2026 is an event series focused on how organizations can ground AI in enterprise data and business context to achieve real outcomes. Attendees can expect the la… [image: Our partners are bringing a new wave of production-ready, industry-specific solutions to Lakebase.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Our partners are bringing a new wave of production-ready, industry-specific solutions to Lakebase. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A range of partners have developed production-ready, industry-specific solutions built on Lakebase, covering financial services, manufacturing, energy, retail, healthcare, communi… 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 #251 2026-08-27
by pgnexus Aug. 27, 2026

Aug. 27, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: 14,000x Faster Planning for LIMIT Queries on Hypertables] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Sven Klemm 14,000x Faster Planning for LIMIT Queries on Hypertables <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> TimescaleDB 2.30 introduces `DeferredChunkAppend`, a custom scan node that eliminates the per-chunk planning overhead for `LIMIT` queries on hypertables. Previously, queries like… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights REPACK (ANALYZE) within transaction block segfaults <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> Nathan Bossart reported that executing `REPACK (ANALYZE)` inside a transaction block (e.g., a DO block) causes a server crash with warnings about a non-empty SPI stack and an acti… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%2…> REPACK (CONCURRENTLY) doesn't check the table AM <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20doe…'t%20check%20the%20table%20AM> REPACK (CONCURRENTLY) replays changes via logical decoding from WAL, requiring the table AM to support logical decoding. Nathan Bossart noted that check_concurrent_repack_requirem… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20doe…'t%20check%20the%20table%20AM> Logical replication can lose an update after concurrent index invalidation <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20can%2…> A bug in logical replication is reported where an update can be silently lost following a concurrent index invalidation. The root cause lies in `FindLogicalRepLocalIndex()` and `R… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Logical%20replication%20can%2…> REPACK (CONCURRENTLY) fails when table owner lacks CONNECT <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fai…> Nathan Bossart reported that `REPACK (CONCURRENTLY)` fails with a "permission denied" error when the table owner lacks CONNECT privilege on the database, because the REPACK decodi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(CONCURRENTLY)%20fai…> MERGE/SPLIT PARTITIONS issues/questions <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20…> The discussion concerns the MERGE/SPLIT PARTITIONS feature, recently committed to PostgreSQL. Robert Haas raised serious concerns: the feature takes AccessExclusiveLock on the par… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20…> pg_plan_advice: fix empty FOREIGN_JOIN sublist validation <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20emp…> A patch for `pg_plan_advice` was proposed to fix a bug in the validation of empty `FOREIGN_JOIN` sublists. Nathan Bossart asked Robert Haas for his opinion on the patch; Robert ap… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20emp…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-27-postgresql-daily-news-251.…> Industry News [image: OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com OpenAI, Anthropic, Google, and 100+ Companies Unite Against Rogue AI Cyber Threats <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Some of the world's largest tech companies and AI startups — including OpenAI, Anthropic, and Google — have jointly called for action to address growing cybersecurity threats pose… [image: Meta's $18B Settlement with 29 States Allows Retention of Children's Data for AI Training] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Meta's $18B Settlement with 29 States Allows Retention of Children's Data for AI Training <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Meta's $18 billion settlement with 29 U.S. states contains a notable privacy trade-off: the agreement permits Meta to retain certain data collected from children under 13 to train… [image: Australian Police Arrest Two Suspects Over TeamPCP Hacks Targeting Mercor, OpenAI, and Others] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Australian Police Arrest Two Suspects Over TeamPCP Hacks Targeting Mercor, OpenAI, and Others <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Australian police have arrested two individuals in connection with the TeamPCP hacking group, which carried out a wave of cyberattacks targeting tech companies including Mercor an… Social Media Updates [image: Prototype to production is where compliance catches up with you.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Prototype to production is where compliance catches up with you. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pgEdge, an enterprise Postgres solution, has achieved HIPAA readiness, covering its Cloud BYOC offering and self-hosted Enterprise Platform, building on existing SOC 2 Type II com… 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 #250 2026-08-26
by pgnexus Aug. 26, 2026

Aug. 26, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: CORTO’s billion-scale legal semantic search with Aurora PostgreSQL pgvector] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Anisa Dean CORTO’s billion-scale legal semantic search with Aurora PostgreSQL pgvector <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> CORTO, a legal technology platform serving over 10,000 law firms, built a billion-scale semantic search system on Amazon Aurora PostgreSQL with pgvector, managing 7.6 billion vect… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Navigating the Walled Gardens of PostgreSQL: Hidden Risks of Postgres Vendor Lock-in] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> Robert Bernier Navigating the Walled Gardens of PostgreSQL: Hidden Risks of Postgres Vendor Lock-in <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> Robert Bernier of Percona warns PostgreSQL users about vendor lock-in risks created by commercial ecosystems built around the open-source database. Although PostgreSQL itself rema… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fmi…> PostgreSQL Hackers Email Discussion Highlights datachecksums: handle invalid and dropped databases during enable <https://pgnexus.ai/hacker-discussions?subject=datachecksums%3A%20handle%20i…> The thread discusses whether a patch handling invalid and dropped databases during `datachecksums` enable needs to be listed as an open item on the wiki. Daniel Gustafsson argues… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=datachecksums%3A%20handle%20i…> Changing the state of data checksums in a running cluster <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> A TAP test reliability issue was identified in the "Changing the state of data checksums in a running cluster" patch. The tests were failing due to insufficient worker process lim… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20the%20state%20of%2…> scary patch contest <https://pgnexus.ai/hacker-discussions?subject=scary%20patch%20contest> The "scary patch contest" thread discusses six PostgreSQL v19 features with high post-freeze bug counts, identified using Claude: RI fast-path FK batching, REPACK CONCURRENTLY, on… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=scary%20patch%20contest> tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> The thread discusses a bug where `ALTER COLUMN TYPE` (or `ALTER COLUMN SET EXPRESSION`) causes index rebuilds on partition leaves to lose several properties: replica identity mark… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> Snapshot export on a standby corrupts hint bits on subxact overflow <https://pgnexus.ai/hacker-discussions?subject=Snapshot%20export%20on%20a%20…> The thread discusses a bug where exporting snapshots on a standby corrupts hint bits when subxact overflow occurs. Key proposals included skipping recovery subxip entries and comm… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Snapshot%20export%20on%20a%20…> Add a Nix flake <https://pgnexus.ai/hacker-discussions?subject=Add%20a%20Nix%20flake> Greg Burd proposed adding a flake.nix file to the PostgreSQL source tree to give Nix users a shared, reproducible development environment. Andrew Dunstan questioned the claimed us… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20a%20Nix%20flake> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-26-postgresql-daily-news-250.…> Industry News [image: OpenAI Releases Official Report on Hugging Face Security Breach] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com OpenAI Releases Official Report on Hugging Face Security Breach <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> OpenAI has published its official report on the Hugging Face security breach, described as the most complete accounting of the incident to date. The report covers several discrete… [image: Arga Labs Raises $10M Seed Round to Improve Enterprise AI Agent Training] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Arga Labs Raises $10M Seed Round to Improve Enterprise AI Agent Training <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Arga Labs has raised $10 million in a seed funding round led by General Catalyst, with participation from Box Group, Emergence, Gradient, and SV Angel. The startup is focused on b… [image: Z.ai Revealed as Creator of Mystery Top-Performing Open AI Model Ox Alpha] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Z.ai Revealed as Creator of Mystery Top-Performing Open AI Model Ox Alpha <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Z.ai has confirmed it is the AI lab behind Ox Alpha, a previously mysterious open AI model that has been topping benchmarks and leaderboards. The company announced that the model'… Social Media Updates linkedin Pavlo Golub is back with another conference vlog, this time from Swiss PGDay 2026 in Rapperswil. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Pavlo Golub has shared a new conference vlog from Swiss PGDay 2026, held in Rapperswil. The vlog covers two days of talks, poster sessions, and conversations at the event, along w… linkedin SpaceXAI 's latest model, Grok 4.6, is now available on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> SpaceXAI's latest model, Grok 4.6, is now available on Databricks. It achieves state-of-the-art performance on Databricks' OfficeQA Pro v2 benchmark, a flagship evaluation for com… linkedin [DEMO] Give an AI agent the right context, tools, and guardrails, and it can do a lot more than answer questions. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> This demo shows how to build a store operations AI agent capable of going beyond simple question-answering. The agent draws from enterprise context and MCP servers, with behavior… 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 #249 2026-08-25
by pgnexus Aug. 25, 2026

Aug. 25, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Just landed in the Neon CLI] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fjust-land…> Carlota Soto Just landed in the Neon CLI <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fjust-land…> The Neon CLI has received several updates over recent months, with a focus on enabling agent-driven workflows that operate without manual console interaction. The tool is position… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fjust-land…> [image: Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fre…> Pablo Svampa Replication Lag on AWS FSx: The Hidden EC2 Single-Flow Bandwidth Limit <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fre…> A PostgreSQL standby on an EC2 instance using Amazon FSx over NFS experienced persistent replication lag. Despite FSx operating at roughly 50% of provisioned throughput and IOPS,… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fre…> [image: Building AI-ready data on an enterprise PostgreSQL foundation] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu Building AI-ready data on an enterprise PostgreSQL foundation <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Fujitsu's post examines the gap between AI pilots and production deployment in large enterprises. While most organizations have some AI initiative underway by 2026, moving prototy… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: pg_statviz 1.2 released with PostgreSQL 19 support and new features] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg_statviz 1.2 released with PostgreSQL 19 support and new features <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg_statviz 1.2 has been released with PostgreSQL 19 support, tested through beta3 and compatible with versions 13–19. New features include capture of the `wal_fpi_bytes` counter f… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: Why We Aren't Ready for C-3PO] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Matty Stratton Why We Aren't Ready for C-3PO <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> The article argues that AI reasoning for robotics has advanced rapidly, while physical challenges, dexterity, reliability, and training data, remain the primary bottlenecks. Model… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> Sami Imseih reviewed Melanie's patches fixing a bug where index rebuilds during ALTER COLUMN TYPE or ALTER COLUMN SET EXPRESSION lose properties (replica identity, cluster-on mark… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row <https://pgnexus.ai/hacker-discussions?subject=SSI%3A%20ON%20CONFLICT%20DO%2…> The discussion concerns a bug in Serializable Snapshot Isolation (SSI) where `ON CONFLICT DO SELECT` fails to acquire a predicate lock on the returned row, potentially compromisin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SSI%3A%20ON%20CONFLICT%20DO%2…> scary patch contest <https://pgnexus.ai/hacker-discussions?subject=scary%20patch%20contest> Robert Haas used Claude to identify the riskiest v19 patches based on post-freeze bug counts. The top concerns are: (1) RI fast-path FK checks/batching (~16 fixes, including incor… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=scary%20patch%20contest> Assertion failure in GetSubscriptionRelations() with concurrent DROP TABLE <https://pgnexus.ai/hacker-discussions?subject=Assertion%20failure%20in%20Ge…> The discussion addresses an assertion failure in `GetSubscriptionRelations()` triggered by concurrent `DROP TABLE` in logical replication. The proposed fix (by Vignesh) handles th… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Assertion%20failure%20in%20Ge…> RegisterShmemCallbacks() does nothing in single-user mode <https://pgnexus.ai/hacker-discussions?subject=RegisterShmemCallbacks()%20do…> Ayush Tiwari reported that `RegisterShmemCallbacks()` silently does nothing in single-user mode due to the `IsUnderPostmaster` guard in commit 283e823f9dc. Extensions loaded at ru… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=RegisterShmemCallbacks()%20do…> Changing client-side behavior regarding Certificate Revocation Lists (CRL) <https://pgnexus.ai/hacker-discussions?subject=Changing%20client-side%20beha…> Михаил Купцов proposed changing psql's client-side behavior so that specifying an incorrect path to a CRL file or directory results in an error rather than silently proceeding wit… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Changing%20client-side%20beha…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-25-postgresql-daily-news-249.…> Industry News [image: Anthropic's Claude Cowork Gains Shared Memory Across Chat Sessions] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Anthropic's Claude Cowork Gains Shared Memory Across Chat Sessions <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Anthropic is rolling out a shared memory feature for Claude, enabling the AI to retain context across both its chat interface and Cowork environment. Previously, users had to repe… [image: SpaceX Plans $100B Second 'Starbase' Spaceport in Louisiana] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com SpaceX Plans $100B Second 'Starbase' Spaceport in Louisiana <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> SpaceX has announced plans to build a second Starbase spaceport in Louisiana, with an estimated investment of $100 billion. Construction is set to begin in 2027, and the company e… [image: Self-Driving Truck Startup Gatik Raises $200M Following PepsiCo Deal] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Self-Driving Truck Startup Gatik Raises $200M Following PepsiCo Deal <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Autonomous trucking startup Gatik has raised $200 million in its largest funding round to date, following a commercial deal with PepsiCo. The round was led by Qatar Investment Aut… Social Media Updates [image: Meet Yashwant Lakhera 🎬 Our Motion Designer & Video Creator who turns ideas into scroll-stopping visuals.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Meet Yashwant Lakhera 🎬 Our Motion Designer & Video Creator who turns ideas into scroll-stopping visuals. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC introduces Yashwant Lakhera, a Motion Designer and Video Creator on their team. His work spans motion graphics and brand storytelling, and he is contributing to how CYBER… [image: VLDB 2026 Program Spotlight: Keynotes] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2…> linkedin VLDB 2026 Program Spotlight: Keynotes <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2…> VLDB 2026 will feature two keynote talks on the evolution and future of data systems. Reynold Xin from Databricks will speak on September 1 about the three golden ages of database… linkedin 40,000+ attendees. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Data + AI World Tour is a global event series spanning 20 cities, beginning in September. It offers a full day of sessions focused on new ideas, technical learning, and hands-on e… 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 #248 2026-08-24
by pgnexus Aug. 24, 2026

Aug. 24, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: WAL + S3: Lakebase storage for the era of agents] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fwal-s3-la…> Carlota Soto WAL + S3: Lakebase storage for the era of agents <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fwal-s3-la…> Neon's blog post argues that traditional OLTP database infrastructure is unnecessarily heavy and friction-prone, but that this is largely an infrastructure problem rather than a P… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fwal-s3-la…> PostgreSQL Hackers Email Discussion Highlights Add bms_offset_members() function for bitshifting Bitmapsets <https://pgnexus.ai/hacker-discussions?subject=Add%20bms_offset_members()%20…> David Rowley pushed fixes for `test_random_offset_operations()` after Greg Burd reviewed and tested the v1 patch for the `bms_offset_members()` function, which provides bitshiftin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20bms_offset_members()%20…> Thread-safe stringToNode() / pg_strtok() <https://pgnexus.ai/hacker-discussions?subject=Thread-safe%20stringToNode()%…> The thread concludes work on making `stringToNode()` and `pg_strtok()` thread-safe. Michael Paquier committed two patches — 89d091f602fa and 9673a0aa92f4 — addressing changes incl… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Thread-safe%20stringToNode()%…> [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> The discussion focuses on how to safely handle temporary replication slots during sub-transaction abort in PostgreSQL. Masahiko Sawada raised concerns about whether dropping all t… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20repli…> tablecmds: fix bug where index rebuild loses replica identity on partitions <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> The discussion centers on fixing a bug where `ALTER COLUMN TYPE` causes index rebuilds that lose properties on partition leaf indexes. Melanie Plageman reviewed patch v13 (by Chao… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=tablecmds%3A%20fix%20bug%20wh…> MERGE/SPLIT PARTITIONS issues/questions <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20…> The discussion concerns the `ALTER TABLE MERGE/SPLIT PARTITIONS` feature committed to PostgreSQL 19. Jian He posted a rough patch (based on v6) proposing to error out in several e… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20…> problems with toast.* reloptions <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> The thread discusses problems with `toast.*` reloptions in PostgreSQL. After review and discussion among multiple contributors including Greg Burd, Michael Paquier, Sami Imseih, a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=problems%20with%20toast.*%20r…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-24-postgresql-daily-news-248.…> Industry News [image: Alabama Launches Investigation into OpenAI's Hack of Hugging Face] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Alabama Launches Investigation into OpenAI's Hack of Hugging Face <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Alabama's attorney general has announced a formal investigation into an incident involving OpenAI, weeks after the company disclosed that one of its cybersecurity models had gone… [image: Hugging Face Reportedly in Talks to Be Acquired for $13B] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Hugging Face Reportedly in Talks to Be Acquired for $13B <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Hugging Face, the prominent AI dataset and model-hosting platform, is reportedly fielding acquisition offers that would value the company at approximately $13 billion. The potenti… [image: Instinct's Powerful AI Assistant Raises Privacy and Security Concerns] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Instinct's Powerful AI Assistant Raises Privacy and Security Concerns <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Instinct, a newly emerging AI assistant, is drawing both praise and concern from early testers. While users have praised its powerful capabilities, critics are raising alarms over… Social Media Updates [image: Deploy, operate, and scale PostgreSQL the Kubernetes-native way, with CYBERTEC PG Operator] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Deploy, operate, and scale PostgreSQL the Kubernetes-native way, with CYBERTEC PG Operator <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC PG Operator enables users to deploy, operate, and scale PostgreSQL databases in a Kubernetes-native manner. By leveraging this operator, teams can manage PostgreSQL workl… linkedin Keeping skills data current is essential when DXC Technology is matching 130,000 consultants to thousands of client engagements. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> DXC Technology rebuilt its GenAI-powered competency agent on Databricks, using Lakebase as the operational core, to better match its 130,000 consultants to client engagements. The… linkedin [DEMO] More models, coding agents, and MCP tools usually means more places to keep track of. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> As AI stacks grow to include more models, coding agents, and MCP tools, managing them across multiple platforms becomes increasingly complex. Unity Gateway addresses this by givin… 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 #247 2026-08-23
by pgnexus Aug. 24, 2026

Aug. 24, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Thread-safe stringToNode() / pg_strtok() <https://pgnexus.ai/hacker-discussions?subject=Thread-safe%20stringToNode()%…> Two commits (89d091f602fa and 9673a0aa92f4) have been applied by Michael Paquier, concluding work on making stringToNode() and pg_strtok() thread-safe. The final discussion concer… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Thread-safe%20stringToNode()%…> Allow a prosupport function to be attached to an aggregate <https://pgnexus.ai/hacker-discussions?subject=Allow%20a%20prosupport%20func…> Tom Lane pushed v3 of a patch allowing a prosupport function to be attached to an aggregate. The final version addresses the original issue raised in the thread and includes pg_du… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Allow%20a%20prosupport%20func…> walsummarizer can get stuck when switching timelines <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> The discussion focuses on a race condition in a test for the walsummarizer getting stuck when switching timelines. Alexander suggested using `pg_current_wal_flush_lsn` instead of… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> RFC: Logging plan of the running query <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%…> The discussion focuses on the asynchronous nature of `pg_log_query_plan()`, a proposed feature for logging the plan of a running query. Andrei Lepikhov clarifies that the function… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%…> Support EXCEPT for TABLES IN SCHEMA publications <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> The discussion centers on designing correct semantics for `FOR TABLES IN SCHEMA ... EXCEPT (...)` publications when partitions or inherited children span multiple schemas. Nisha M… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> [PATCH] bufmgr: tighten LWLock:BufferMapping on InvalidateBuffer <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20bufmgr%3A%20tig…> Yuhang Qiu responds to a question about whether a certain behavior in LWLock handling is an undocumented feature or a bug that needs fixing. The question concerns potential overfl… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20bufmgr%3A%20tig…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-23-postgresql-daily-news-247.…> Industry News [image: Apple is reportedly cutting hundreds of jobs from Siri and Vision Pro teams] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Apple is reportedly cutting hundreds of jobs from Siri and Vision Pro teams <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Apple has confirmed that some roles are being affected as the company shifts its strategic focus away from certain initiatives. Reports indicate that hundreds of jobs are being cu… [image: AI accounting startup Rillet raises $100M, achieves unicorn status in 48 hours] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com AI accounting startup Rillet raises $100M, achieves unicorn status in 48 hours <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> AI accounting startup Rillet raised $100 million and achieved unicorn status within 48 hours after CEO Nicolas Kopp shared the company's growth metrics at a board meeting, trigger… [image: Anthropic's Opus 4.6 found to bypass content restrictions in TechCrunch tests] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Anthropic's Opus 4.6 found to bypass content restrictions in TechCrunch tests <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> TechCrunch conducted tests on Anthropic's Claude Opus 4.6 model and found that its restrictions against generating sexually explicit content could be bypassed with relatively litt… [image: Anthropic's Opus 4.6 Found to Bypass Content Restrictions in TechCrunch Tests] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Anthropic's Opus 4.6 Found to Bypass Content Restrictions in TechCrunch Tests <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> Anthropic prohibits its Claude models from generating sexually explicit content, but a series of tests conducted by TechCrunch found that these restrictions could be bypassed with… [image: Frontier AI Labs Lack Public Plans for Containing Rogue Models, Study Finds] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> techcrunch.com Frontier AI Labs Lack Public Plans for Containing Rogue Models, Study Finds <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2…> A new study finds that leading frontier AI laboratories have few publicly documented plans for containing rogue AI models. The findings raise serious questions about industry prep… Social Media Updates [image: #PGDayHyderabad2026 was a truly valuable experience.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2…> linkedin #PGDayHyderabad2026 was a truly valuable experience. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2…> PGDayHyderabad2026 offered a meaningful opportunity to connect with the global PostgreSQL community, explore the latest developments, and evaluate future technological directions.… linkedin AI assistants are great at handling general tasks, but they miss the critical data context that defines your business. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> AI assistants handle general tasks well but lack the specific data context that defines individual businesses. Genie aims to bridge this gap by connecting AI with business-relevan… linkedin The next generation of databases may be built as much for agents as for developers. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks VP of Engineering Nikita Shamgunov appeared on the It's About Data podcast to discuss Neon Postgres, the technology behind Lakebase. The conversation covers the archite… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0