logoalt Hacker News

dsr_today at 12:45 AM7 repliesview on HN

Nobody sensible runs the latest kernel; nobody running PG in production should be afraid of setting a non-default at either boot time or as a sysctl. So this will, most likely, be another step in building a PG database server (turn off pre-emption if your kernel is 7.0 or later and PG is pre-whatever-version).

At worst it might become a permanent part of building a PG server and a FAQ... but if it affects one thing this badly, it will affect others.


Replies

Meekrotoday at 1:28 AM

> Nobody sensible runs the latest kernel

From the article: "Linux 7.0 stable is due out in about two weeks. This is also the kernel version powering Ubuntu 26.04 LTS to be released later in April."

Unfortunately, lots of people will be running it in less than a month. At the moment, it'll take a kernel patch (not a sysctl) to undo this-- hopefully something changes.

show 4 replies
bombcartoday at 2:12 AM

We need some sensible people running the latest and greatest or we won't catch things like this.

stingraycharlestoday at 1:25 AM

That may be the case, but it’s still not a great situation to be in and one has to wonder: if PostgreSQL is affected, what else is?

show 1 reply
Seattle3503today at 4:18 AM

If you're running in a docker container you share the host kernel. You might not have a choice.

cwillutoday at 2:41 AM

The option to set PREEMPT_NONE was removed for basically all platforms.

GandalfHNtoday at 6:31 AM

[dead]

GandalfHNtoday at 5:28 AM

[dead]