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%2Fdat...> Ramdas Gutlapalli Logical replication improvements in Amazon RDS for PostgreSQL 18 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> 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%2Fdat...> [image: Automate PostgreSQL audit log extraction and analysis with Amazon S3] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Faws.amazon.com%2Fblogs%2Fdat...> 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%2Fdat...> 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%2Fdat...> [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%2Fti...> 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%2Fti...> 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%2Fti...> [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%2Fbu...> 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%2Fbu...> 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%2Fbu...> [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%20ad...> 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%20ad...> Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment <https://pgnexus.ai/hacker-discussions?subject=Bug%3A%20mdunlinkfiletag%20unl...> 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%20unl...> 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%20...> 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%20...> 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.m...> Industry News [image: Figma acquires team behind a vibe-coding app] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> techcrunch.com Figma acquires team behind a vibe-coding app <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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%2F...> techcrunch.com Claude Cowork expands to mobile and web <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F07%2F...> 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%2F...> 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%2F...> 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