PostgreSQL 在 Linux 7.0 (還沒出) 的 performance regression 問題

PostgreSQL 因為 user-space spinlock 的設計,導致在 Linux 7.0 的效能爆降的問題被拿出來討論:「AWS Engineer Reports PostgreSQL Performance Halved By Linux 7.

Gea-Suan Lin's BLOG
Page 103 of Daycare Daze, is up! 🙌 ⏫ 👀 He's just standing there... Menancingly... 👀 ⭐ A new page every week on Sub Star / Fan Box! ⭐ subscribestar.adult/twiggs-doodles / twiggers.fanbox.cc #abdlart #abdl #regression #daycaredaze

🐘 AWS Engineer Reports PostgreSQL Performance

「 Halved By Linux 7.0, But A Fix May Not Be Easy
Bisecting the regression was traced back to the Linux 7.0 change of restricting the available preemption modes for the kernel 」

https://www.phoronix.com/news/Linux-7.0-AWS-PostgreSQL-Drop

#PostgreSQL #linux #kernel #regression

AWS Engineer Reports PostgreSQL Performance Halved By Linux 7.0, But A Fix May Not Be Easy

An Amazon/AWS engineer raised the alarms on Friday over the current Linux 7.0 development kernel leading to the throughput for the PostgreSQL database server being around half that of prior kernel versions

@DaveMasonDotMe

I know and wish it was not so...

#Regression

Page 102 of Daycare Daze, is up! 🙌 Let loose the cow of play time... 🔥 Or don't, i can't control you. ⭐ A new page every week on Sub Star / Fan Box! ⭐ subscribestar.adult/twiggs-doodles / twiggers.fanbox.cc #abdlart #abdl #regression #daycaredaze

Picked these up in the Dealer's Den. Thinking I might open them.

#LittleTroubles #LittleTroublesTCG #Babyfur #Diaper #Diapers #Regression #TexasFurryFiesta #TFF

Page 101 of Daycare Daze, is up! 🙌 We're officially triple digits! Under review on sub star, visible right now on fanbox. ⭐ A new page every week on Sub Star / Fan Box! ⭐ subscribestar.adult/twiggs-doodles / twiggers.fanbox.cc #abdlart #abdl #regression #daycaredaze

About metrics for measuring agreement on regression on continuous datasets:
Reasons to avoid R² and use RMSE instead: https://feat.engineering/03-Review_of_the_Modeling_Process.html#sec-reg-metrics

From Max Kuhn @topepo, Kjell Johnson (2026), "Feature Engineering and Selection: A Practical Approach for Predictive Models"

#prediction #dataDev #modelEvaluation #regression #modelling #linearRegression #modeling #probability #probabilities #statistics #stats #gotcha

3  A Review of the Predictive Modeling Process – Feature Engineering and Selection: A Practical Approach for Predictive Models