- Pgtechdailyen - lists.ivorysql.org

PGNexus Daily News #206 2026-07-13
by pgnexus July 13, 2026

July 13, 2026

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

1 0

PGNexus Daily News #205 2026-07-12
by pgnexus July 12, 2026

July 12, 2026

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

1 0

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