July 2026 - Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #214 2026-07-21

by pgnexus

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

July 21, 2026

PGNexus Daily News #213 2026-07-20

by pgnexus

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

July 20, 2026

PGNexus Daily News #212 2026-07-19

by pgnexus

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

July 19, 2026

PGNexus Daily News #211 2026-07-18

by pgnexus

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

July 18, 2026

PGNexus Daily News #210 2026-07-17

by pgnexus

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

July 17, 2026

PGNexus Daily News #209 2026-07-16

by pgnexus

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

July 16, 2026

PGNexus Daily News #208 2026-07-15

by pgnexus

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

July 15, 2026

PGNexus Daily News #207 2026-07-14

by pgnexus

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

July 14, 2026

PGNexus Daily News #206 2026-07-13

by pgnexus

PGNexus Daily News PostgreSQL Technical Articles [image: Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Santosh Mishra Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Large index rebuilds on Amazon Aurora PostgreSQL can fail due to insufficient temporary storage, since PostgreSQL spills sort data to disk during REINDEX. This post describes comb… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Introducing @neon/sdk, our new TypeScript client for the Neon API] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-sdk> Andre Landgraf Introducing @neon/sdk, our new TypeScript client for the Neon API <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-sdk> Neon has released @neon/sdk, a TypeScript client library for the Neon API. While the existing Neon API is OpenAPI-compliant and supports programmatic management of database infras… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-sdk> PostgreSQL Hackers Email Discussion Highlights Row pattern recognition <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> Henson Choi posted a detailed review of the row pattern recognition (RPR) navigation offset consolidation patches (v51). While v51-0001 fixes the forward reach regression for FIRS… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition> hashjoins vs. Bloom filters (yet again) <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> The discussion focuses on integrating Bloom filter (and more general runtime filter) pushdown into PostgreSQL's query planner. Matheus Alcantara posted a v5 PoC patch refining can… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…> incremental backup issue <https://pgnexus.ai/hacker-discussions?subject=incremental%20backup%20issue> The thread discusses a bug in PostgreSQL 17.7's walsummarizer process on standbys, where it repeatedly logs "invalid record length ... got 0" every 10 seconds and never advances.… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=incremental%20backup%20issue> Grab bag of smaller OpenSSL fixups <https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20O…> Daniel Gustafsson submitted four small OpenSSL cleanup patches: removing a static variable that could interfere with future multithreading, replacing the deprecated `SSLv23_method… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20O…> PSQL - prevent describe listing tables that are already in listed schemas <https://pgnexus.ai/hacker-discussions?subject=PSQL%20-%20prevent%20describe…> A patch to prevent psql's describe commands from listing tables that are already covered by listed schemas has been committed. Amit Kapila had previously reviewed and approved the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=PSQL%20-%20prevent%20describe…> Vacuum statistics <https://pgnexus.ai/hacker-discussions?subject=Vacuum%20statistics> Alena Rybakina posted a rebased v40 patch series adding vacuum statistics to PostgreSQL, organized so each commit introduces one category of stats. Bharath Rupireddy reviewed the… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Vacuum%20statistics> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-13-postgresql-daily-news-206.…> Industry News [image: Apple's Trade Secrets Lawsuit Against OpenAI: The Wildest Allegations] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Apple's Trade Secrets Lawsuit Against OpenAI: The Wildest Allegations <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Apple's trade secrets lawsuit against OpenAI contains a series of striking allegations, including claims that employees joked about unauthorized access to Apple's systems and that… [image: Anthropic Launches Localized Claude Pricing for India] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic Launches Localized Claude Pricing for India <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic has begun localizing pricing for its Claude AI assistant in India, which is described as the company's biggest market outside the United States. Users in India are start… [image: Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI Models] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI Models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Microsoft CEO Satya Nadella has issued a warning to companies using AI, addressing concerns that large AI labs selling proprietary models could be acting as "Trojan horses" for th… Social Media Updates [image: A recap of our PostgresEDI July meetup: Pat Wright on speaking and community involvement for the introvert, and Otun Martins on traceable, SQL-first retrieval for compliance-critical AI systems Blog post in comments below 👇 #PostgreSQL #Postgres #Edinburgh #OpenSource #TechMeetups #Database] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin A recap of our PostgresEDI July meetup: Pat Wright on speaking and community involvement for the introvert, and Otun Martins on traceable, SQL-first retrieval for compliance-critical AI systems Blog post in comments below 👇 #PostgreSQL #Postgres #Edinburgh #OpenSource #TechMeetups #Database <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The PostgresEDI July meetup featured two talks. Pat Wright addressed how introverted individuals can engage in public speaking and community participation within the tech space. O… linkedin Enterprise security, compliance, and performance, built directly into PostgreSQL. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC PGEE enhances PostgreSQL with enterprise-grade capabilities built natively into the database, rather than added as external layers. Key features include Transparent Data… linkedin How do you diagnose whether a Postgres bottleneck is CPU, I/O, or network? <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> At POSETTE 2026, Rahila Syed demonstrated how to iteratively profile PostgreSQL performance using perf and pgbench, showing how bottlenecks shift as optimizations are applied. Usi… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

July 13, 2026

PGNexus Daily News #205 2026-07-12

by pgnexus

PGNexus Daily News PostgreSQL Technical Articles [image: powa-archivist 5.2.0 is out!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org powa-archivist 5.2.0 is out! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> powa-archivist 5.2.0 has been released by the PoWA team. This version adds support for PostgreSQL 19, including the new statistical views pg_stat_recovery and pg_stat_lock, contri… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights Add pg_stat_vfdcache view for VFD cache statistics <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view…> The thread discusses adding a `pg_stat_vfdcache` view to expose VFD (Virtual File Descriptor) cache statistics for tuning `max_files_per_process`. Key design questions include whe… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view…> allow spread checkpoints when changing checksums online <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%…> The discussion concerns a patch to allow spread checkpoints during online checksum changes. Fujii Masao questioned whether reading `DataChecksumState->fast_checkpoint` without hol… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%…> Introduce XID age based replication slot invalidation <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based…> The discussion concerns a patch to invalidate replication slots based on XID age. The key design decision is how to handle slots held by active walsenders. Masahiko Sawada and Bha… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based…> SQL/JSON json_table plan clause <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…> The discussion focuses on a multi-patch series fixing bugs in the SQL/JSON `JSON_TABLE` plan clause implementation. Thom Brown tested patches 0001–0003: 0001 fixes `ERROR ON EMPTY… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…> Batching in executor <https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor> Denis Smirnov posted a WIP patch as a heap-only experiment related to the broader "Batching in executor" discussion. The patch modifies heap_getnextslot() to reuse visible tuple o… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor> support create index on virtual generated column. <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….> A patch to support creating indexes on virtual generated columns is under development (now at V6). ZizhuanLiu reports that CFBot test results reveal a truncation issue in the gene… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-12-postgresql-daily-news-205.…> Industry News [image: Apple Sues OpenAI Over Alleged Trade Secret Theft] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Apple Sues OpenAI Over Alleged Trade Secret Theft <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Apple has filed a lawsuit against OpenAI, alleging the theft of trade secrets. According to Apple, the misconduct was directed by OpenAI's senior leadership, including a longtime… [image: Meta Removes Controversial AI Feature on Instagram After User Backlash] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Meta Removes Controversial AI Feature on Instagram After User Backlash <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta has pulled a controversial AI feature from Instagram following significant user backlash. The company stated in a blog post that the feature was intended as a useful creative… Social Media Updates linkedin CYBERTEC CEO Hans-Juergen Schoenig on why self-healing, always-on infrastructure matters when the data actually matters, and why open source gives you options a vendor never will. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC CEO Hans-Juergen Schoenig discusses the importance of self-healing, always-on infrastructure for organizations where data reliability is critical. He argues that when dat… linkedin Pavlo Golub of Cybertec shares his talk "pgcov: Bringing Real Test Coverage to PostgreSQL Code" at POSETTE: An Event for Postgres 2026. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> At POSETTE 2026, Pavlo Golub from Cybertec presented pgcov, a tool aimed at filling a gap in the PostgreSQL ecosystem. While developers rely heavily on PostgreSQL functions, proce… linkedin Thanks to everyone who stopped by and interacted with us at GITEX AI EUROPE 2026. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The author expresses gratitude to all attendees who visited and engaged with them at GITEX AI EUROPE 2026, reflecting briefly on the event as an incredible experience. No further… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

July 12, 2026