PGNexus Daily News #206 2026-07-13
by pgnexus
PGNexus Daily News
PostgreSQL Technical Articles
[image: Rebuild large indexes on Aurora PostgreSQL with Blue/Green
Deployments]
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…>
Santosh Mishra
Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…>
Large index rebuilds on Amazon Aurora PostgreSQL can fail due to
insufficient temporary storage, since PostgreSQL spills sort data to disk
during REINDEX. This post describes comb…
Read the Blog
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fda…>
[image: Introducing @neon/sdk, our new TypeScript client for the Neon API]
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-sdk>
Andre Landgraf
Introducing @neon/sdk, our new TypeScript client for the Neon API
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-sdk>
Neon has released @neon/sdk, a TypeScript client library for the Neon API.
While the existing Neon API is OpenAPI-compliant and supports programmatic
management of database infras…
Read the Blog
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-sdk>
PostgreSQL Hackers Email Discussion Highlights
Row pattern recognition
<https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition>
Henson Choi posted a detailed review of the row pattern recognition (RPR)
navigation offset consolidation patches (v51). While v51-0001 fixes the
forward reach regression for FIRS…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=Row%20pattern%20recognition>
hashjoins vs. Bloom filters (yet again)
<https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…>
The discussion focuses on integrating Bloom filter (and more general
runtime filter) pushdown into PostgreSQL's query planner. Matheus Alcantara
posted a v5 PoC patch refining can…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=hashjoins%20vs.%20Bloom%20fil…>
incremental backup issue
<https://pgnexus.ai/hacker-discussions?subject=incremental%20backup%20issue>
The thread discusses a bug in PostgreSQL 17.7's walsummarizer process on
standbys, where it repeatedly logs "invalid record length ... got 0" every
10 seconds and never advances.…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=incremental%20backup%20issue>
Grab bag of smaller OpenSSL fixups
<https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20O…>
Daniel Gustafsson submitted four small OpenSSL cleanup patches: removing a
static variable that could interfere with future multithreading, replacing
the deprecated `SSLv23_method…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=Grab%20bag%20of%20smaller%20O…>
PSQL - prevent describe listing tables that are already in listed schemas
<https://pgnexus.ai/hacker-discussions?subject=PSQL%20-%20prevent%20describe…>
A patch to prevent psql's describe commands from listing tables that are
already covered by listed schemas has been committed. Amit Kapila had
previously reviewed and approved the…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=PSQL%20-%20prevent%20describe…>
Vacuum statistics
<https://pgnexus.ai/hacker-discussions?subject=Vacuum%20statistics>
Alena Rybakina posted a rebased v40 patch series adding vacuum statistics
to PostgreSQL, organized so each commit introduces one category of stats.
Bharath Rupireddy reviewed the…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=Vacuum%20statistics>
Click here for the full Hacker discussion highlights
<https://pgnexus.ai/daily-updates?file=2026-07-13-postgresql-daily-news-206.…>
Industry News
[image: Apple's Trade Secrets Lawsuit Against OpenAI: The Wildest
Allegations]
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
techcrunch.com
Apple's Trade Secrets Lawsuit Against OpenAI: The Wildest Allegations
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
Apple's trade secrets lawsuit against OpenAI contains a series of striking
allegations, including claims that employees joked about unauthorized
access to Apple's systems and that…
[image: Anthropic Launches Localized Claude Pricing for India]
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
techcrunch.com
Anthropic Launches Localized Claude Pricing for India
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
Anthropic has begun localizing pricing for its Claude AI assistant in
India, which is described as the company's biggest market outside the
United States. Users in India are start…
[image: Satya Nadella Issues Warning to Companies Over Reliance on
Proprietary AI Models]
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
techcrunch.com
Satya Nadella Issues Warning to Companies Over Reliance on Proprietary AI
Models
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
Microsoft CEO Satya Nadella has issued a warning to companies using AI,
addressing concerns that large AI labs selling proprietary models could be
acting as "Trojan horses" for th…
Social Media Updates
[image: A recap of our PostgresEDI July meetup: Pat Wright on speaking and
community involvement for the introvert, and Otun Martins on traceable,
SQL-first retrieval for compliance-critical AI systems Blog post in
comments below 👇 #PostgreSQL #Postgres #Edinburgh #OpenSource #TechMeetups
#Database]
<https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…>
linkedin
A recap of our PostgresEDI July meetup: Pat Wright on speaking and
community involvement for the introvert, and Otun Martins on traceable,
SQL-first retrieval for compliance-critical AI systems Blog post in
comments below 👇 #PostgreSQL #Postgres #Edinburgh #OpenSource #TechMeetups
#Database
<https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…>
The PostgresEDI July meetup featured two talks. Pat Wright addressed how
introverted individuals can engage in public speaking and community
participation within the tech space. O…
linkedin
Enterprise security, compliance, and performance, built directly into
PostgreSQL.
<https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…>
CYBERTEC PGEE enhances PostgreSQL with enterprise-grade capabilities built
natively into the database, rather than added as external layers. Key
features include Transparent Data…
linkedin
How do you diagnose whether a Postgres bottleneck is CPU, I/O, or network?
<https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…>
At POSETTE 2026, Rahila Syed demonstrated how to iteratively profile
PostgreSQL performance using perf and pgbench, showing how bottlenecks
shift as optimizations are applied. Usi…
Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus <https://pgnexus.ai> to learn more
July 13, 2026
PGNexus Daily News #205 2026-07-12
by pgnexus
PGNexus Daily News
PostgreSQL Technical Articles
[image: powa-archivist 5.2.0 is out!]
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…>
www.postgresql.org
powa-archivist 5.2.0 is out!
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…>
powa-archivist 5.2.0 has been released by the PoWA team. This version adds
support for PostgreSQL 19, including the new statistical views
pg_stat_recovery and pg_stat_lock, contri…
Read the Blog
<https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.org%2Fabout%…>
PostgreSQL Hackers Email Discussion Highlights
Add pg_stat_vfdcache view for VFD cache statistics
<https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view…>
The thread discusses adding a `pg_stat_vfdcache` view to expose VFD
(Virtual File Descriptor) cache statistics for tuning
`max_files_per_process`. Key design questions include whe…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=Add%20pg_stat_vfdcache%20view…>
allow spread checkpoints when changing checksums online
<https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%…>
The discussion concerns a patch to allow spread checkpoints during online
checksum changes. Fujii Masao questioned whether reading
`DataChecksumState->fast_checkpoint` without hol…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=allow%20spread%20checkpoints%…>
Introduce XID age based replication slot invalidation
<https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based…>
The discussion concerns a patch to invalidate replication slots based on
XID age. The key design decision is how to handle slots held by active
walsenders. Masahiko Sawada and Bha…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=Introduce%20XID%20age%20based…>
SQL/JSON json_table plan clause
<https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…>
The discussion focuses on a multi-patch series fixing bugs in the SQL/JSON
`JSON_TABLE` plan clause implementation. Thom Brown tested patches
0001–0003: 0001 fixes `ERROR ON EMPTY…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=SQL%2FJSON%20json_table%20pla…>
Batching in executor
<https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor>
Denis Smirnov posted a WIP patch as a heap-only experiment related to the
broader "Batching in executor" discussion. The patch modifies
heap_getnextslot() to reuse visible tuple o…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=Batching%20in%20executor>
support create index on virtual generated column.
<https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….>
A patch to support creating indexes on virtual generated columns is under
development (now at V6). ZizhuanLiu reports that CFBot test results reveal
a truncation issue in the gene…
Read Discussion
<https://pgnexus.ai/hacker-discussions?subject=support%20create%20index%20on….>
Click here for the full Hacker discussion highlights
<https://pgnexus.ai/daily-updates?file=2026-07-12-postgresql-daily-news-205.…>
Industry News
[image: Apple Sues OpenAI Over Alleged Trade Secret Theft]
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
techcrunch.com
Apple Sues OpenAI Over Alleged Trade Secret Theft
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
Apple has filed a lawsuit against OpenAI, alleging the theft of trade
secrets. According to Apple, the misconduct was directed by OpenAI's senior
leadership, including a longtime…
[image: Meta Removes Controversial AI Feature on Instagram After User
Backlash]
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
techcrunch.com
Meta Removes Controversial AI Feature on Instagram After User Backlash
<https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2…>
Meta has pulled a controversial AI feature from Instagram following
significant user backlash. The company stated in a blog post that the
feature was intended as a useful creative…
Social Media Updates
linkedin
CYBERTEC CEO Hans-Juergen Schoenig on why self-healing, always-on
infrastructure matters when the data actually matters, and why open source
gives you options a vendor never will.
<https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…>
CYBERTEC CEO Hans-Juergen Schoenig discusses the importance of
self-healing, always-on infrastructure for organizations where data
reliability is critical. He argues that when dat…
linkedin
Pavlo Golub of Cybertec shares his talk "pgcov: Bringing Real Test Coverage
to PostgreSQL Code" at POSETTE: An Event for Postgres 2026.
<https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…>
At POSETTE 2026, Pavlo Golub from Cybertec presented pgcov, a tool aimed at
filling a gap in the PostgreSQL ecosystem. While developers rely heavily on
PostgreSQL functions, proce…
linkedin
Thanks to everyone who stopped by and interacted with us at GITEX AI EUROPE
2026.
<https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%…>
The author expresses gratitude to all attendees who visited and engaged
with them at GITEX AI EUROPE 2026, reflecting briefly on the event as an
incredible experience. No further…
Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus <https://pgnexus.ai> to learn more
July 12, 2026
PGNexus Daily News #204 2026-07-11
by pgnexus
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
July 11, 2026
PGNexus Daily News #203 2026-07-10
by pgnexus
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
July 10, 2026
PGNexus Daily News #202 2026-07-09
by pgnexus
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
July 9, 2026
PGNexus Daily News #201 2026-07-08
by pgnexus
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
July 8, 2026
PGNexus Daily News #200 2026-07-07
by pgnexus
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
July 7, 2026
PGNexus Daily News #199 2026-07-06
by pgnexus
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
July 6, 2026
PGNexus Daily News #198 2026-07-05
by pgnexus
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
July 5, 2026
PGNexus Daily News #197 2026-07-04
by pgnexus
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
July 4, 2026