PostgreSQL 20新增了后端级锁统计功能，用户可以通过pg_stat_get_backend_lock()实时监控每个后端的锁等待计数和等待时间。这将有助于诊断性能问题。

We had our first meetup on Thursday, July 2nd, organized by the community people for the community people. Bilge Korkmaz Erdim, Gülçin Yıldırım Jelínek, and I had been working on the meetup idea...

If you are of a certain age, the words 38911 BASIC BYTES FREE will do something to you that no amount of therapy can undo. You remember the blue screen. You remember typing in three pages of a...

For PostgreSQL administrators, DBAs, SREs, and platform teams, understanding how backup data moves through a system is just as important as knowing when a backup completed successfully. Questions...

A field report on recovering core PostgreSQL tables after all database files were encrypted by ransomware and the system catalogs were unusable. With only test-environment DDL available, PDU...

One of our client’s PostgreSQL 16.8 production databases started logging what looked like a memory error: ERROR: invalid memory alloc request size The error immediately pointed toward two likely...

Starting from a ransomware recovery case, this article explains how PostgreSQL single-file-per-relation storage can make catalog recovery especially difficult, and compares that exposure with...

Every database migration has a story. And after enough Oracle and SQL Server projects landing on PostgreSQL, one pattern keeps repeating: the things that sink a migration are rarely the big,...

许多人误解Postgres中的checkpoint_timeout，认为延长超时时间会导致崩溃后的恢复时间更长。实际上，恢复时间取决于需要重放的WAL记录数量，而非checkpoint_timeout的设置。频繁的检查点会增加写入压力，导致性能下降。建议将checkpoint_timeout设置在15到30分钟之间，以确保检查点由max_wal_size触发，而非超时。

Why do we still waste time browsing YouTube and news sites looking for interesting content? Why rely on someone else's algorithm — when Claude, for instance, retains conversation history in one...