#643 — April 8, 2026 |
|
Postgres Weekly |
|
|
AWS Engineer Reports Postgres Performance Halved by Linux 7.0 — When running Postgres 17 on an ARM-based instance running the Linux 7.0 kernel (currently in RC), an engineer noticed performance fell by 49%, leading to a kernel patch to restore Linux’s default preemption mode. The kernel developer behind the initial change, however, says Postgres needs to modernize its locking instead – a big ask given Linux 7.0 is due to land later this month. Michael Larabel (Phoronix) |
💡 It's not yet definitively known if this affects x86-64 too, but initial experiments suggest it does not. |
You Don’t Have To Attend All 44 Postgres Talks — POSETTE: An Event for Postgres 2026 is a free & virtual developer event on 16-18 Jun. All 44 talks stream live & will be available later. Join live to take part in discussions with speakers & attendees. Check out the schedule and mark your calendar. Microsoft | AMD sponsor |
|
📊 PostgresBench: A Reproducible Benchmark for Postgres Services — ClickHouse wanted to stress test and compare their managed Postgres service against the competition, so they built this benchmark system. As is common with benchmarking posts, ClickHouse tops the results, but the system is open source, so the methodology can be easily reproduced and scrutinized. Lionel Palacin (ClickHouse) |
|
Lætitia Avrot |
|
📘 Lift the Elephant: A Book about Scaling Beyond the Query — A 160-page PDF book that provides a mental map of what performance levers exist in Postgres, why they matter, and how to approach tuning methodically. Good for intermediate users who want a real-world playbook. It's a paid product, but can be obtained free if needed. Alex Yarotsky |
💡 We have no financial interest in this book; the author sent us a copy for review. |
|
📄 Waiting for Postgres 19: Add 📄 Schemas in Postgres and Oracle: What's the Difference? – Similar on the surface, very different in the details. Laurenz Albe 📄 Do You Need to Tune Postgres Vacuum? – An evergreen primer to checking for bloat and tuning Postgres’ autovacuum process. Christensen and Jones (Snowflake) 📄 What is a Collation, and Why is My Data Corrupt? Shaun Thomas |
|
|
RELEASES AND CODE: |
|
|
Don't Let AI Touch Your Production Database: Use Radim Marek |
|
pgmicro: An In-Process Postgres Reimplementation —
From the founder of Turso, pgmicro parses SQL using Glauber Costa (Turso) |
|
Nik Samokhvalov |
|


