{"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\/news\/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 zbulua nj\u00eb regresion q\u00eb redukton dyfish performanc\u00ebn e PostgreSQL","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 parameter\u00ebve t\u00eb planifikuesit t\u00eb detyrave ka \u00e7uar n\u00eb nj\u00eb r\u00ebnie t\u00eb ndjeshme t\u00eb kapacitetit dhe reagueshm\u00ebris\u00eb gjat\u00eb p\u00ebrdorimit t\u00eb databaz\u00ebs PostgreSQL n\u00eb sisteme me arkitektur\u00eb ARM64. P\u00ebrdorimi i b\u00ebrtham\u00ebs 7.0 rezultoi n\u00eb nj\u00eb r\u00ebnie t\u00eb performanc\u00ebs gjat\u00eb testit pgbench \"simple-update\" nga 98565 n\u00eb 50751. <\/p>\n

Ngadal\u00ebsimi \u00ebsht\u00eb shkaktuar nga ndryshimi i modalitetit t\u00eb nd\u00ebrlikimeve (preemption) n\u00eb planifikuesin e t\u00eb dh\u00ebnave t\u00eb paracaktuara nga PREEMPT_NONE n\u00eb PREEMPT_LAZY n\u00eb arkitektura q\u00eb mb\u00ebshtesin k\u00ebt\u00eb modalitet, duke b\u00ebr\u00eb q\u00eb hap\u00ebsira e p\u00ebrdoruesit PostgreSQL t\u00eb kaloj\u00eb 55% t\u00eb koh\u00ebs s\u00eb CPU n\u00eb thirrjen s_lock(). P\u00ebr t\u00eb zgjidhur problemin, \u00ebsht\u00eb propozuar kthimi n\u00eb modalitetin PREEMPT_NONE si parazgjedhje dhe heqja e lidhjes s\u00eb tij me cil\u00ebsimin ARCH_NO_PREEMPT. <\/p>\n

Peter Zijlstra, autori i ndryshimeve q\u00eb shkaktuan regresionin dhe menaxheri i planifikuesit t\u00eb detyrave dhe subsistemeve t\u00eb lidhura me bllokimet e b\u00ebrtham\u00ebs, deklaroi se duhet b\u00ebr\u00eb nj\u00eb korrigjim n\u00eb kodin e PostgreSQL. P\u00ebr t\u00eb eliminuar r\u00ebnien e performanc\u00ebs, ai rekomandoi q\u00eb t\u00eb p\u00ebrdoret n\u00eb PostgreSQL zgjerimi s\u00eb fundmi i shtuar n\u00eb b\u00ebrtham\u00eb \"rseq slice\" (Sekuenca t\u00eb Rishk\u00ebputura) p\u00ebr t\u00eb kufizuar probabilitetin e z\u00ebvend\u00ebsimit t\u00eb mbajt\u00ebsit t\u00eb bllokimit. <\/p>\n

Ende nuk \u00ebsht\u00eb e qart\u00eb se cilin zgjidhje do t\u00eb marr\u00eb Linus Torvalds, i cili mban rregullin se b\u00ebrthama nuk duhet t\u00eb p\u00ebrkeq\u00ebsoj\u00eb performanc\u00ebn dhe t\u00eb prish\u00eb p\u00ebrputhshm\u00ebrin\u00eb me hap\u00ebsir\u00ebn e p\u00ebrdoruesit. Nga nj\u00ebra an\u00eb, b\u00ebrthama 7.0 ndodhet n\u00eb faz\u00ebn p\u00ebrfundimtare t\u00eb testimit para l\u00ebshimit dhe rikthimi i cil\u00ebsimeve t\u00eb planifikuesit mund t\u00eb sjell\u00eb regresione t\u00eb tjera, nd\u00ebrsa nga ana tjet\u00ebr, p\u00ebrdoruesit mund t\u00eb p\u00ebrballen me nj\u00eb r\u00ebnie t\u00eb dyfisht\u00eb t\u00eb performanc\u00ebs s\u00eb nj\u00eb nga DBMS m\u00eb t\u00eb njohura.
\n
Burimi: 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-news"],"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 N\u00eb b\u00ebrtham\u00ebn Linux 7.0 u zbulua nj\u00eb regresion, i cili redukton performanc\u00ebn e PostgreSQL n\u00eb gjysm\u00eb | ProHoster","description":"Nj\u00eb inxhinier nga kompania Amazon zbuloi nj\u00eb regresion specifik p\u00ebr b\u00ebrtham\u00ebn Linux 7.0, e cila pritet t\u00eb l\u00ebshohet m\u00eb 13 prill.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/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":"sq_AL","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.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/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\/sq\/wp-json\/wp\/v2\/posts\/167524","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=167524"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/167524\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=167524"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=167524"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=167524"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}