Seven major versions of PostgreSQL shipped between 2018 and 2025, one per year without exception, and each with a changelog of 150 to 200 user-visible changes. Each release covers a broad canvas —...

Fujitsu’s PostgreSQL team helped shape PostgreSQL 19 through sustained code contributions, community recognition, and new improvements in logical replication. Take a closer look at Fujitsu’s...

The first thing you will probably learn about Postgres, if you follow people who don't like Postgres, is that MVCC is bad. The 40-year-old design mistake. It's signatures are everywhere. Bloated...

AWS was kind enough to organize an AI workshop this week in Pittsburgh for their employees, and the Postgres committers and core team. The first day covered the basics of setting up Claude and...

Your Postgres constraints may be capping ingest throughput. Learn how FOREIGN KEY and UNIQUE checks slow high-rate inserts, plus four fixes that protect integrity.

The autovacuum process has been dutifully tending Postgres tables since version 8.1, and almost every release since has acquired some new refinement: smarter thresholds, insert-aware triggering,...

With backups being such a vital part of keeping your data safe, how do they actually work?

Amazon Aurora PostgreSQL 大版本升级有多种方案可供选择。本文聚焦于手动蓝绿部署（Clone + 原生 Pub/Sub）方案，深入介绍如何利用 PostgreSQL 原生逻辑复制能力，以分钟级停机时间完成 Aurora PostgreSQL 大版本升级。 文中以 PostgreSQL 13 升级至 PostgreSQL 17 为例进行说明，相同步骤适用于其他...

IntroductionTraditionally, auditing is a tedious process that often requires detailed...

In my previous blog on the pgEdge Vectorizer and RAG Server, I showed how to build a semantic search pipeline using dense vector embeddings. The RAG Server already did hybrid search, combining...

Postgres Summit US 2026 (formerly: PGConf NYC) will take place September 30 - October 2, at Convene, in New York. EDB is joining the event as a sponsor at the Gold-level. Our team of Postgres...

What happens to old row versions after nobody needs them? They become dead tuples, and over time they bloat your tables. Go deeper into PostgreSQL MVCC with runnable psql examples.