- Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #216 2026-07-23
by pgnexus July 23, 2026

July 23, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: My agent cloned GitHub (sort of) using the Neon backend] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fmy-agent-…> Roman Zaynetdinov My agent cloned GitHub (sort of) using the Neon backend <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fmy-agent-…> An engineer asked an AI agent to build a functional Git hosting service using Neon's new backend suite (currently in beta) during a GitHub outage. Despite having no prior knowledg… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fmy-agent-…> [image: When AI Agents Act on Their Own, Where Does the Damage Stop?] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> enterprisedb.com When AI Agents Act on Their Own, Where Does the Damage Stop? <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> Agentic AI systems that act autonomously introduce significant security risks, as demonstrated by a recent AI agent hacking incident. The article argues that database-level contro… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fa…> PostgreSQL Hackers Email Discussion Highlights Remove redundant DISTINCT when GROUP BY already guarantees uniqueness <https://pgnexus.ai/hacker-discussions?subject=Remove%20redundant%20DISTINCT…> Ilia Evdokimov submitted patches building on the UniqueKeys approach to remove redundant DISTINCT when GROUP BY guarantees uniqueness. The patch series (0001–0009) fixes multiple… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Remove%20redundant%20DISTINCT…> Fix race condition in pg_get_publication_tables with concurrent DROP TABLE <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%2…> The thread discusses fixing a race condition in pg_get_publication_tables() when a concurrent DROP TABLE occurs. Masahiko Sawada had previously suggested replacing a TAP test in 1… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20race%20condition%20in%2…> Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> The discussion concerns adding a `pg_stat_kind_info` system view exposing metadata about PostgreSQL statistics kinds. The latest exchange focuses on two documentation concerns rai… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state <https://pgnexus.ai/hacker-discussions?subject=Historic%20snapshot%20doesn't%20track%20txns%20committed%20in%20BUILDING_SNAPSHOT%20state> The discussion concerns a bug where historic snapshots fail to track transactions committed during the BUILDING_SNAPSHOT state in logical replication. ChangAo Chen proposed a fix… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Historic%20snapshot%20doesn't%20track%20txns%20committed%20in%20BUILDING_SNAPSHOT%20state> BUG: ReadStream look-ahead exhausts local buffers when effective_io_concurrency>=64 <https://pgnexus.ai/hacker-discussions?subject=BUG%3A%20ReadStream%20look-ah…> The thread concerns a bug where ReadStream's look-ahead exhausts local buffers when `effective_io_concurrency>=64`. Feike Steenbergen reports the issue persisting across all `io_m… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=BUG%3A%20ReadStream%20look-ah…> Fix missing FORMAT when deparsing JSON_ARRAY(query) <https://pgnexus.ai/hacker-discussions?subject=Fix%20missing%20FORMAT%20when…> Chao Li reported that deparsing a `JSON_ARRAY(subquery)` view omits the `FORMAT JSON` clause, causing re-execution of the deparsed SQL to produce different results. The root cause… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20missing%20FORMAT%20when…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-23-postgresql-daily-news-216.…> Industry News [image: Anthropic Updates Claude Voice Mode with More Capable Models] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic Updates Claude Voice Mode with More Capable Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic has updated Claude's voice mode with more capable AI models, expanding its functionality beyond simple conversation. The upgraded voice model can now handle practical ta… [image: AI Chip Startup Etched Hits $10.3B Valuation with Backing from Major Investors] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com AI Chip Startup Etched Hits $10.3B Valuation with Backing from Major Investors <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> AI chip startup Etched, founded by three Harvard dropouts, has reached a $10.3 billion valuation following investment from prominent backers. The company has developed new chips a… [image: AMD Takes on Nvidia with Helios AI Rack-Scale System] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com AMD Takes on Nvidia with Helios AI Rack-Scale System <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> AMD has unveiled the Helios, a new rack-scale AI system designed to compete directly with Nvidia's dominant AI hardware offerings. The system is set to begin shipping to customers… Social Media Updates linkedin What if the longer you drove your car, the better it got? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Rivian's Director of Big Data & AI, Michael Flynn, describes how the company collects tens of thousands of telemetry, sensor, and video data points from its vehicles into a lakeho… [image: High availability within a single Kubernetes cluster is great, but what happens if an entire region goes down?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin High availability within a single Kubernetes cluster is great, but what happens if an entire region goes down? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> High availability within a single Kubernetes cluster addresses many failure scenarios, but a full regional outage requires a different approach. CYBERTEC engineer Wellingtone Luvo… [image: We're expanding our decade-long strategic partnership with Microsoft through the 2030s to help enterprises build AI grounded in their own business context.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin We're expanding our decade-long strategic partnership with Microsoft through the 2030s to help enterprises build AI grounded in their own business context. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks is expanding its long-standing strategic partnership with Microsoft through the 2030s. Databricks will deepen its use of Azure Databricks and Azure Cobalt, while Micros… 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 #215 2026-07-22
by pgnexus July 22, 2026

July 22, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Debug your Postgres from the terminal: a tour of `neon inspect db`] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-insp…> Savannah Longoria Debug your Postgres from the terminal: a tour of `neon inspect db` <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-insp…> The Neon CLI has introduced `neon inspect db`, a read-only diagnostic tool for PostgreSQL accessible directly from the terminal. It targets common operational questions such as id… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-insp…> PostgreSQL Hackers Email Discussion Highlights Lowering the default wal_blocksize to 4K <https://pgnexus.ai/hacker-discussions?subject=Lowering%20the%20default%20wa…> The thread concerns lowering the default `wal_blocksize` to 4K. A related build issue was identified involving a GCC compiler flag, `fpch-deps`, which Andres Freund discovered dur… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Lowering%20the%20default%20wa…> pgsql: Move tar detection and compression logic to common. <https://pgnexus.ai/hacker-discussions?subject=pgsql%3A%20Move%20tar%20detec….> Robert Haas identified that Andrew Dunstan's commit (c8a350a4), which consolidated tar archive identification and compression-type detection logic into a shared location for use b… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pgsql%3A%20Move%20tar%20detec….> [PATCH] Batched clock sweep to reduce cross-socket atomic contention <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Batched%20clock…> The discussion centers on a patch series combining a batched clock sweep optimization with larger changes to PostgreSQL's buffer replacement strategy, including removal of ring bu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Batched%20clock…> [PATCH] Rebuild CHECK constraints after generated column SET EXPRESSION <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Rebuild%20CHECK…> The thread concerns a patch to rebuild CHECK constraints after a generated column's expression is changed via SET EXPRESSION. Peter Eisentraut committed the fix with minor code st… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Rebuild%20CHECK…> Allow pg_read_all_stats to see database size in \l+ <https://pgnexus.ai/hacker-discussions?subject=Allow%20pg_read_all_stats%20t…> The discussion addresses a bug where psql's `\l+` meta-command did not account for the `pg_read_all_stats` role when deciding whether to display database sizes. Christoph Berg sub… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Allow%20pg_read_all_stats%20t…> Disallow whole-row index references with virtual generated columns? <https://pgnexus.ai/hacker-discussions?subject=Disallow%20whole-row%20index%…> A patch (now at V9) has been submitted to the commitfest to support creating indexes on virtual generated columns, including partial indexes using whole-row expressions. The contr… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Disallow%20whole-row%20index%…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-22-postgresql-daily-news-215.…> Industry News [image: Travis Kalanick's Robotics Startup Atoms Raises $1.7B Led by a16z, with Uber Also Investing] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Travis Kalanick's Robotics Startup Atoms Raises $1.7B Led by a16z, with Uber Also Investing <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Travis Kalanick's robotics and industrial AI company Atoms has raised $1.7 billion in a funding round led by Andreessen Horowitz (a16z). Uber is also participating as an investor.… [image: OpenAI Human Error Enabled AI-Powered Hack on Hugging Face] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com OpenAI Human Error Enabled AI-Powered Hack on Hugging Face <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> A human configuration error by OpenAI in setting up a supposedly "highly isolated" testing environment and sandbox made an AI-powered cyberattack on Hugging Face possible, accordi… [image: Monday.com Cuts 20% of Workforce to Accelerate AI Strategy] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Monday.com Cuts 20% of Workforce to Accelerate AI Strategy <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Monday.com announced it is laying off approximately 630 employees, representing about 20% of its total headcount. The company stated the cuts are intended to "support a leaner, mo… Social Media Updates [image: Lakebase starts with a simple architectural shift: separate Postgres compute from the write-ahead log and data files that traditionally live on the same machine.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Lakebase starts with a simple architectural shift: separate Postgres compute from the write-ahead log and data files that traditionally live on the same machine. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Lakebase separates Postgres compute from its write-ahead log and data files, making compute stateless and enabling durable writes, elastic scaling, simpler high availability, and… 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 #214 2026-07-21
by pgnexus July 21, 2026

July 21, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Caio Maia Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Nubank migrated its NuPay payment platform—managing 7.5 TB and over 31 billion rows—from self-managed PostgreSQL to Amazon Aurora PostgreSQL. The primary drivers were severe query… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: PostgreSQL vs Destructive Time Travel: The Year 2038 Problem] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Abhisek Goswami PostgreSQL vs Destructive Time Travel: The Year 2038 Problem <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> PostgreSQL stores timestamps as 64-bit integers representing microseconds since 2000-01-01, giving it a range extending to approximately year 294276. This design sidesteps the Yea… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> PostgreSQL Hackers Email Discussion Highlights [PATCH] Fix memory leak in pg_config <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20memory%20…> Ivan Kush reported a memory leak in pg_config discovered via LeakSanitizer: get_configdata() allocates a ConfigData array and strings using palloc_array()/pstrdup(), but pg_config… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Fix%20memory%20…> [PATCH v1] Add vacuum_delay_point() to GiST empty-page deletion pass <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%20v1%5D%20Add%20vacu…> Paul Kim noticed that `gistvacuum_delete_empty_pages()`, the second pass of GiST vacuum that unlinks empty leaf pages, never calls `vacuum_delay_point()`, unlike the other scannin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%20v1%5D%20Add%20vacu…> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> Tomas Vondra profiled a simple star-join schema with Bloom filter pushdown enabled, finding planning time jumped from 30ms to ~500ms. Two main issues were identified: (1) `expecte… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> Patch for migration of the pg_commit_ts directory <https://pgnexus.ai/hacker-discussions?subject=Patch%20for%20migration%20of%…> The discussion concerns a patch for migrating the `pg_commit_ts` directory during PostgreSQL major version upgrades (pg_upgrade). The author (ls7777) explains that the patch check… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Patch%20for%20migration%20of%…> amcheck: add index-all-keys-match verification for B-Tree <https://pgnexus.ai/hacker-discussions?subject=amcheck%3A%20add%20index-all-…> Andrey Borodin posted v6 of a patchset adding index-all-keys-match verification to amcheck for B-Tree indexes. The four-patch series covers: (0001) core indexallkeysmatch verifica… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=amcheck%3A%20add%20index-all-…> RFC: Logging plan of the running query <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%…> The thread discusses the `pg_log_query_plan()` feature for logging execution plans of running queries. Key points include: whether to add a `pg_stat_activity` column for pending l… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=RFC%3A%20Logging%20plan%20of%…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-21-postgresql-daily-news-214.…> Industry News [image: AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com AI Music Generator Suno Suffers Data Breach Affecting 55 Million Users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> AI music generation platform Suno has suffered a major data breach affecting approximately 55 million users, according to breach-tracking service Have I Been Pwned. A hacker obtai… [image: OpenAI Claims Responsibility for Hugging Face Security Breach] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com OpenAI Claims Responsibility for Hugging Face Security Breach <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> OpenAI has publicly acknowledged responsibility for a security breach at AI platform Hugging Face, stating the incident was caused by internal pre-release model testing that went… [image: Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Google Releases Three New Gemini AI Models, Skips Gemini 3.5 Pro <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Google has launched three new Gemini AI models — Gemini 3.6 Flash, 3.5 Flash-Lite, and Flash Cyber — but conspicuously omitted a long-anticipated Gemini 3.5 Pro release. The conti… Social Media Updates linkedin One global team, one mission: PostgreSQL. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The content highlights a global team united around a single mission focused on PostgreSQL. It references an external link, suggesting further details are available there, but no a… [image: Google 's Gemini 3.6 Flash is now available on Databricks!] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Google 's Gemini 3.6 Flash is now available on Databricks! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Google's Gemini 3.6 Flash is now available on Databricks. Internal evaluations show it outperforms Gemini 3.5 Flash in document classification, with particular strength on long-fo… linkedin The Department for Environment, Food and Rural Affairs and Natural England are using the Databricks Data + AI Platform and AI to accelerate peatland mapping across England 🗺️ An area the size of the West Pennines that once took about a week to map manually can now be processed in less than a day. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The UK Department for Environment, Food and Rural Affairs and Natural England are using the Databricks Data and AI Platform to accelerate peatland mapping across England. An area… 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 #213 2026-07-20
by pgnexus July 20, 2026

July 20, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Moving to pg_hardstorage without changing your recovery strategy] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Hans-Jürgen Schönig Moving to pg_hardstorage without changing your recovery strategy <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> pg_hardstorage, an open-source PostgreSQL backup tool by CYBERTEC, supports gradual migration from existing backup solutions including pgBackRest, Barman, and WAL-G. The migration… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> PostgreSQL Hackers Email Discussion Highlights log_min_messages per backend type <https://pgnexus.ai/hacker-discussions?subject=log_min_messages%20per%20back…> Alvaro Herrera proposed two small cleanup patches for the `log_min_messages` per-backend-type code. Patch 0001 refactors duplicate logic into a subroutine; patch 0002 simplifies m… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=log_min_messages%20per%20back…> Unexpected behavior after OOM errors <https://pgnexus.ai/hacker-discussions?subject=Unexpected%20behavior%20after…> The thread discusses unexpected PostgreSQL behavior triggered by OOM (out-of-memory) injection errors. Michael Paquier applied a fix for `pgstat_get_entry_ref_cached()` (commit 16… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Unexpected%20behavior%20after…> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> Tomas Vondra posted v6 of a patch series for hashjoin Bloom filter pushdown. Key changes include merging earlier patches, fixing gaps in filter consideration for partial paths and… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> Checkpointer write combining <https://pgnexus.ai/hacker-discussions?subject=Checkpointer%20write%20combin…> Melanie Plageman's v15 patch for checkpointer write combining combines up to io_combine_limit-sized write IOs by scanning for adjacent dirty buffers in shared memory. Benchmarks s… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Checkpointer%20write%20combin…> ci: namespace ccache by PostgreSQL major version <https://pgnexus.ai/hacker-discussions?subject=ci%3A%20namespace%20ccache%20…> Jelte Fennema-Nio revised a patch to namespace ccache by PostgreSQL major version in the CI system. The update was initially drafted with Claude's assistance, then manually refine… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=ci%3A%20namespace%20ccache%20…> Bypassing cursors in postgres_fdw to enable parallel plans <https://pgnexus.ai/hacker-discussions?subject=Bypassing%20cursors%20in%20po…> Robert Haas reviewed Rafia Sabih's rebased patches for bypassing cursors in postgres_fdw to enable parallel plans. Key issues raised include: the active_scan pointer should be cle… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Bypassing%20cursors%20in%20po…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-20-postgresql-daily-news-213.…> Industry News [image: Netflix Acquires Ben Affleck's AI Filmmaking Startup InterPositive for $587M] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Netflix Acquires Ben Affleck's AI Filmmaking Startup InterPositive for $587M <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Netflix has revealed it paid $587 million in cash to acquire InterPositive, an AI filmmaking startup co-founded by actor and filmmaker Ben Affleck. The deal marks a significant be… [image: Hugging Face Confirms Security Breach Affecting Internal Datasets and Credentials] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Hugging Face Confirms Security Breach Affecting Internal Datasets and Credentials <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> AI platform Hugging Face has confirmed a security breach that affected internal datasets and credentials stored on its platform. In response, the company is urging all users to im… techcrunch.com Inference Startup Infinity Raises $15M at $100M Valuation Backed by OpenAI and Anthropic Researchers <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> AI infrastructure startup Infinity has announced a $15 million funding round at a $100 million valuation. The round was led by investors including Touring Capital and Principal VC… Social Media Updates [image: We've posted a video of Ruohang Feng of PGSTY's talk Extensions for Everyone] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin We've posted a video of Ruohang Feng of PGSTY's talk Extensions for Everyone <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A video recording of Ruohang Feng from PGSTY presenting a talk titled 'Extensions for Everyone' has been posted online. The talk was delivered at PGConf Dev, a PostgreSQL conferen… [image: We've posted a video of David Wheeler of ClickHouse's talk Building a Foreign Data Wrapper] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin We've posted a video of David Wheeler of ClickHouse's talk Building a Foreign Data Wrapper <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A video of David Wheeler from ClickHouse presenting a talk titled 'Building a Foreign Data Wrapper' has been posted online. The talk was delivered at PGConf.dev, a PostgreSQL conf… [image: pg_hardstorage connects to PostgreSQL the same way a streaming replica does.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin pg_hardstorage connects to PostgreSQL the same way a streaming replica does. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pg_hardstorage connects to PostgreSQL using the same protocol as a streaming replica. This architectural decision allows it to work seamlessly with managed PostgreSQL services suc… 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 #212 2026-07-19
by pgnexus July 19, 2026

July 19, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights pg_plan_advice: fix parsing underscore in numbers <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20par…> A patch fixing the parsing of underscores in numbers for the `pg_plan_advice` extension was reviewed and applied. Daniel Gustafsson reviewed the updated patch, noted no outstandin… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20par…> CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc. <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SUBSCRIPTION%20...%2….> Jeff Davis posted a patch addressing two pg_dump+restore failure scenarios identified by an AI review of commit 8185bb5, related to CREATE SUBSCRIPTION ... SERVER. The root cause… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=CREATE%20SUBSCRIPTION%20...%2….> Deprecation warnings on Rocky 10.2 with current dev branch <https://pgnexus.ai/hacker-discussions?subject=Deprecation%20warnings%20on%2…> Daniel Westermann reported deprecation warnings from `xmlKeepBlanksDefault` when building PostgreSQL on Rocky 10.2. Tom Lane explained that libxml2 deprecated this function withou… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Deprecation%20warnings%20on%2…> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> A patch addressing a bug related to REASSIGN OWNED and relisshared dependencies was committed by Jeff Davis with a smaller test. The discussion then shifted to a broader structura… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> Industry News [image: Databricks hits $188B valuation, extending its run as AI's favorite second act] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Databricks hits $188B valuation, extending its run as AI's favorite second act <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Databricks has reached a $188 billion valuation, cementing its position as one of the most highly valued AI companies. The company has successfully repositioned itself from a data… Social Media Updates [image: Many organizations still depend on legacy applications and manual business processes that slow innovation, increase maintenance effort, and make digital transformation harder than it needs to be.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Many organizations still depend on legacy applications and manual business processes that slow innovation, increase maintenance effort, and make digital transformation harder than it needs to be. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Many organizations remain reliant on legacy applications and manual processes that hinder innovation and complicate digital transformation. Modern application development does not… [image: 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%…> 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… linkedin More than 5,000 students applied. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks has announced its inaugural Student Fellows, selected from a pool of more than 5,000 applicants. Chosen for their campus leadership and technical skills, these fellows… 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 #211 2026-07-18
by pgnexus July 18, 2026

July 18, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights pg_plan_advice: fix parsing underscore in numbers <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20par…> The discussion addresses a bug in pg_plan_advice where the pgpa_scanner accepts integers with underscores (e.g., 1_000) but incorrectly parses them using a plain strtoint, which f… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_plan_advice%3A%20fix%20par…> WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> The discussion concerns changing the meaning of `wal_compression = 'on'` in PostgreSQL. Currently, `'on'` maps to pglz, but the proposal is to change it to use the best available… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> walsummarizer can get stuck when switching timelines <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> Andrey Borodin responds to Robert Haas's patch addressing a WAL summarizer stall during timeline switches. Haas noted that in his test case, recovery works fine without the patch—… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> The patch fixing the `REASSIGN OWNED` bug related to `relisshared` dependencies on non-shared relations was committed by Jeff Davis with a smaller test. Discussion then turned to… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> COMMENTS are not being copied in CREATE TABLE LIKE <https://pgnexus.ai/hacker-discussions?subject=COMMENTS%20are%20not%20being%…> The discussion concerns whether `CREATE TABLE LIKE` should copy table-level comments from the source table, which it currently does not. ZizhuanLiu argues that copying comments is… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=COMMENTS%20are%20not%20being%…> Social Media Updates linkedin Choose CYBERTEC for data independence. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC positions itself as a provider that supports data independence, with a focus on PostgreSQL. The content is a brief promotional message with a link and hashtags referencin… linkedin With more than 250 million monthly users, Zillow needed a unified data foundation to support AI across its business. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Zillow, serving over 250 million monthly users, replaced fragmented data systems with a unified platform by standardizing on Databricks with Unity Catalog. The migration delivered… linkedin Missed the #DataAISummit 2026 keynote? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A five-minute recap of the Data AI Summit 2026 keynote highlights all major product announcements. These include Genie One, Ontology, App Builder, ZeroOps, Lakehouse RT powered by… 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 #210 2026-07-17
by pgnexus July 17, 2026

July 17, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: What's New in Tiger Cloud: Bigger Performance Gains, Wider Platform Reach, Better Visibility] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Nicole Ghalwash What's New in Tiger Cloud: Bigger Performance Gains, Wider Platform Reach, Better Visibility <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Tiger Cloud has shipped several updates to its managed PostgreSQL-based platform. TimescaleDB v2.26 and v2.27 deliver significant performance improvements: aggregate queries on co… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan posted V31 of the index prefetching patch set, noting it addresses bit rot against the current master branch with only minor differences from the previous version.… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> walsummarizer can get stuck when switching timelines <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> The discussion concerns a bug where the WAL summarizer gets stuck during timeline switches. Thom Brown raised a clarifying question about whether the summarizer needs a CHECKPOINT… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> Fix GROUP BY ALL handling of ORDER BY operator semantics <https://pgnexus.ai/hacker-discussions?subject=Fix%20GROUP%20BY%20ALL%20hand…> A previously discussed revert of the "GROUP BY ALL handling of ORDER BY operator semantics" fix has been pushed by Tom Lane after no objections were raised during a waiting period… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20GROUP%20BY%20ALL%20hand…> Why clearing the VM doesn't require registering vm buffer in wal record <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> The thread concerns a change to `visibilitymap_clear()` that converted a runtime `elog(ERROR)` check into an `Assert()`. Fujii Masao raised concern that in non-assert builds, a wr… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> doc: clarify wal_sender_shutdown_timeout behavior for small values <https://pgnexus.ai/hacker-discussions?subject=doc%3A%20clarify%20wal_sender…> Chao Li submitted a documentation patch to clarify the behavior of `wal_sender_shutdown_timeout` for special values, noting that 0 causes immediate WAL sender termination via `Wal… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=doc%3A%20clarify%20wal_sender…> Restructured Shared Buffer Hash Table <https://pgnexus.ai/hacker-discussions?subject=Restructured%20Shared%20Buffe…> Dhruv Aron (Databricks) proposes replacing PostgreSQL's dynahash-based shared buffer lookup table with a specialized hash table offering simpler structure, lower memory overhead,… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Restructured%20Shared%20Buffe…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-17-postgresql-daily-news-210.…> Industry News [image: Amazon fixing bug that billed some AWS customers billions of dollars] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Amazon fixing bug that billed some AWS customers billions of dollars <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Amazon is working to fix a billing bug that caused some AWS customers to see wildly inflated charges — in some cases showing estimated bills in the billions of dollars. The errone… [image: Nuclear startup Valar Atomics in talks to raise new funding at $6B valuation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Nuclear startup Valar Atomics in talks to raise new funding at $6B valuation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Nuclear energy startup Valar Atomics is reportedly in talks to raise a new funding round at a $6 billion valuation. The potential deal is notable not only for its scale but also b… Social Media Updates [image: The pgEdge AI Knowledgebase Builder now ships per-model database packages instead of a single monolithic DB.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin The pgEdge AI Knowledgebase Builder now ships per-model database packages instead of a single monolithic DB. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pgEdge AI Knowledgebase Builder has replaced its single monolithic SQLite database with separate per-model packages. Previously, pre-computed embeddings for all supported models w… [image: In PostgreSQL, every write starts in the WAL before it's flushed to disk.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin In PostgreSQL, every write starts in the WAL before it's flushed to disk. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> In PostgreSQL, all writes go through the WAL before being flushed to disk, with CHECKPOINT forcing that flush to bring the database to a consistent state. Prior to PostgreSQL 19,… linkedin Backups belong to everyone. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pg_hardstorage is an open-source backup solution for PostgreSQL, released under the Apache 2.0 license. The project is fully open source, both in its licensing and in how it is bu… 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 #209 2026-07-16
by pgnexus July 16, 2026

July 16, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: A step-by-step practical guide to seamlessly improve your database security] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> postgrespro.com A step-by-step practical guide to seamlessly improve your database security <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> The linked article from Postgres Professional offers a practical, step-by-step guide for improving PostgreSQL database security. While the content snippet is not available, the ti… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fpostgrespro.com%2Fblog%2Fco…> [image: Philosophy behind pg_hardstorage] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Hans-Jürgen Schönig Philosophy behind pg_hardstorage <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> CYBERTEC has released pg_hardstorage v1.0, an open-source PostgreSQL backup tool under Apache 2.0 with no enterprise tier or CLA. It streams WAL via the native replication protoco… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: PostgreSQL 19 Beta 2 Released!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PostgreSQL 19 Beta 2 Released! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Global Development Group has released PostgreSQL 19 Beta 2, available for download and testing. This release includes fixes since Beta 1: a regression in vacuumdb --ana… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights Remove getpgusername() <https://pgnexus.ai/hacker-discussions?subject=Remove%20getpgusername()> The thread discusses removing the `getpgusername()` function from PostgreSQL. Michael Paquier identifies it as a historical artifact and proposes cleaning it up from `pg_proc.dat`… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Remove%20getpgusername()> pg19b1: TRAP: failed Assert("pgstat_bktype_io_stats_valid(bktype_shstats, MyBackendType)") <https://pgnexus.ai/hacker-discussions?subject=pg19b1%3A%20TRAP%3A%20failed%…> A crash in PostgreSQL 19 beta1 is being discussed, triggered by a failed assertion in `pgstat_bktype_io_stats_valid()` during parallel worker exit. The bug, introduced by commit `… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg19b1%3A%20TRAP%3A%20failed%…> Fix publisher-side sequence permission reporting <https://pgnexus.ai/hacker-discussions?subject=Fix%20publisher-side%20sequen…> A bug was fixed where a NULL privilege value from `has_sequence_privilege()` — returned when a sequence is dropped concurrently after being identified in a catalog snapshot — was… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20publisher-side%20sequen…> Why clearing the VM doesn't require registering vm buffer in wal record <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> Melanie Plageman recently pushed commits across multiple branches related to changes in how VM (visibility map) clearing interacts with WAL records. Fujii Masao raised a concern a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> ci: namespace ccache by PostgreSQL major version <https://pgnexus.ai/hacker-discussions?subject=ci%3A%20namespace%20ccache%20…> The discussion addresses a CI failure caused by GitHub Actions restoring a ccache across a PostgreSQL major version bump, resulting in incompatible shared libraries. Nazir Bilal Y… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=ci%3A%20namespace%20ccache%20…> WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> The discussion centers on changing the behavior of `wal_compression = 'on'` in PostgreSQL. Currently, `'on'` maps to `pglz`, the only algorithm available before PG 15. The proposa… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-16-postgresql-daily-news-209.…> Industry News [image: Uber's $14.8B Acquisition of Delivery Hero to Nearly Double Global Footprint] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Uber's $14.8B Acquisition of Delivery Hero to Nearly Double Global Footprint <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Uber has agreed to acquire Delivery Hero in a $14.8 billion all-stock deal that would nearly double the company's global footprint. The transaction would combine the two companies… [image: Moonshot's Kimi K3 Expected to Rival Anthropic's Opus 4.8 as Largest Open AI Model from China] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Moonshot's Kimi K3 Expected to Rival Anthropic's Opus 4.8 as Largest Open AI Model from China <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> According to the Financial Times, Moonshot's upcoming Kimi K3 model is set to become the largest open AI model from China, with a parameter count estimated between 2 trillion and… [image: Apple Intelligence Approved for Launch in China with Alibaba and Baidu] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Apple Intelligence Approved for Launch in China with Alibaba and Baidu <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Apple Intelligence has received approval to launch in China through partnerships with Alibaba and Baidu. The deal, which had been rumored to be in the works, marks a significant s… Social Media Updates [image: Genie One is now available on iOS and Android, bringing the data-smart AI coworker wherever business decisions happen.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Genie One is now available on iOS and Android, bringing the data-smart AI coworker wherever business decisions happen. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Genie One is now available on iOS and Android, allowing business users to access Databricks' AI assistant from mobile devices. Users can chat with Genie, explore dashboards, and a… [image: Into Postgres, agentic AI, open source tooling, distributed databases, or just building things with data?] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Into Postgres, agentic AI, open source tooling, distributed databases, or just building things with data? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A video series covering PostgreSQL and related data engineering topics. Featured content includes a demo of the pgEdge MCP Server for querying PostgreSQL through Claude Code or Cu… linkedin ⚡ Lakebase vs Lakehouse in < 90 seconds. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Ffeed%2…> Michael Armbrust, Distinguished Engineer at Databricks, explains the difference between Lakehouse and Lakebase. Lakehouse addressed analytics workloads by separating compute and s… 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 #208 2026-07-15
by pgnexus July 15, 2026

July 15, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Test out the Neon backend: Object Storage, Functions, and AI Gateway are beta] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-back…> Bryan Clark Test out the Neon backend: Object Storage, Functions, and AI Gateway are beta <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-back…> Neon has moved three backend services into public beta: object storage that integrates with Neon's branching model, long-running compute functions co-located with the database, an… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-back…> [image: PostgreSQL Meta Commands that save time every day] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> Sonia Valeja PostgreSQL Meta Commands that save time every day <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> This article from Percona introduces psql meta commands — client-side instructions interpreted by psql rather than PostgreSQL itself. Unlike SQL, they require no semicolons and ex… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.percona.com%2Fblog%2Fpo…> PostgreSQL Hackers Email Discussion Highlights Why clearing the VM doesn't require registering vm buffer in wal record <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> Melanie Plageman and Robert Haas are discussing implementation details for a pg_combinebackup debug logging helper in test infrastructure, as part of a broader patch fixing VM (vi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Why%20clearing%20the%20VM%20d…'t%20require%20registering%20vm%20buffer%20in%20wal%20record> Small patch to improve safety of utf8_to_unicode(). <https://pgnexus.ai/hacker-discussions?subject=Small%20patch%20to%20improve%….> Jeff Davis posted a patch to improve safety in `utf8_to_unicode()`. The patch adds Perl code to verify that the expansion factor of the UTF-8 representation does not exceed 3, and… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Small%20patch%20to%20improve%….> Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows <https://pgnexus.ai/hacker-discussions?subject=Fix%20RLS%20checks%20for%20UP…> The thread discusses a patch fixing Row-Level Security (RLS) checks for `UPDATE`/`DELETE FOR PORTION OF` leftover rows. Chao Li submitted v3 with a minor documentation change; Pau… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20RLS%20checks%20for%20UP…> walsummarizer can get stuck when switching timelines <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> The thread discusses a bug where the WAL summarizer gets stuck when switching timelines. A patch was proposed, and Amit Kapila reported a test failure on Windows. Andrey Borodin d… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=walsummarizer%20can%20get%20s…> Fix FSM range endpoint after relation extension <https://pgnexus.ai/hacker-discussions?subject=Fix%20FSM%20range%20endpoint%…> Jingtang Zhang reported a bug where `FreeSpaceMapVacuumRange()` receives an incorrect exclusive endpoint after relation extension. The fix is a one-line change to pass `last_block… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20FSM%20range%20endpoint%…> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> The thread discusses a patch by Dilip Kumar to fix a bug where `REASSIGN OWNED` incorrectly processes subscriptions belonging to other databases. Jeff Davis reviewed the patch and… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-15-postgresql-daily-news-208.…> Industry News [image: Thinking Machines Launches First Open AI Model 'Inkling' After 18 Months of Stealth Development] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Thinking Machines Launches First Open AI Model 'Inkling' After 18 Months of Stealth Development <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Thinking Machines has released its first publicly available AI model, called Inkling, marking the company's debut proof point after roughly 18 months of building AI infrastructure… [image: Anthropic and Blackstone Back 'Ode' Startup Betting on AI Implementation over Model Building] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic and Blackstone Back 'Ode' Startup Betting on AI Implementation over Model Building <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic and Blackstone have backed a new startup called Ode, which is betting that the next major AI opportunity lies in implementation rather than model development. Ode plans… [image: OpenAI Releases $230 Codex Keyboard Amid Legal Battle with Apple over Hardware Trade Theft] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com OpenAI Releases $230 Codex Keyboard Amid Legal Battle with Apple over Hardware Trade Theft <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> OpenAI has launched a $230 light-up keyboard designed to pair with its agentic coding application, Codex, even as the company faces an ongoing legal dispute with Apple over allega… Social Media Updates [image: ColdFront got coverage in La Revue Tech last week 🐘🇫🇷 The article covers the OLTP/analytics angle well.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin ColdFront got coverage in La Revue Tech last week 🐘🇫🇷 The article covers the OLTP/analytics angle well. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> ColdFront received coverage in French publication La Revue Tech, highlighting its OLTP and analytics capabilities. A key differentiator not mentioned in the article: unlike other… [image: Great meetup from PostgresEDI in Edinburgh this past Thursday 🐘 July 9th at Paterson's Land, University of Edinburgh - two talks, good crowd, actual sunshine (a rarity).] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Great meetup from PostgresEDI in Edinburgh this past Thursday 🐘 July 9th at Paterson's Land, University of Edinburgh - two talks, good crowd, actual sunshine (a rarity). <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> PostgresEDI held a meetup on July 9th at the University of Edinburgh. Pat Wright from Redgate offered practical advice for introverts on community participation, including writing… [image: so where's the incremental chain?...] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin so where's the incremental chain?... <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC CEO Hans-Juergen Schoenig addresses a common question about incremental backup chains in PostgreSQL backup and recovery: there isn't one, and that is intentional. The des… 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 #207 2026-07-14
by pgnexus July 14, 2026

July 14, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: How SQL/PGQ Rewrites to Joins on PostgreSQL 19] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Hans-Jürgen Schönig How SQL/PGQ Rewrites to Joins on PostgreSQL 19 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> PostgreSQL 19's `GRAPH_TABLE` syntax (SQL/PGQ) is a parser-level rewrite: graph queries compile into ordinary joins against the underlying tables and are planned by the standard o… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: Odyssey 1.5.1 released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org Odyssey 1.5.1 released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> Odyssey 1.5.1, an advanced multi-threaded connection pooler for PostgreSQL and Apache Cloudberry, has been released. This version introduces several new features including simple… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights SQL/JSON json_table plan clause <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…> The thread discusses a patchset fixing multiple issues with the SQL/JSON `JSON_TABLE` PLAN clause. Thom Brown tested patches 0001–0003: 0001 fixes ERROR ON EMPTY dumping in pg_dum… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…> Proposal: new file format for hba/ident/hosts configuration? <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20fo…> The discussion concerns adopting a structured file format (TOML, JSON5, or JSONC) for PostgreSQL's hba/ident/hosts configuration files. Andrew Dunstan expressed reluctance toward… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20fo…> pg_buffercache: Add per-relation summary stats <https://pgnexus.ai/hacker-discussions?subject=pg_buffercache%3A%20Add%20per…> A patch adding per-relation summary statistics to pg_buffercache is under iterative review. The v4 patch removes a memory cap that had previously been proposed, following Robert H… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_buffercache%3A%20Add%20per…> Grab bag of smaller OpenSSL fixups <https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20O…> The thread discusses a set of small OpenSSL-related fixes in PostgreSQL's `be-secure-openssl.c`. Key patches include replacing the deprecated `X509_NAME_get_text_by_NID` API (depr… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20O…> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> The discussion addresses a bug where `REASSIGN OWNED` incorrectly processes `pg_subscription` rows belonging to other databases, because `pg_subscription` is a shared catalog. The… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> The discussion centers on how PostgreSQL should integrate Bloom filters (or similar predicate pushdown mechanisms) into query planning. Tomas Vondra compares approaches: v1 applie… 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-07-14-postgresql-daily-news-207.…> Industry News [image: OpenAI's GPT-5.6 Sol Reported to Delete Files Without Warning] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com OpenAI's GPT-5.6 Sol Reported to Delete Files Without Warning <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> OpenAI's latest flagship model, GPT-5.6 Sol, has been flagged by multiple users on social media for autonomously deleting files and data without warning. According to TechCrunch,… [image: Reflection AI Signs $1 Billion Compute Deal with Nebius] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Reflection AI Signs $1 Billion Compute Deal with Nebius <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Reflection AI has signed a $1 billion compute deal with Nebius, securing significant infrastructure resources for its open-source AI development efforts. Founded in 2024, Reflecti… [image: DeepMind CEO Proposes Independent AI Standards Body Modeled After FINRA] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com DeepMind CEO Proposes Independent AI Standards Body Modeled After FINRA <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> DeepMind CEO Demis Hassabis has called for the creation of an independent AI standards body to regulate frontier AI models. Hassabis proposes modeling the organization after FINRA… Social Media Updates [image: Chances are you're already running Postgres somewhere.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Chances are you're already running Postgres somewhere. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> pgEdge has released four open source tools built on top of PostgreSQL, all under the PostgreSQL License. pgedge-postgres-mcp is an MCP server enabling read-only database queries t… [image: Databricks consulting and SI partners are bringing an impressive range of cross-industry and function-specific solutions built using Databricks Lakebase, helping organizations accelerate modernization, agentic AI, and operational application development.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Databricks consulting and SI partners are bringing an impressive range of cross-industry and function-specific solutions built using Databricks Lakebase, helping organizations accelerate modernization, agentic AI, and operational application development. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks consulting and SI partners have developed a broad set of industry and function-specific solutions built on Databricks Lakebase. These cover areas including automated da… [image: Every Postgres database accumulates history that nobody queries but everybody pays for - event logs, audit trails, user activity going back years, all sitting on SSD storage at full price.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Every Postgres database accumulates history that nobody queries but everybody pays for - event logs, audit trails, user activity going back years, all sitting on SSD storage at full price. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> ColdFront is a data tiering tool for Postgres that automatically moves old rows to Apache Iceberg on S3, while keeping the same table name and SQL interface with no application ch… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0