--- title: "ClickHouse's new benchmark for Postgres services" publication: "Postgres Weekly" issue: 643 published_at: "2026-04-08" canonical_url: "https://postgresweekly.com/issues/643" --- Plus Linux 7.0 slows Postgres down by half on ARM, a handy Postgres book, and a safer way to let agents chew over your database. #​643 — April 8, 2026 [Web Version](https://postgresweekly.com/issues/643) Together with [![Microsoft logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_280,h_60/e_make_transparent/co_white,e_outline:7/om9hjsmudy5lsvba59eb.png)](https://posetteconf.com/2026/schedule/) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/fwcg92rcerfavcxjv2kt.jpg)](https://www.phoronix.com/news/Linux-7.0-AWS-PostgreSQL-Drop) [AWS Engineer Reports Postgres Performance Halved by Linux 7.0](https://www.phoronix.com/news/Linux-7.0-AWS-PostgreSQL-Drop) — 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](https://lore.kernel.org/lkml/20260403191942.21410-1-dipiets@amazon.it/) 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.](https://news.ycombinator.com/item?id=47645543) [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/3478fc3d.png)](https://posetteconf.com/2026/schedule/) [You Don’t Have To Attend All 44 Postgres Talks](https://posetteconf.com/2026/schedule/) — 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.](https://posetteconf.com/2026/schedule/) Microsoft | AMD sponsor 📊 [PostgresBench: A Reproducible Benchmark for Postgres Services](https://clickhouse.com/blog/postgresbench) — 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](https://github.com/ClickHouse/PostgresBench), so the methodology can be easily reproduced and scrutinized. Lionel Palacin (ClickHouse) [`pg_column_size()`: What You See Isn't What You Get](https://mydbanotebook.org/posts/pg_column_size-what-you-see-is-not-what-you-get/) — TOAST introduces ambiguity, and Lætitia wants to patch Postgres’s docs to be more accurate about what `pg_column_size` _really_ shows. Lætitia Avrot 📘 [Lift the Elephant: A Book about Scaling Beyond the Query](https://leanpub.com/lift-the-elephant/) — 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 `UPDATE`/`DELETE` .. `FOR PORTION OF`](https://www.depesz.com/2026/04/02/waiting-for-postgresql-19-add-update-delete-for-portion-of/) – An extension to `UPDATE`/`DELETE` to do a ‘temporal update/delete’ based on a range or multirange column. Hubert Lubaczewski 📄 [Schemas in Postgres and Oracle: What's the Difference?](https://www.cybertec-postgresql.com/en/schema-postgresql-oracle-difference/) – Similar on the surface, very different in the details. Laurenz Albe 📄 [Do You Need to Tune Postgres Vacuum?](https://www.snowflake.com/en/engineering-blog/tuning-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?](https://www.pgedge.com/blog/what-is-a-collation-and-why-is-my-data-corrupt) Shaun Thomas 📰 Classifieds [Collect real-time search data at scale](https://serpapi.com/playground/?utm_source=cooperpress&utm_campaign=postgres_classified) with an API built for analysts, engineers, and AI teams. **RELEASES AND CODE:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/dm11sns3iit7dgr6smi8.jpg)](https://boringsql.com/posts/dont-let-ai-to-prod/) [Don't Let AI Touch Your Production Database: Use `dryrun` Instead](https://boringsql.com/posts/dont-let-ai-to-prod/) — For many tasks, it helps if agents can _see information_ about your database, but they don’t really need a full connection. [dryrun](https://boringsql.com/products/dryrun/) is Radim’s new “offline-first” Postgres MCP server that lets AI agents access what they need to help you, but using a JSON snapshot rather than a connection to your live database. Radim Marek [pgmicro: An In-Process Postgres Reimplementation](https://github.com/glommer/pgmicro) — From the founder of [Turso](https://turso.tech/), _pgmicro_ parses SQL using `libpg_query` and compiles it directly to SQLite bytecode. Ships as an npm package and CLI with a wire protocol server option for using existing Postgres clients. Glauber Costa (Turso) [`rpg`: Modern Postgres Terminal Written in Rust](https://github.com/NikolayS/rpg) — A psql-compatible terminal written in Rust with built-in DBA diagnostics and AI assistant. Single binary, no dependencies, cross-platform. Nik Samokhvalov - [pg_clickhouse v0.1.10](https://justatheory.com/2026/04/pg_clickhouse-0.1.10/) – Query [ClickHouse](https://clickhouse.com/) databases from Postgres. Now with more compatibility improvements, like mappings for `JSON`/`JSONB`/`TEXT` operators as well as numerous window functions, including `RANK`, `PERCENT_RANK`, and `ROW_NUMBER`. - [pg_trickle v0.16](https://github.com/grove/pg-trickle) – Declarative, automatically-refreshing materialized views. [pg_ivm](https://github.com/sraoss/pg_ivm) is another good solution in this space. - [pgfmt 2.0](https://github.com/gmr/pgfmt) – Rust-powered Postgres-flavored SQL formatter, supporting several SQL style guides (but [here's the default](https://gist.github.com/gmr/2cceb85bb37be96bc96f05c5b8de9e1b)). - [libpqxx 8.0 / 8.0.1](https://github.com/jtv/libpqxx/releases/tag/8.0.1) – The official C++ client API for Postgres. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).