4 ms·
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 wi
by dsr_ 6mo ago
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.
- stingraycharles 6mo agoThat 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?
- bombcar 6mo agoThat's the big thing - PSQL will be tested, noticed, and fixed (and likely have a version that handles 7.0 by the time it's in common use). But other software won't and may not even be noticed, except as a (I hate using the term) enshittification. Better to introduce the "correct way" in 7.0 but not regress the old (translate the "correct" into the old if necessary) - and then in 8.0 or some future release implement the regression.
- stingraycharles 6mo agoExactly, this is how it’s usually done. As the developer on the mailing list mentions, implementing a new low level construct in 7.0 and a performance regression that requires said new low level construct to mitigate is not great. You need a grace period in which both old and new approach is fast.
- Meekro 6mo ago> 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.
- Neywiny 6mo agoNot nobody but not everybody upgrades to the newest distros immediately. That's the advantage of LTS. I've even found that a lot of programs have poorer support on 24.04 than 22.04 due to security changes, so I'm fine sticking with 22.04 as my main dev system.
- stingraycharles 6mo agoThis seems to be brushing off a major performance regression just because you personally don’t upgrade for 4 years. I don’t think that’s common at all.
- Neywiny 6mo agohttps://fr.archive.ubuntu.com/stats/stats_of_day-16.html?version=last#:~:text=April%2030%2C%202006,data%20are%20excluded%20from%20statistics)%20: https://fr.archive.ubuntu.com/stats/stats_of_day-16.html?ver... no need to think, data backs it up
- esafak 6mo agoThat's the advantage of LTS? 24.04 is the LTS, not the one you use, 22.04.
- deleted 6mo ago[deleted]
- SoftTalker 6mo ago22.04 is also an LTS release, supported for another year still. https://ubuntu.com/about/release-cycle https://ubuntu.com/about/release-cycle We're just now looking at moving production machines to 24.04.
- apelapan 6mo agoIf you are on a maintenance contract with Ubuntu, 22.04 is supported until 2032. If it aint broken, don't fix it.
- bombcar 6mo agoWe need some sensible people running the latest and greatest or we won't catch things like this.
- cwillu 6mo agoThe option to set PREEMPT_NONE was removed for basically all platforms.
- Seattle3503 6mo agoIf you're running in a docker container you share the host kernel. You might not have a choice.
- GandalfHN 6mo ago[dead]
- GandalfHN 6mo ago[dead]