{"id":167524,"date":"2026-04-04T23:11:54","date_gmt":"2026-04-04T21:11:54","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/v-yadre-linux-7-0-vyyavili-regressiyu-v-dva-raza-snizhayushhuyu-proizvoditelnost-postgresql"},"modified":"2026-04-04T23:11:54","modified_gmt":"2026-04-04T21:11:54","slug":"v-yadre-linux-7-0-vyyavili-regressiyu-v-dva-raza-snizhayushhuyu-proizvoditelnost-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/v-yadre-linux-7-0-vyyavili-regressiyu-v-dva-raza-snizhayushhuyu-proizvoditelnost-postgresql","title":{"rendered":"Linuxi kernelis 7.0 avastati regressioon, mis v\u00e4hendab PostgreSQL-i j\u00f5udlust kahel korral.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Amazoni insener tuvastas Linux 7.0 p\u00f5hij\u00f5udlusesse spetsiifilise regresiooni, mille v\u00e4ljalaskmine on planeeritud 13. aprilliks. \u00dclesannete planeerija seade muudatused on p\u00f5hjustanud m\u00e4rkimisv\u00e4\u00e4rset l\u00e4bilaskev\u00f5ime ja reageerimisv\u00f5ime v\u00e4henemist PostgreSQL andmebaasi haldamisel ARM64 arhitektuuriga s\u00fcsteemides. Kernel 7.0 kasutamisel on pgbench «simple-update» testi tulemused peaaegu kahekordistunud \u2014 98565-lt 50751-le. <\/p>\n

Aeglustamine on p\u00f5hjustatud s\u00e4ilitamise (preemption) muutmisest vaikimisi ajastaja PREEMPT_NONE-lt PREEMPT_LAZY-le arhitektuuridel, mis toetavad seda re\u017eiimi, mist\u00f5ttu PostgreSQL-i kasutajaruumi viibimise aeg suurenes 55% protsessoriajast s_lock() kutse ajal. Probleemi lahendamiseks on soovitatud vaikimisi re\u017eiimi PREEMPT_NONE naasmist ja selle sidumise eemaldamist seade ARCH_NO_PREEMPTiga. <\/p>\n

Muudatused, mis p\u00f5hjustasid regresiooni, on teinud Peter Zijlstra, \u00fclesannete planeerija ja kernele seotud alam\u00fcsteemide hooldaja. Ta teatas, et parandused tuleb teha PostgreSQL koodis. Toimingute sooritamise languse v\u00e4hendamiseks soovitas ta kasutada PostgreSQL-se hiljuti lisatud «rseq slice» (Restartable Sequences) laiendust, et v\u00e4hendada blokeeringu hoidja v\u00e4ljat\u00f5ukamise t\u00f5en\u00e4osust. <\/p>\n

Ei ole selge, millise lahenduse v\u00f5tab Linus Torvalds, kes j\u00e4rgib reeglit, et tuum ei tohiks halvendada j\u00f5udlust ega rikkuda \u00fchilduvust kasutaja ruumiga. \u00dchest k\u00fcljest on tuum 7.0 l\u00f5ppfaasis testimisel enne v\u00e4ljaandmist ja ajakava seadetest tagasiviimine v\u00f5ib p\u00f5hjustada muid regressioone, kuid teisest k\u00fcljest v\u00f5ivad kasutajad kokku puutuda kahekordse j\u00f5udluse langusega \u00fche k\u00f5ige populaarsema andmebaasi puhul.
\n
Allikas: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0418\u043d\u0436\u0435\u043d\u0435\u0440 \u0438\u0437 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438 Amazon \u0432\u044b\u044f\u0432\u0438\u043b \u0440\u0435\u0433\u0440\u0435\u0441\u0441\u0438\u044e, \u0441\u043f\u0435\u0446\u0438\u0444\u0438\u0447\u043d\u0443\u044e \u0434\u043b\u044f \u044f\u0434\u0440\u0430 Linux 7.0, \u0440\u0435\u043b\u0438\u0437 \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u043e\u0436\u0438\u0434\u0430\u0435\u0442\u0441\u044f 13 \u0430\u043f\u0440\u0435\u043b\u044f. \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a \u043f\u043b\u0430\u043d\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430 \u0437\u0430\u0434\u0430\u0447 \u043f\u0440\u0438\u0432\u0435\u043b\u043e \u043a \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u043c\u0443 \u0441\u043d\u0438\u0436\u0435\u043d\u0438\u044e \u043f\u0440\u043e\u043f\u0443\u0441\u043a\u043d\u043e\u0439 \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u0438 \u0438 \u043e\u0442\u0437\u044b\u0432\u0447\u0438\u0432\u043e\u0441\u0442\u0438 \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0421\u0423\u0411\u0414 PostgreSQL \u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u0441 \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u043e\u0439 ARM64. \u041f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u044f\u0434\u0440\u0430 7.0 \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u0435\u043b\u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043f\u0440\u0438 \u043f\u0440\u043e\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0438 \u0442\u0435\u0441\u0442\u0430 pgbench «simple-update» \u0441\u043d\u0438\u0437\u0438\u043b\u0438\u0441\u044c \u043f\u043e\u0447\u0442\u0438 \u0432 \u0434\u0432\u0430 \u0440\u0430\u0437\u0430 — \u0441 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-167524","post","type-post","status-publish","format-standard","hentry","category-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47 Linuxi 7.0 tuumas avastati regressioon, mis v\u00e4hendab PostgreSQL j\u00f5udlust kahekordselt | ProHoster","description":"Amazoni insener avastas, et Linuxi 7.0 tuumaga on tekkinud regressioon, mille v\u00e4ljalaskmine on planeeritud 13. aprilliks. \u00dclesande ajastuse seadete muutmine on t\u00f5siselt v\u00e4hendanud PostgreSQL andmebaasi j\u00f5udlust ja reageerimiskiirust ARM64 arhitektuuriga s\u00fcsteemides. Linuxi 7.0 tuumal v\u00e4henes \"simple-update\" testi l\u00e4bilaskev\u00f5ime peaaegu kaks korda -","canonical_url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/v-yadre-linux-7-0-vyyavili-regressiyu-v-dva-raza-snizhayushhuyu-proizvoditelnost-postgresql","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0412 \u044f\u0434\u0440\u0435 Linux 7.0 \u0432\u044b\u044f\u0432\u0438\u043b\u0438 \u0440\u0435\u0433\u0440\u0435\u0441\u0441\u0438\u044e, \u0432 \u0434\u0432\u0430 \u0440\u0430\u0437\u0430 \u0441\u043d\u0438\u0436\u0430\u044e\u0449\u0443\u044e \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c PostgreSQL | ProHoster","og:description":"\u0418\u043d\u0436\u0435\u043d\u0435\u0440 \u0438\u0437 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0438 Amazon \u0432\u044b\u044f\u0432\u0438\u043b \u0440\u0435\u0433\u0440\u0435\u0441\u0441\u0438\u044e, \u0441\u043f\u0435\u0446\u0438\u0444\u0438\u0447\u043d\u0443\u044e \u0434\u043b\u044f \u044f\u0434\u0440\u0430 Linux 7.0, \u0440\u0435\u043b\u0438\u0437 \u043a\u043e\u0442\u043e\u0440\u043e\u0433\u043e \u043e\u0436\u0438\u0434\u0430\u0435\u0442\u0441\u044f 13 \u0430\u043f\u0440\u0435\u043b\u044f. \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u043d\u0430\u0441\u0442\u0440\u043e\u0435\u043a \u043f\u043b\u0430\u043d\u0438\u0440\u043e\u0432\u0449\u0438\u043a\u0430 \u0437\u0430\u0434\u0430\u0447 \u043f\u0440\u0438\u0432\u0435\u043b\u043e \u043a \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u043c\u0443 \u0441\u043d\u0438\u0436\u0435\u043d\u0438\u044e \u043f\u0440\u043e\u043f\u0443\u0441\u043a\u043d\u043e\u0439 \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u0438 \u0438 \u043e\u0442\u0437\u044b\u0432\u0447\u0438\u0432\u043e\u0441\u0442\u0438 \u043f\u0440\u0438 \u0440\u0430\u0431\u043e\u0442\u0435 \u0421\u0423\u0411\u0414 PostgreSQL \u043d\u0430 \u0441\u0438\u0441\u0442\u0435\u043c\u0430\u0445 \u0441 \u0430\u0440\u0445\u0438\u0442\u0435\u043a\u0442\u0443\u0440\u043e\u0439 ARM64. \u041f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 \u044f\u0434\u0440\u0430 7.0 \u043f\u043e\u043a\u0430\u0437\u0430\u0442\u0435\u043b\u0438 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438 \u043f\u0440\u0438 \u043f\u0440\u043e\u0445\u043e\u0436\u0434\u0435\u043d\u0438\u0438 \u0442\u0435\u0441\u0442\u0430 pgbench "simple-update" \u0441\u043d\u0438\u0437\u0438\u043b\u0438\u0441\u044c \u043f\u043e\u0447\u0442\u0438 \u0432 \u0434\u0432\u0430 \u0440\u0430\u0437\u0430 - \u0441","og:url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/v-yadre-linux-7-0-vyyavili-regressiyu-v-dva-raza-snizhayushhuyu-proizvoditelnost-postgresql","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2026-04-04T21:11:54+00:00","article:modified_time":"2026-04-04T21:11:54+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/167524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=167524"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/167524\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=167524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=167524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=167524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}