按缓冲池、写前日志、MVCC 落点、脏页写出与故障模式对照 PostgreSQL、InnoDB、RocksDB 与 WiredTiger；只谈机制与代价，不写未实测延迟排名。

Changing a PostgreSQL backup solution involves much more than installing a new binary. Backup repositories, retention policies, recovery procedures, operational runbooks, and compliance...

用部署形态、写并发、查询形态与持久化需求收束 SQLite / PostgreSQL·InnoDB / DuckDB / RocksDB 选型；给出站内阅读地图、全系列学术谱系与开放问题，标志 SQLite 内核系列完成。

用进程模型、日志、锁与缓冲池四轴对照 SQLite 与 PostgreSQL / InnoDB：说明嵌入式单文件如何删掉服务器层，以及同名 WAL、隔离、缓存概念为何不能平移运维经验；不写跨库吞吐排名。

When you are upgrading across major PostgreSQL versions, there are a few ways to go. Dump and restore is the simplest to reason about, but downtime scales directly with database size, so for...

Six months ago we started writing the PostgreSQL backup tool we kept wishing existed. Now pg_hardstorage has shipped, and you can read every line of it on GitHub before you trust it with your WAL...

If you've heard one thing about pg_hardstorage, it's probably that "it works against managed PostgreSQL". This post is about the one architectural choice that makes that true, and the consequences...

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...

PostgreSQL today looks very different from the PostgreSQL many of us started working with over 25 years ago. PostgreSQL was once primarily deployed on dedicated servers and virtual machines,...

我开发了一个名为 Ramag 的 macOS 原生桌面工具平台，集成了数据库客户端和剪贴板功能。数据库客户端支持 MySQL、PostgreSQL、Redis 和 MongoDB，提供统一入口和多连接管理。剪贴板功能支持文本和图片历史记录，具备全局热键和搜索筛选功能。项目仍在迭代中，欢迎反馈。

Postgres的pg_stats用于生成统计信息，帮助查询规划器优化执行计划。通过ANALYZE命令更新统计数据，pg_stats提供列的独特值、常见值及其频率等信息。准确的统计数据对查询性能至关重要，错误的统计会导致不佳的执行计划。使用相关统计可以提高多列过滤的准确性。

在已有 MVCC 文章基础上深入 PG 并发控制的三个基础设施：CLOG 的 SLRU 结构（事务状态位、页面格式、SLRU 淘汰）、hint bit 的写入时机和竞争问题（何时写、谁写、写坏了怎么办）、PG 14 snapshot scalability 优化的具体机制（ProcArrayLock 为什么是瓶颈、xid/xmin 的原子更新如何减少持锁路径），以及事务 ID...