PostgreSQL Technical Articles

Stefano D'Alessio

Enforcing TLS and managing certificate rotation for RDS and Amazon Aurora PostgreSQL

This AWS blog post explains how to enforce TLS and manage certificate rotation for Amazon RDS and Aurora PostgreSQL. Key steps include enabling rds.force_ssl=1 to block unencrypte…

Read the Blog

Nikita Shamgunov

Electric is joining team Neon at Databricks

Electric, the team behind PGlite and the Electric sync engine, is joining Neon within Databricks following Databricks' acquisition announcement. The move brings Electric's core te…

Read the Blog

Wellingtone Luvonga

Multi-Region PostgreSQL Disaster Recovery and Failback with Crunchy PGO

This guide details a complete multi-region disaster recovery and failback workflow for PostgreSQL using Crunchy PGO (PostgreSQL Operator) on Kubernetes with MinIO as the WAL archi…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Proposal: Conflict log history table for Logical Replication

The discussion focuses on the conflict log table (CLT) for logical replication. Key decisions include: (1) only LOG-level (resolved) conflicts are stored in the CLT, while ERROR-l…

Read Discussion

Restructured Shared Buffer Hash Table

The discussion centers on a patch from Databricks (Dhruv Aron) proposing a specialized hash table for shared buffer lookups, replacing the existing dynahash structure with two fla…

Read Discussion

problems with toast.* reloptions

The thread addresses bugs in how TOAST table reloptions (particularly autovacuum parameters) are inherited and merged. Nathan Bossart submitted a new v8 patch set (0005–0007): 000…

Read Discussion

[PATCH] bufmgr: tighten LWLock:BufferMapping on InvalidateBuffer

Alexandre Felipe proposed a patch to reduce partition LWLock hold time in `InvalidateBuffer` and `InvalidateVictimBuffer`, arguing that the partition lock causes more contention t…

Read Discussion

Crash issue in PG18.5 regression

A crash was reported in PG18.5 when running `SELECT to_date('01 ŞUB 2010', 'DD TMMON YYYY')` on a C-locale instance (UTF8 encoding). Masashi Kamura identified commit 011384ba45f a…

Read Discussion

CREATE INDEX vs. TOAST table stats

Commit d611f8b158 modified `CREATE INDEX` to skip updating table stats when autovacuum is off, preserving restored stats. It included `RELKIND_TOASTVALUE` in the affected relkinds…

Read Discussion

Industry News

techcrunch.com

General Catalyst Leads $1.1B Funding Round into 2-Month-Old River AI

River AI, a startup founded by xAI co-founder Igor Babuschkin, has raised $1.1 billion in a funding round led by General Catalyst, just two months after its founding. The company…

techcrunch.com

OpenAI COO Brad Lightcap Departing to Launch New Venture

Brad Lightcap, one of OpenAI's longest-serving executives and its Chief Operating Officer, is leaving the company to start a new venture. In a message to staff, Lightcap expressed…

techcrunch.com

Anthropic to Watermark Text Generated by Its AI Models

Anthropic has announced it will introduce watermarking for text generated by its AI models, including extending support to older models in its lineup. The move is aimed at improvi…

Social Media Updates

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates