{"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\/sq\/blog\/novosti-interneta\/v-yadre-linux-7-0-vyyavili-regressiyu-v-dva-raza-snizhayushhuyu-proizvoditelnost-postgresql","title":{"rendered":"N\u00eb b\u00ebrtham\u00ebn e Linux 7.0 u identifikua nj\u00eb regresion q\u00eb ul performanc\u00ebn e PostgreSQL-s\u00eb me gjysm\u00ebn.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Nj\u00eb inxhinier nga kompania Amazon ka zbuluar nj\u00eb regresion specifik p\u00ebr b\u00ebrtham\u00ebn Linux 7.0, l\u00ebshimi i s\u00eb cil\u00ebs pritet m\u00eb 13 prill. Ndryshimi i konfigurimeve t\u00eb planifikuesit t\u00eb detyrave ka \u00e7uar n\u00eb nj\u00eb zvog\u00eblim t\u00eb ndjesh\u00ebm t\u00eb kapacitetit dhe p\u00ebrgjigjes gjat\u00eb pun\u00ebs me DBMS PostgreSQL n\u00eb sistemet me arkitektur\u00eb ARM64. Duke p\u00ebrdorur b\u00ebrtham\u00ebn 7.0, treguesit e performanc\u00ebs gjat\u00eb testit pgbench \u00absimple-update\u00bb ran\u00eb gati dy her\u00eb \u2014 nga 98565 n\u00eb 50751. <\/p>\n
Ngadal\u00ebsimi \u00ebsht\u00eb shkaktuar nga ndryshimi i modit t\u00eb d\u00ebbimit (preemption) n\u00eb planifikuesin e paracaktuar nga PREEMPT_NONE n\u00eb PREEMPT_LAZY n\u00eb arkitektur\u00eb q\u00eb mb\u00ebshtesin k\u00ebt\u00eb mod, duke shkaktuar q\u00eb n\u00eb hap\u00ebsir\u00ebn p\u00ebrdoruese PostgreSQL t\u00eb shpenzoj\u00eb 55% t\u00eb koh\u00ebs s\u00eb CPU n\u00eb thirrjen s_lock(). P\u00ebr t\u00eb zgjidhur problemin, \u00ebsht\u00eb propozuar t\u00eb kthehet si parazgjedhje moda PREEMPT_NONE dhe t\u00eb hiqet lidhja e saj me cil\u00ebsimin ARCH_NO_PREEMPT. <\/p>\n
Peter Zijlstra, autori i ndryshimeve q\u00eb shkaktuan regresionin, dhe mbajt\u00ebsi i planifikuesit t\u00eb detyrave dhe n\u00ebn-sistemeve t\u00eb lidhura me bllokimet, deklaroi se korrigjimi duhet t\u00eb b\u00ebhet n\u00eb kodin e PostgreSQL. P\u00ebr t\u00eb adresuar r\u00ebnien e performanc\u00ebs, ai k\u00ebshilloi t\u00eb aktivizohej n\u00eb PostgreSQL zgjerimi i sapodal\u00eb n\u00eb b\u00ebrtham\u00eb \u00abrseq slice\u00bb (Sekvencat e Rizbuluara) p\u00ebr t\u00eb kufizuar probabilitetin e z\u00ebvend\u00ebsimit t\u00eb mbajt\u00ebsit t\u00eb bllokimit. <\/p>\n
Ende nuk dihet se \u00e7far\u00eb vendimi do t\u00eb marr\u00eb Linus Torvalds, i cili ndjek rregullin se b\u00ebrthama nuk duhet t\u00eb p\u00ebrkeq\u00ebsoj\u00eb performanc\u00ebn dhe t\u00eb prish\u00eb kompatibilitetin me hap\u00ebsir\u00ebn e p\u00ebrdoruesit. N\u00eb nj\u00ebr\u00ebn an\u00eb, b\u00ebrthama 7.0 ndodhet n\u00eb faz\u00ebn p\u00ebrfundimtare t\u00eb testimit para publikimit dhe rikthimi i konfigurimeve t\u00eb planifikuesit mund t\u00eb \u00e7oj\u00eb n\u00eb regresione t\u00eb tjera, nd\u00ebrsa n\u00eb an\u00ebn tjet\u00ebr p\u00ebrdoruesit mund t\u00eb p\u00ebrballen me nj\u00eb reduktim dyfish t\u00eb performanc\u00ebs t\u00eb nj\u00ebr\u00ebs nga sistemet m\u00eb t\u00eb njohura t\u00eb menaxhimit t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"