Postgres is half as fast in Linux 7.0
The Backend Engineering Show with Hussein Nasser

Postgres is half as fast in Linux 7.0

B2中高级2026年6月17日34分钟

An aws engineer discovered a 50% regression in postgres throughput while testing the new Linux 7.0 kernel. The cause turns out to be massive TLB and page faults exacerbated by Postgres process-based design. In this backend engineering show episode I dive deep into how this was discovered, the root cause and the possible fixes and workarounds. Intermediate and Advanced Backend Engineering Course Bundlehttps://courses.husseinnasser.com/bundleMy Book, Root Cause: Stories and Lessons from Two Decades of Backend Engineering Bugs https://amzn.to/4cKfZhe 0:00 Intro2:30 The Discovery6:30 Spinlocks9:25 Preemption 13:00 Root Cause17:00 How Postgres Processes exacerbated the problem 22:30 Is the fix easy?25:50...

播放本集

打开播放器:完整文字稿,每个单词都可点击,附翻译和单词卡。

试一试:点任意单词

来自本集开头的真实句子,每个单词都标出了难度级别。

第 1 句,共 12 句 · 0:00

% .

and that is mainly due to a change in some default configurations that the Linux

点一个单词,用你的语言查看释义。

这些单词你认识吗?

本集中 8 个较难的单词。点一个查看释义,然后标记一下。

标记几个单词,我们会告诉你这一集是否适合你的水平。

这一集适合你吗?

B2

B2 · 中高级

能看懂电视新闻就会觉得轻松

A1 34%A2 32%B1 15%B2 13%C1 6%
  • 81% 的单词在 B1 或更简单的水平。
  • 每分钟 130 词:自然语速。
  • 整集共有 106 个较难的单词(B2 及以上)。

文字稿

本集开头部分。完整文字稿在播放器中。

0:00

Amazon engineer discovered that Postgres SQL is 50% slower in the new to be released Linux kernel 7.0 and that is mainly due to a change in some default configurations that the Linux kernel decided to change these changes specifically target something called preemption in kernel code. Now of course the Postgres maintainers were all over this, this

0:32

happened two months ago and they were all over this and the problem is understood and there is a workaround, not a code workaround, it's just a configuration workaround to enable it, to enable Postgres to perform normally. but I wanted to make this video to illustrate the fundamental design choice

0:57

that Postgres made that actually led to this issue and that is the choice of mainly processes versus threads in my opinion. So let's do a deep dive of this topic we'll talk about what happened how this was discovered fantastic troubleshooting by the way from the Italian this is coming from Amazon

以上是开头部分。 本集其余部分(33 分钟)在播放器中:每个单词都可点击,附翻译、生词收藏和单词卡。

在播放器中继续

由音频自动生成,可能存在错误。 音频版权归其发布者所有,并从其订阅源播放。版权所有者可申请删除 — 版权与删除政策