July 2026 - Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #204 2026-07-11
by pgnexus July 11, 2026

July 11, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights Key joins <https://pgnexus.ai/hacker-discussions?subject=Key%20joins> Joel Jacobson reviewed Arne Roland's revised patch series for the "Key joins" feature, which breaks the implementation into ten smaller, more focused commits. The series covers: p… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Key%20joins> allow spread checkpoints when changing checksums online <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%…> The discussion centers on a patch (v4) by Tomas Vondra that allows spread checkpoints when enabling or disabling data checksums online. Ewan Young caught a documentation bug where… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan has prepared V30 of the index prefetching patch series, targeting a push of patch 0001 within 7–10 days. Tomas Vondra reviewed 0001 and raised several points: a mi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server <https://pgnexus.ai/hacker-discussions?subject=Bug%20in%20ALTER%20SUBSCRIPTI…> The discussion concerns a bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION when the old server is unreachable. Amit Kapila suggested using the (connect = false) option to ind… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Bug%20in%20ALTER%20SUBSCRIPTI…> support create index on virtual generated column. <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….> The patch (V5) to support creating indexes on virtual generated columns received regression test failures reported by CFBot. ZizhuanLiu reverted earlier modifications to `btcostes… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….> relfilenode statistics <https://pgnexus.ai/hacker-discussions?subject=relfilenode%20statistics> Michael Paquier is working on a redesign of relfilenode statistics, focusing on cleaning up relation stats data for indexes, where many fields stored in memory and written to disk… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=relfilenode%20statistics> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-11-postgresql-daily-news-204.…> Social Media Updates linkedin As AI teams adopt more autonomous agents, one challenge becomes clear: they don't naturally work together. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> As AI teams deploy more autonomous agents, a core challenge emerges: these agents do not naturally collaborate. Omnigent is an open-source meta-harness that operates above individ… [image: CEO CYBERTEC Hans-Juergen Schoenig 's new blog walks through the full journey...] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin CEO CYBERTEC Hans-Juergen Schoenig 's new blog walks through the full journey... <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC CEO Hans-Juergen Schoenig published a new blog post tracing the complete data path in PostgreSQL, from storage through the pg_hardstorage repository and back during recov… [image: CYBERTEC is hiring a Lead Infrastructure Support Engineer in India.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin CYBERTEC is hiring a Lead Infrastructure Support Engineer in India. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC is seeking a Lead Infrastructure Support Engineer based in India. The role involves leading a team responsible for maintaining enterprise PostgreSQL infrastructure, with… 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 #203 2026-07-10
by pgnexus July 10, 2026

July 10, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: High Availability for EDB Postgres Advanced Server Using EFM and PgPool: A Complete Setup Guide] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fh…> enterprisedb.com High Availability for EDB Postgres Advanced Server Using EFM and PgPool: A Complete Setup Guide <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fh…> This guide describes a two-layer high availability architecture for EDB Postgres Advanced Server (EPAS) using EDB Failover Manager (EFM) and PgPool-II. EFM monitors the primary-st… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fh…> PostgreSQL Hackers Email Discussion Highlights Proposal: new file format for hba/ident/hosts configuration? <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20fo…> The thread discusses a proposal to introduce a new file format for PostgreSQL's hba/ident/hosts configuration files. Zsolt Parragi shares JSON5 versions of previous TOML mockups a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20fo…> Missing FSM Update when Updating VM On-access <https://pgnexus.ai/hacker-discussions?subject=Missing%20FSM%20Update%20when…> The discussion addresses a bug where the Free Space Map (FSM) is not updated when the Visibility Map (VM) is set on-access during heap page pruning, potentially causing VACUUM to… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Missing%20FSM%20Update%20when…> REASSIGN OWNED vs. relisshared dep on !relisshared <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> Recent commits added fields `pg_subscription.subserver` and `pg_subscription.subconflictlogrelid`, each creating a dependency link from the shared catalog `pg_subscription` to a n… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REASSIGN%20OWNED%20vs.%20reli…> Show expression of virtual columns in error messages <https://pgnexus.ai/hacker-discussions?subject=Show%20expression%20of%20virt…> A patch to display virtual column expressions in PostgreSQL error messages is under development. Matheus Alcantara has submitted v6, rebased against master due to changes introduc… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Show%20expression%20of%20virt…> s/pg_attribute_always_inline/pg_always_inline/? <https://pgnexus.ai/hacker-discussions?subject=s%2Fpg_attribute_always_inlin…> The discussion focuses on renaming the macro `pg_attribute_always_inline` to `pg_always_inline` in PostgreSQL's codebase and how to handle backpatching. The agreed approach is to… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=s%2Fpg_attribute_always_inlin…> implement CAST(expr AS type FORMAT 'template') <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%20…'template')> The discussion concerns implementing SQL standard T839: `CAST(expr AS type FORMAT 'template')`. Haibo Yan previously proposed a generic format-cast mechanism covering datetime, nu… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%20…'template')> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-10-postgresql-daily-news-203.…> 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 trade secret theft directed by OpenAI's senior leadership, including a long-time former Apple employee. The lawsuit marks a sign… techcrunch.com OpenAI GPT-5.6 Named Preferred Model for Microsoft Copilot 365 <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> OpenAI has announced that its GPT-5.6 model is the preferred choice to power Microsoft's Copilot 365 suite of workplace and productivity applications. The announcement comes amid… Social Media Updates linkedin CYBERTEC CEO Hans-Juergen Schoenig on why open source gives you something proprietary vendors can't: a chance. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC CEO Hans-Juergen Schoenig argues that open source software offers users something proprietary vendors fundamentally cannot: a genuine opportunity. Speaking in the context… linkedin "Every stateful system has got to have the ability to create a staging environment, branch what you have, and give agents permission to make mistakes." Databricks' VP Nikita Shamgunov joins 𝘐𝘵'𝘴 𝘈𝘣𝘰𝘶𝘵 𝘋𝘢𝘵𝘢 to discuss why branching and version control are becoming foundational for AI-native software development, how teams can manage schema drift as AI accelerates development, and the architectural ideas behind Lakebase. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks VP Nikita Shamgunov appeared on the podcast 'It's About Data' to discuss the growing importance of branching and version control in AI-native software development. He a… linkedin Genie One is the data-smart AI coworker that helps business users move from insight to action. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Genie One is an AI assistant designed to help business users act on data insights. Its Genie Agents feature allows teams to convert prompts into shareable, autonomous agents capab… 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 #202 2026-07-09
by pgnexus July 9, 2026

July 9, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Introducing the New Neon API Command] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fintroduci…> Anthony Giuliano Introducing the New Neon API Command <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fintroduci…> The Neon CLI has added a new `neon api` command designed to address two problems: the CLI's human-oriented design often lags behind the full capabilities of the underlying API, an… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fintroduci…> [image: EDB heads to PGConf.Brasil 2026, this is what we’ll be talking about!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> enterprisedb.com EDB heads to PGConf.Brasil 2026, this is what we’ll be talking about! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> EDB will participate in PGConf.Brasil 2026, held in Blumenau from September 2–4. The company will deliver 13 sessions at the conference. No further technical details about session… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fe…> [image: Why enterprises outgrow relational databases] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Timothy Steward Why enterprises outgrow relational databases <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Enterprises are not abandoning relational databases, but many are questioning whether their current database platforms can handle modern demands. Key pressures include faster inno… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL Hackers Email Discussion Highlights Proposal: new file format for hba/ident/hosts configuration? <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20fo…> The thread discusses a proposal by Zsolt Parragi to replace PostgreSQL's pg_hba.conf, pg_ident.conf, and related files with a new structured format. TOML and JSON5 are the main ca… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Proposal%3A%20new%20file%20fo…> pg_dump: use threads for parallel workers on all platforms <https://pgnexus.ai/hacker-discussions?subject=pg_dump%3A%20use%20threads%20…> Bryan Green has reworked a patch series to replace pg_dump's parallel worker model with a unified thread-based approach across all platforms. Patches 0001–0002 are Windows-only st… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_dump%3A%20use%20threads%20…> Introduce XID age based replication slot invalidation <https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based…> The discussion focuses on how autovacuum should handle XID-age-based replication slot invalidation when a slot is still held by an active process. Three approaches were considered… 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…> Thom Brown tested the recently committed SQL/JSON `JSON_TABLE` PLAN clause patch and identified several bugs. First, a missing catalog version bump was noted since new fields were… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…> pg_buffercache: Add per-relation summary stats <https://pgnexus.ai/hacker-discussions?subject=pg_buffercache%3A%20Add%20per…> The discussion concerns adding a `pg_buffercache_relations()` function to the `pg_buffercache` extension for per-relation buffer cache aggregation. Khoa Nguyen reported a ~25x spe… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_buffercache%3A%20Add%20per…> Handle concurrent drop when doing whole database vacuum <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> The discussion centers on a patch (v8) to handle concurrent table drops during a whole-database VACUUM. The key issue is preventing unprivileged users from acquiring strong locks… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Handle%20concurrent%20drop%20…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-09-postgresql-daily-news-202.…> Industry News [image: Ollama Raises $65M, Grows to Nearly 9 Million Users] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Ollama Raises $65M, Grows to Nearly 9 Million Users <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Ollama, a popular open-source AI developer tool backed by Benchmark, has raised $65 million in funding. The platform, which helps developers easily run AI models on their personal… [image: New York Times Accuses OpenAI of Hiding Evidence in ChatGPT Copyright Trial] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com New York Times Accuses OpenAI of Hiding Evidence in ChatGPT Copyright Trial <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> The New York Times and other news publishers have escalated their copyright lawsuit against OpenAI, alleging the company concealed tools and datasets that could identify copyright… [image: Meta Enters AI Coding Market with Muse Spark 1.1] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Meta Enters AI Coding Market with Muse Spark 1.1 <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta has launched Muse Spark 1.1, its entry into the competitive AI coding assistant market. The tool is designed to handle large agentic workloads, fix bugs, and assist with larg… Social Media Updates [image: Most enterprise compliance platforms were built for a world that no longer exists.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Most enterprise compliance platforms were built for a world that no longer exists. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC's Scalefield Secure is positioned as a modern alternative to legacy enterprise compliance platforms that rely on per-core licensing, lengthy rollouts, and proprietary dat… linkedin Premier Inc. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Premier Inc., which serves two out of every three U.S. healthcare providers, migrated to Databricks SQL to modernize its fragmented healthcare data ecosystem. By consolidating dat… linkedin "The attackers are now hyper-automated with agents and large language models that can find vulnerabilities that haven't yet been found by the people who wrote the software." Databricks' Andrew K. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks' Andrew K. and NAB's Patrick Wright spoke with SiliconANGLE and theCUBE about cybersecurity in the AI era. They noted that attackers now use AI agents and large languag… 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 #201 2026-07-08
by pgnexus July 8, 2026

July 8, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Barman 3.19.0 and 3.19.1 Released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org Barman 3.19.0 and 3.19.1 Released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> Barman 3.19.0 and 3.19.1 were released on May 20 and May 26, 2026, respectively. Barman is an open-source PostgreSQL backup and recovery management tool maintained by EnterpriseDB… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: pglayers: PostgreSQL extensions as stackable Docker layers] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pglayers: PostgreSQL extensions as stackable Docker layers <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pglayers is a new open-source project that publishes 53 PostgreSQL extensions as minimal, composable Docker image layers built FROM scratch. Users can stack extensions onto the of… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: PDU: an open source PostgreSQL Data Unloader for full-database offline export and targeted WAL recovery] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PDU: an open source PostgreSQL Data Unloader for full-database offline export and targeted WAL recovery <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PDU (PostgreSQL Data Unloader) is an open source emergency recovery tool for offline PostgreSQL instances. When a database cannot start, PDU reads data files and WAL archives dire… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: Autobase 2.9.0 released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org Autobase 2.9.0 released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> Autobase 2.9.0 has been released, focusing on simplifying PostgreSQL infrastructure management post-deployment. Key additions include per-user authentication with email and passwo… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: PostgreSQL ODBC Version REL-18_00_0002 Released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PostgreSQL ODBC Version REL-18_00_0002 Released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL ODBC driver version REL-18_00_0002 has been released with multiple bug fixes and security improvements. Key changes include upgrading to OpenSSL 3.5.5, fixing a stack b… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: The Data Layer for the AI Data Center] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Hien Phan The Data Layer for the AI Data Center <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> TimescaleDB is proposed as the time-series data layer for AI data centers, where GPU workloads and physical plant systems—cooling, power, UPS, BMS—must be correlated across vastly… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights BF mamba failure <https://pgnexus.ai/hacker-discussions?subject=BF%20mamba%20failure> A user reports repeated FATAL crashes on PostgreSQL 17.6 with the error "trying to drop stats entry already dropped: kind=relation." Bertrand Drouvot reproduced the issue by simul… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=BF%20mamba%20failure> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Tomas Vondra reviewed patch 0001 of Peter Geoghegan's index prefetching series (currently at V29). He finds the slot-related API improvements generally sensible and well-structure… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> bump minimum supported version of psql and pg_{dump,dumpall,upgrade} to v10 <https://pgnexus.ai/hacker-discussions?subject=bump%20minimum%20supported%20…> Nathan Bossart noticed he had forgotten to update AdjustUpgrade.pm as part of a broader effort to bump the minimum supported version of psql and pg_dump, pg_dumpall, and pg_upgrad… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=bump%20minimum%20supported%20…> s/pg_attribute_always_inline/pg_always_inline/? <https://pgnexus.ai/hacker-discussions?subject=s%2Fpg_attribute_always_inlin…> The thread discusses renaming the PostgreSQL macro `pg_attribute_always_inline` to the shorter `pg_always_inline`. Peter Geoghegan notes there are only 17 usages in the master bra… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=s%2Fpg_attribute_always_inlin…> Remove the refint contrib module (for v20) <https://pgnexus.ai/hacker-discussions?subject=Remove%20the%20refint%20contr…> The thread discusses removing the `refint` contrib module from PostgreSQL for version 20. The final message from Nathan Bossart confirms the change has been committed. The `refint… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Remove%20the%20refint%20contr…> Add bms_offset_members() function for bitshifting Bitmapsets <https://pgnexus.ai/hacker-discussions?subject=Add%20bms_offset_members()%20…> The thread discusses the addition of a new `bms_offset_members()` function for bit-shifting Bitmapsets in PostgreSQL. David Rowley made minor comment adjustments and reduced itera… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20bms_offset_members()%20…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-08-postgresql-daily-news-201.…> Industry News [image: OpenAI Releases New Voice Models Supporting Simultaneous Speech and Listening] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com OpenAI Releases New Voice Models Supporting Simultaneous Speech and Listening <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> OpenAI has unveiled new voice models designed to enable more natural live conversations. A key capability of the new voice mode is the ability to speak and listen simultaneously,… [image: SpaceXAI Releases Grok 4.5, Described as an 'Opus-class Model'] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com SpaceXAI Releases Grok 4.5, Described as an 'Opus-class Model' <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> SpaceXAI has released Grok 4.5, the latest version of its AI model, with Elon Musk describing it as an "Opus-class model." The company is positioning Grok 4.5 as a cheaper and mor… [image: Massive Data Breach Exposes Millions of Driver's License Numbers at U.S. Insurance Giant] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Massive Data Breach Exposes Millions of Driver's License Numbers at U.S. Insurance Giant <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> A major cyberattack targeting a U.S. insurance company has resulted in what is described as the largest known breach of driver's license numbers in 2026 so far. Millions of indivi… Social Media Updates [image: Agent Bricks has expanded into a comprehensive agent platform for developers.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Agent Bricks has expanded into a comprehensive agent platform for developers. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Agent Bricks has evolved into a comprehensive platform aimed at developers building production AI agents. The update addresses three key challenges: choice, context, and control.… linkedin Meet Genie, your data-smart AI coworker. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Genie is an AI assistant designed to work within the context of a specific business, unlike generic AI tools that lack organizational knowledge. By grounding its responses in busi… linkedin Postgres is no longer just a transactional workhorse, instead, it's turning into the everything database. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> PostgreSQL has grown beyond its traditional role as a transactional database, now ranking as the most used and most loved database according to the 2025 Stack Overflow Developer 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 #200 2026-07-07
by pgnexus July 7, 2026

July 7, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Logical replication improvements in Amazon RDS for PostgreSQL 18] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Ramdas Gutlapalli Logical replication improvements in Amazon RDS for PostgreSQL 18 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> PostgreSQL 18 introduces four targeted improvements to logical replication. First, STORED generated columns can now be included in the replication stream via a new `publish_genera… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Automate PostgreSQL audit log extraction and analysis with Amazon S3] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> Bhavini Bhatia Automate PostgreSQL audit log extraction and analysis with Amazon S3 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> This AWS blog post describes an automated pipeline for extracting and analyzing PostgreSQL audit logs from Amazon RDS or Aurora PostgreSQL. Using the pgAudit extension, audit logs… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…> [image: Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Wellingtone Luvonga Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> This article demonstrates how to configure CloudNativePG (CNPG) distributed topology across multiple Kubernetes clusters for PostgreSQL disaster recovery. The setup uses MinIO as… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: By the Time Your Data Warehouse Answers, the Opportunity Is Gone] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Ft…> enterprisedb.com By the Time Your Data Warehouse Answers, the Opportunity Is Gone <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Ft…> Data warehouses with slow query response times can cause missed business opportunities. EDB positions its EDB Postgres AI platform as an alternative for organizations facing chall… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Ft…> [image: Building a Sovereign, Intelligent Data Foundation with EDB Postgres® AI on IBM LinuxONE 5] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fb…> enterprisedb.com Building a Sovereign, Intelligent Data Foundation with EDB Postgres® AI on IBM LinuxONE 5 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fb…> EDB and IBM have partnered to deliver a sovereign AI data platform combining EDB Postgres AI with IBM LinuxONE 5. The integration targets enterprises requiring strict data soverei… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fenterprisedb.com%2Fblog%2Fb…> [image: 5 PostgreSQL performance bottlenecks every DBA should know in 2026] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Rajni Baliyan 5 PostgreSQL performance bottlenecks every DBA should know in 2026 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL deployments can encounter performance degradation as workloads scale. This article identifies five common bottlenecks DBAs should address: inefficient query plans cause… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> PostgreSQL Hackers Email Discussion Highlights Add malloc attribute to memory allocation functions <https://pgnexus.ai/hacker-discussions?subject=Add%20malloc%20attribute%20to…> The thread discusses a patch by Tristan Partin to add the GCC `malloc` attribute to PostgreSQL's memory allocation functions, aiming to prevent regressions against `-Werror=mismat… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20malloc%20attribute%20to…> Fix gistkillitems & add regression test to microvacuum <https://pgnexus.ai/hacker-discussions?subject=Fix%20gistkillitems%20%26%20a…> A bug fix for `gistkillitems()` in GiST index scans was committed. The issue involved the root page not being handled consistently with other leaf pages during microvacuum trigger… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20gistkillitems%20%26%20a…> Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment <https://pgnexus.ai/hacker-discussions?subject=Bug%3A%20mdunlinkfiletag%20un…> A bug was reported where `mdunlinkfiletag` incorrectly unlinked the main fork segment 0 instead of the specified fork and segment. Thomas Munro suggested going in the opposite dir… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Bug%3A%20mdunlinkfiletag%20un…> index prefetching <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> Peter Geoghegan posted V29 of the index prefetching patch, noting V28 no longer applies cleanly. Key changes include two microoptimizations: index AMs can now set knownEndBackward… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=index%20prefetching> WAL compression setting after PostgreSQL LZ4 default change <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> The discussion centers on whether the `wal_compression = on` setting should map to a better algorithm (lz4 or zstd) instead of pglz, following PostgreSQL's recent change making lz… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=WAL%20compression%20setting%2…> Global temporary tables <https://pgnexus.ai/hacker-discussions?subject=Global%20temporary%20tables> The discussion focuses on the Global Temporary Tables (GTT) patch. Japin Li observed that sequences attached to GTTs with ON COMMIT DELETE ROWS are not reset after commit; Dean Ra… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Global%20temporary%20tables> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-07-postgresql-daily-news-200.…> Industry News [image: Figma acquires team behind a vibe-coding app] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Figma acquires team behind a vibe-coding app <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Figma has acquired the team behind a vibe-coding application that was backed by Y Combinator. The company originally launched a vibe-coding platform before pivoting to build an ag… [image: Claude Cowork expands to mobile and web] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Claude Cowork expands to mobile and web <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic's Claude Cowork has expanded to mobile and web platforms, enabling users to manage long-running AI tasks across devices. With this update, a user can start a task on the… [image: Microsoft joins AI cost-cutting trend by relying more on its own models] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Microsoft joins AI cost-cutting trend by relying more on its own models <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Microsoft is the latest major Silicon Valley company to cut back on AI spending by shifting toward greater reliance on its own internally developed AI models. This move reflects a… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0

PGNexus Daily News #199 2026-07-06
by pgnexus July 6, 2026

July 6, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: pg_ivm 1.15 released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg_ivm 1.15 released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg_ivm 1.15 has been released by IVM Development Group. The key new feature adds IMMV metadata restore support for pg_dump and pg_upgrade: after a restore or upgrade, IMMVs no lon… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: Why pg_hardstorage has no incremental chain] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> Hans-Jürgen Schönig Why pg_hardstorage has no incremental chain <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> pg_hardstorage, a PostgreSQL backup tool, deliberately omits incremental chaining. Traditional chained incrementals (as used by pgBackRest and Barman) create fragile dependency se… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.cybertec-postgresql.com…> [image: PostgreSQL JDBC 42.7.12 Security Release] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org PostgreSQL JDBC 42.7.12 Security Release <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL JDBC 42.7.12 fixes CVE-2026-54291, a security vulnerability affecting versions 42.7.4 through 42.7.11. When `channelBinding=require` is set, connections could silently… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: CloudNativePG 1.30.0 Released!] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org CloudNativePG 1.30.0 Released! <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> CloudNativePG 1.30.0 has been released, introducing a new DatabaseRole CRD for declarative, GitOps-compatible PostgreSQL role management and a Lease-based primary election mechani… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: All 44 talks from POSETTE: An Event for Postgres 2026 are available on YouTube] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org All 44 talks from POSETTE: An Event for Postgres 2026 are available on YouTube <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> All 44 sessions from POSETTE: An Event for Postgres 2026, held June 16–18 as a free virtual event organized by Microsoft and AMD, are now available on YouTube. The playlist includ… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights Support EXCEPT for TABLES IN SCHEMA publications <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> The thread discusses a patch adding EXCEPT clause support for TABLES IN SCHEMA publications. Shveta reviewed earlier feedback from Nisha: error messages for ADD TABLE and DROP TAB… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Support%20EXCEPT%20for%20TABL…> Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> The thread discusses adding a `pg_stat_kind_info` system view to PostgreSQL. Michael Paquier committed an initial version (3b066de6c0a1) without the entry sizing parts, following… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> Don't use the deprecated and insecure PQcancel in our frontend tools anymore <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> The discussion focuses on replacing the deprecated and insecure `PQcancel` API in PostgreSQL's frontend tools with a safer alternative. Heikki Linnakangas extracted a comment upda… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> Global temporary tables <https://pgnexus.ai/hacker-discussions?subject=Global%20temporary%20tables> The discussion centers on a patch implementing global temporary tables (GTTs) in PostgreSQL. Japin Li reported a lock wait issue in v5, which was fixed in v6, but also found that… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Global%20temporary%20tables> Make \d tablename fast again, regression introduced by 85b7efa1cdd <https://pgnexus.ai/hacker-discussions?subject=Make%20%5Cd%20tablename%20fas…> The thread discusses a fix for a performance regression in `\d tablename` introduced by commit 85b7efa1cdd. Jelte Fennema-Nio submitted v3 of the patch, addressing Tom Lane's ques… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Make%20%5Cd%20tablename%20fas…> Collation & ctype method table, and extension hooks <https://pgnexus.ai/hacker-discussions?subject=Collation%20%26%20ctype%20met…> Jeff Davis responded to a bug report from Noah Misch regarding a behavioral regression introduced by refactor commit 5a38104. In a UTF8 database, `SELECT 'café' ILIKE 'caf_' COLLA… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Collation%20%26%20ctype%20met…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-06-postgresql-daily-news-199.…> Industry News [image: Microsoft Lays Off Nearly 5,000 Employees Across Xbox and Commercial Sales] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Microsoft Lays Off Nearly 5,000 Employees Across Xbox and Commercial Sales <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Microsoft announced the elimination of approximately 4,800 roles — about 2.1% of its global workforce — in the latest round of layoffs at the company. The cuts hit Xbox and commer… [image: Every Major Tech Layoff in 2026 That Has Named AI as a Factor] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Every Major Tech Layoff in 2026 That Has Named AI as a Factor <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> TechCrunch has published a running tracker of major tech layoffs in 2026 in which companies explicitly cited AI as a stated reason for workforce reductions. Listed in reverse chro… [image: Smart Glasses Maker Even Realities Hits $1B Valuation with $150M Funding Led by Meituan and Tencent] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Smart Glasses Maker Even Realities Hits $1B Valuation with $150M Funding Led by Meituan and Tencent <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Even Realities, a smart glasses startup founded by former Apple engineers, has raised $150 million in a funding round led by Meituan and Tencent, pushing its valuation to $1 billi… Social Media Updates linkedin After decades of building databases, Databricks VP of Engineering Nikita Shamgunov believes it's time to rethink one of their fundamental assumptions. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks VP of Engineering Nikita Shamgunov argues that separating compute and storage represents the next major architectural shift for operational databases. Speaking on the I… [image: Data + AI Summit 2026 marked another milestone in the OpenAI and Databricks partnership.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Data + AI Summit 2026 marked another milestone in the OpenAI and Databricks partnership. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Data + AI Summit 2026 highlighted the growing partnership between OpenAI and Databricks. The event featured keynotes, executive discussions, customer stories, a hackathon, and the… linkedin Grateful to Dimitri Bellini at Quadrata for taking pg_hardstorage for a real hands-on run and sharing the experience on camera. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The author expresses gratitude to Dimitri Bellini from Quadrata for conducting a thorough, hands-on test of pg_hardstorage and sharing the experience publicly on camera. The autho… 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 #198 2026-07-05
by pgnexus July 5, 2026

July 5, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: pg-cdc Frustratingly simple Postgres change data capture to AWS S3] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg-cdc Frustratingly simple Postgres change data capture to AWS S3 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg-cdc is an open-source tool that captures PostgreSQL change data by streaming WAL records into Apache Iceberg tables stored on AWS S3. It registers tables in AWS Glue Catalog an… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: pg_dbms_errlog v2.4 released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg_dbms_errlog v2.4 released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg_dbms_errlog versions 2.3 and 2.4 have been released as maintenance updates. These releases add compatibility with PostgreSQL 18 and 19 and fix two major bugs. The extension all… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: credcheck v5.0 has been released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org credcheck v5.0 has been released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> credcheck v5.0 has been released, a major update to the PostgreSQL credential validation extension maintained by HexaCluster. This release adds compatibility with PostgreSQL v19 a… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> [image: pg_dbms_lock v2.0 has been released] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> www.postgresql.org pg_dbms_lock v2.0 has been released <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> pg_dbms_lock v2.0 has been released as a maintenance update. This PostgreSQL extension emulates Oracle's DBMS_LOCK package using PostgreSQL advisory locks, supporting exclusive/sh… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…> PostgreSQL Hackers Email Discussion Highlights PG19 FK fast path: OOB write and missed FK checks during batched <https://pgnexus.ai/hacker-discussions?subject=PG19%20FK%20fast%20path%3A%20…> Noah Misch critiques the recently pushed fix (commit 4113873) for PG19 FK fast-path batching issues. He discourages the chosen strategy of confining batching to the top transactio… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=PG19%20FK%20fast%20path%3A%20…> Fix psql pager selection for wrapped expanded output <https://pgnexus.ai/hacker-discussions?subject=Fix%20psql%20pager%20selectio…> A bug fix for psql's pager selection logic when handling wrapped expanded output was reviewed and committed. Chao Li submitted a v2 patch addressing reviewer feedback. Erik Wienho… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20psql%20pager%20selectio…> support create index on virtual generated column. <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….> ZizhuanLiu (X-MAN) posted an updated patch (V2) supporting CREATE INDEX on virtual generated columns (VGCs). Earlier attempts (V0, V1) were abandoned due to expanding scope and ca… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….> Industry News [image: Alibaba Reportedly Bans Employees from Using Claude Code] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Alibaba Reportedly Bans Employees from Using Claude Code <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Alibaba has reportedly classified Claude Code, Anthropic's AI-powered coding assistant, as high-risk software and banned its employees from using it. The move signals growing tens… [image: Almost 90 New Unicorns Minted in 2026 Amid AI Investor Frenzy] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Almost 90 New Unicorns Minted in 2026 Amid AI Investor Frenzy <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Nearly 90 startups have achieved unicorn status in 2026, driven largely by an AI-fueled investor frenzy. According to TechCrunch, more companies are hitting the $1 billion valuati… Social Media Updates linkedin 25 years. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> CYBERTEC marks 25 years specializing in PostgreSQL, evolving from a database provider to a major contributor to the PostgreSQL project. The company offers large-scale migration wi… linkedin #DataAISummit 2026 may be over, but the keynotes and select breakout sessions are now available on demand! <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> The Data + AI Summit 2026 has concluded, but attendees and those who missed it can still access the event's content. Keynotes and select breakout sessions are now available on dem… linkedin At POSETTE: An Event for Postgres 2026, Jeremy Schneider (GEICO) & Leonardo Cecchi (EDB) explore how quorum consistency applies to Postgres cluster changes in the CloudNativePG operator. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> At POSETTE 2026, Jeremy Schneider from GEICO and Leonardo Cecchi from EDB examined how quorum consistency applies to Postgres cluster management within the CloudNativePG operator.… 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 #197 2026-07-04
by pgnexus July 4, 2026

July 4, 2026

PGNexus Daily News PostgreSQL Hackers Email Discussion Highlights [PATCH] btree_gist: add cross-type integer operator support for GiST <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20btree_gist%3A%2…> The patch adds cross-type integer operator support for GiST in btree_gist. Alexander Nestorov reports that recent upstream commits broke the patchset's CI: specifically, the signa… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20btree_gist%3A%2…> Don't use the deprecated and insecure PQcancel in our frontend tools anymore <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> The discussion continues work on replacing the deprecated and insecure PQcancel API in PostgreSQL frontend tools. Jelte Fennema-Nio's patch 0001 removes the redundant `cancel_pres… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Don't%20use%20the%20deprecated%20and%20insecure%20PQcancel%20in%20our%20frontend%20tools%20anymore> SECURITY LABEL ON PROPERTY GRAPH: supported? <https://pgnexus.ai/hacker-discussions?subject=SECURITY%20LABEL%20ON%20PROPE…> Commit 2f094e7 updated the `security_label.sgml` documentation to indicate that `SECURITY LABEL ON PROPERTY GRAPH` is supported, but attempting the command actually produces an er… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SECURITY%20LABEL%20ON%20PROPE…> SQL/JSON json_table plan clause <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…> The thread discusses ongoing development of the SQL/JSON `json_table` PLAN clause patch. Nikita Malakhov submitted v23 addressing earlier review comments from Alexander Korotkov a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…> Make \d tablename fast again, regression introduced by 85b7efa1cdd <https://pgnexus.ai/hacker-discussions?subject=Make%20%5Cd%20tablename%20fas…> A regression introduced by commit 85b7efa1cdd causes `\d tablename` in psql to perform a sequential scan instead of an index scan, degrading performance. Andres Freund originally… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Make%20%5Cd%20tablename%20fas…> explain plans for foreign servers <https://pgnexus.ai/hacker-discussions?subject=explain%20plans%20for%20forei…> A patch adding EXPLAIN plan support for foreign servers is under review. Dinesh Salve reviewed the latest version submitted by Sami, praising the trimmed-down documentation that a… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=explain%20plans%20for%20forei…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-04-postgresql-daily-news-197.…> Social Media Updates [image: That's a wrap on GITEX AI Europe 2026.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin That's a wrap on GITEX AI Europe 2026. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> GITEX AI Europe 2026 has concluded in Berlin. The event brought numerous conversations around databases, data sovereignty, and the practical foundations of enterprise AI. The team… linkedin Say hello to Omnigent 👋 Databricks' open-source meta-harness helps developers orchestrate AI coding workflows across multiple coding agents, making it easy to use the right model for each task. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Databricks has released Omnigent, an open-source meta-harness designed to help developers orchestrate AI coding workflows across multiple coding agents. The tool enables teams to… [image: We've posted a video of Floor Drees , Hari Kiran , Jimmy Angelakos , Miaolai Z.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin We've posted a video of Floor Drees , Hari Kiran , Jimmy Angelakos , Miaolai Z. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> A video has been posted of a talk titled 'Beyond the source: the human architecture of PostgreSQL,' delivered by Floor Drees, Hari Kiran, Jimmy Angelakos, Miaolai Z., and Valeria… 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 #196 2026-07-03
by pgnexus July 3, 2026

July 3, 2026

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

1 0

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

July 2, 2026

PGNexus Daily News PostgreSQL Technical Articles [image: Lakebase Search: vector and BM25 on Neon] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Flakebase-…> Savannah Longoria Lakebase Search: vector and BM25 on Neon <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Flakebase-…> Neon has released a beta of Lakebase Search, introducing two PostgreSQL extensions—lakebase_vector and lakebase_text—that enable hybrid vector and full-text search. The vector com… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Flakebase-…> [image: 10 enterprise database features that regulated industries should prioritize in 2026] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Timothy Steward 10 enterprise database features that regulated industries should prioritize in 2026 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> Timothy Steward outlines ten PostgreSQL features that regulated industries should prioritize heading into 2026. As data volumes increase and compliance requirements tighten, organ… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com…> [image: AI's Physical Constraints: How AI Rewired the Data Center] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> Hien Phan AI's Physical Constraints: How AI Rewired the Data Center <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> AI infrastructure has hit fundamental physical limits that reshape data center design. Modern AI racks like NVIDIA's GB300 NVL72 draw up to 140 kW, roughly ten times traditional r… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2F…> PostgreSQL Hackers Email Discussion Highlights Add pg_stat_kind_info system view <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> The discussion concerns adding a `pg_stat_kind_info` system view to PostgreSQL. A specific point of contention was whether to include an `entry_size` field to help calculate memor… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_kind_info%20sys…> implement CAST(expr AS type FORMAT 'template') <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%20…'template')> The thread discusses implementing `CAST(expr AS type FORMAT 'template')` in PostgreSQL. Haibo Yan updated the patch to use `CREATE FORMAT CAST` and a separate `pg_format_cast` cat… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=implement%20CAST(expr%20AS%20…'template')> remove VersionedQuery support from psql tab completion <https://pgnexus.ai/hacker-discussions?subject=remove%20VersionedQuery%20sup…> Nathan Bossart proposed removing the `VersionedQuery` infrastructure from psql tab completion, noting it was introduced by commit 722408bcd1 solely for publications and subscripti… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=remove%20VersionedQuery%20sup…> Fix RLS checks for UPDATE/DELETE FOR PORTION OF leftover rows <https://pgnexus.ai/hacker-discussions?subject=Fix%20RLS%20checks%20for%20UP…> The discussion addresses a security gap in temporal table operations: `UPDATE/DELETE FOR PORTION OF` can implicitly insert "leftover" rows to preserve history outside the target r… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Fix%20RLS%20checks%20for%20UP…> Report bytes and transactions actually sent downtream <https://pgnexus.ai/hacker-discussions?subject=Report%20bytes%20and%20transa…> The discussion centers on a patch to report bytes and transactions actually sent downstream via logical replication, tracked through new statistics fields. Masahiko Sawada previou… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Report%20bytes%20and%20transa…> SQL:2011 Application Time Update & Delete <https://pgnexus.ai/hacker-discussions?subject=SQL%3A2011%20Application%20Ti…> Paul A Jungwirth is working on SQL:2011 application-time (temporal) UPDATE FOR PORTION OF support in PostgreSQL. The current patch discussion focuses on whether PostgreSQL should… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=SQL%3A2011%20Application%20Ti…> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-07-02-postgresql-daily-news-195.…> Industry News [image: Microsoft launches its own AI deployment company with $2.5 billion commitment] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Microsoft launches its own AI deployment company with $2.5 billion commitment <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Microsoft has launched a new AI deployment company backed by a $2.5 billion commitment, joining Amazon, OpenAI, and Anthropic in establishing dedicated AI deployment operations. T… [image: Meta quietly launches vibe-coded gaming app Pocket] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Meta quietly launches vibe-coded gaming app Pocket <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Meta has quietly launched Pocket, an experimental AI-powered app that enables users to generate and share interactive mini games using text prompts. The low-key release suggests M… [image: Anthropic is discussing a new custom chip with Samsung] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> techcrunch.com Anthropic is discussing a new custom chip with Samsung <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…> Anthropic is in discussions with Samsung to develop a new custom AI chip, according to reports. The talks come roughly a week after OpenAI announced its own custom AI chip partner… Social Media Updates [image: Too many tables in a single PostgreSQL database can quietly cause memory starvation, OOM crashes, and long-running metadata queries.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> linkedin Too many tables in a single PostgreSQL database can quietly cause memory starvation, OOM crashes, and long-running metadata queries. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Having too many tables in a single PostgreSQL database can lead to serious hidden problems, including memory starvation, out-of-memory crashes, and slow metadata queries. CYBERTEC… linkedin #DataAISummit 2026 was packed with product announcements, hands-on training, and technical insights. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> DataAISummit 2026 featured a range of product announcements, hands-on training sessions, and technical insights. For those who missed the event, keynotes and select breakout sessi… linkedin [DEMO] Agentic coding is moving faster than ever. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…> Agentic coding is accelerating, and databases must keep pace. Lakebase Branching addresses this by creating isolated, ephemeral database environments that allow AI coding agents t… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more

1 0