PG 生态月度回顾:2026 年 4 月(回溯整理)
回溯整理 覆盖月份:2026-04 · 整理发布:2026-10-02 · 来源:Postgres Weekly 存档
回溯整理说明:本页为 pgcn.cc 上线时(2026-10-02)对 Postgres Weekly 公开存档的 回溯性整理,覆盖 2026 年 4 月的社区动态;条目与日期来自原始存档, 内容归各原作者所有。本页并非当时发布的周报,周报自 2026 年第 1 期起按时发布。
本月脉络
本月最大剧情是 pgBackRest「死亡」风波:维护者 4 月 27 日发布废弃公告,这个大量生产环境依赖的开源备份工具一度悬空——单一维护者风险被推到台前(数日后即现反转,见 5 月)。版本线上,19 发行说明初稿现身,depesz 跟进 UPDATE/DELETE FOR PORTION OF 语法,并行 autovacuum 也在 19 之列;物化视图增量刷新仍停留在邮件列表讨论。厂商与生态侧,Xata 以 Apache 2.0 开源带分支能力的平台、Cloudflare 控制台打通 PlanetScale Postgres 部署。AWS 工程师报告 Linux 7.0 使 Postgres 性能减半,内核与数据库的耦合值得警惕。
Postgres Weekly #643(2026-04-07)
- AWS Engineer Reports Postgres Performance Halved by Linux 7.0
- You Don’t Have To Attend All 44 Postgres Talks
- PostgresBench: A Reproducible Benchmark for Postgres Services
- pg_column_size() : What You See Isn’t What You Get
- Lift the Elephant: A Book about Scaling Beyond the Query
- Waiting for Postgres 19: Add UPDATE / DELETE .. FOR PORTION OF
- Schemas in Postgres and Oracle: What’s the Difference?
- Do You Need to Tune Postgres Vacuum?
Postgres Weekly #644(2026-04-14)
- Keeping a Postgres Queue Healthy
- “just use Postgres!”
- You Extend Postgres for Everything Else. Why Not Analytics?
- Making Materialized View Refreshes O(delta) Instead of O(total)
- materialized view
- being discussed
- Understanding Postgres Wait Events
- Checkpoints, Write Storms, and You
Postgres Weekly #645(2026-04-21)
- The First Draft of the PostgreSQL 19 Release Notes
- targeted to land
- made this wiki page.
- Your Hot Table Hit a Billion Rows. Now What?
- Introducing Xata OSS: A Postgres Platform with Branching, Now Apache 2.0
- attempting to ‘rebuild Postgres in Rust’
- a live online demo here.
- the ability to deploy PlanetScale-hosted databases directly from the Cloudflare dashboard
Postgres Weekly #646(2026-04-28)
- pgBackRest Is ‘Dead’: Now What?
- pgBackRest’s repo
- Christophe Pettus
- Jan Wieremjewicz
- Stefanie Janine Stölting
- Catch Postgres Bugs Before Your PRs Merge
- My Queries to Monitor Autovacuum
- Parallel Autovacuum in Postgres 19: It’s Not About the CPU
数据来源:Postgres Weekly 存档(Cooperpress 出品)。 由 pgcn.cc 回溯归档脚本生成于 2026-10-02。