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.

Postgres 19引入了CHECKPOINT命令的新功能，DBA可以选择FAST和SPREAD两种模式来优化写入性能。FAST模式快速完成检查点，而SPREAD模式则平滑写入，减少对存储的冲击。此外，新增的FLUSH_UNLOGGED选项允许手动刷新未记录表的数据。这些改进提升了CHECKPOINT的灵活性，以满足不同的数据库管理需求。

Postgres 19计划将默认的TOAST压缩算法从pglz更改为LZ4，LZ4在压缩速度和压缩比上优于pglz，更适应现代硬件。Postgres使用统一的压缩框架，自动对可变长度类型进行压缩，TOAST的实现将继续优化压缩算法以解决数据存储问题。