PGNexus Daily News

PostgreSQL Technical Articles

Logical replication improvements in Amazon RDS for PostgreSQL 18

Ramdas Gutlapalli

Logical replication improvements in Amazon RDS for PostgreSQL 18

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
Automate PostgreSQL audit log extraction and analysis with Amazon S3

Bhavini Bhatia

Automate PostgreSQL audit log extraction and analysis with Amazon S3

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
Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology

Wellingtone Luvonga

Going Multi-Region: How to Set Up CloudNativePG(CNPG) Distributed Topology

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
By the Time Your Data Warehouse Answers, the Opportunity Is Gone

enterprisedb.com

By the Time Your Data Warehouse Answers, the Opportunity Is Gone

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
Building a Sovereign, Intelligent Data Foundation with EDB Postgres® AI on IBM LinuxONE 5

enterprisedb.com

Building a Sovereign, Intelligent Data Foundation with EDB Postgres® AI on IBM LinuxONE 5

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
5 PostgreSQL performance bottlenecks every DBA should know in 2026

Rajni Baliyan

5 PostgreSQL performance bottlenecks every DBA should know in 2026

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

PostgreSQL Hackers Email Discussion Highlights

Add malloc attribute to memory allocation functions

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
Fix gistkillitems & add regression test to microvacuum

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
Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment

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
index prefetching

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
WAL compression setting after PostgreSQL LZ4 default change

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
Global temporary tables

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

Click here for the full Hacker discussion highlights

 

Industry News

Figma acquires team behind a vibe-coding app

techcrunch.com

Figma acquires team behind a vibe-coding app

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…

Claude Cowork expands to mobile and web

techcrunch.com

Claude Cowork expands to mobile and web

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…

Microsoft joins AI cost-cutting trend by relying more on its own models

techcrunch.com

Microsoft joins AI cost-cutting trend by relying more on its own models

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 to learn more