{"id":120814,"date":"2024-12-02T09:45:59","date_gmt":"2024-12-02T07:46:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql"},"modified":"2024-12-02T09:45:59","modified_gmt":"2024-12-02T07:46:01","slug":"sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/sedmaya-beta-versiya-orioledb-vysokoproizvoditelnogo-dvizhka-hraneniya-dlya-postgresql","title":{"rendered":"Versioni i shtat\u00eb beta i OrioleDB, nj\u00eb motor ruajtjeje me performanc\u00eb t\u00eb lart\u00eb p\u00ebr PostgreSQL","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Versioni beta e OrioleDB beta7 \u00ebsht\u00eb publikuar, duke treguar rezultate t\u00eb reja testimi q\u00eb demonstrojn\u00eb nj\u00eb rritje t\u00eb konsiderueshme t\u00eb performanc\u00ebs krahasuar me PostgreSQL tradicional. N\u00eb versionin beta7 jan\u00eb implementuar optimizime p\u00ebr t\u00eb p\u00ebrmir\u00ebsuar performanc\u00ebn n\u00eb ngarkesa me shum\u00eb thread dhe p\u00ebr t\u00eb acceleruar operacionet e leximit dhe shkrimit. Publikimi i par\u00eb stabil i OrioleDB pritet t\u00eb formohet n\u00eb vitin 2025. Motori \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn C dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn PostgreSQL, e cila \u00ebsht\u00eb e ngjashme me licencat BSD dhe MIT. <\/p>\n
Projekti OrioleDB zhvillon nj\u00eb motor alternativ t\u00eb ruajtjes p\u00ebr PostgreSQL, i dizajnuar p\u00ebr t\u00eb adresuar kufizimet e mekanizmit standard t\u00eb ruajtjes dhe p\u00ebr t\u00eb rritur efikasitetin e p\u00ebrgjithsh\u00ebm t\u00eb sistemit. P\u00ebr shembull, OrioleDB lejon t\u00eb shmanget nevoja p\u00ebr t\u00eb kryer periodikisht operacionin VACUUM p\u00ebr pastrimin e mbeturinave, fal\u00eb implementimit t\u00eb mekanizmit MVCC (Kontrolli i Konkurrenc\u00ebs me Versione t\u00eb M\u00faltiple) mbi baz\u00ebn e t\u00eb dh\u00ebnave t\u00eb pengesave (undo logs), duke funksionuar n\u00eb nivelin e bllokimeve dhe rreshtave individuale, si dhe nj\u00eb sistemi automatik t\u00eb bashkimit t\u00eb faqeve q\u00eb p\u00ebrmbajn\u00eb t\u00eb dh\u00ebna. OrioleDB gjithashtu p\u00ebrdor identifikues 64-bit\u00ebsh p\u00ebr transaksionet, duke e zgjidhur problemin e mbushjes s\u00eb numrave. <\/p>\n
P\u00ebr t\u00eb simplifikuar p\u00ebrdorimin n\u00eb sisteme t\u00eb shp\u00ebrndara dhe p\u00ebr t\u00eb paralelizuar operacionet n\u00eb OrioleDB, \u00ebsht\u00eb organizuar mbajtja e nj\u00eb WAL-logu t\u00eb transaksioneve n\u00eb nivelin e rreshtave. Gjat\u00eb ekzekutimit t\u00eb operacionit UPDATE, mb\u00ebshtetet nd\u00ebrrimi i t\u00eb dh\u00ebnave n\u00eb vend (pa \u00e7lirimin e regjistrimit aktual dhe krijimin e nj\u00eb t\u00eb ri), q\u00eb ndihmon n\u00eb rritjen e performanc\u00ebs. N\u00eb OrioleDB jan\u00eb implementuar gjithashtu mund\u00ebsi si leximi i faqeve me t\u00eb dh\u00ebna pa p\u00ebrdorim t\u00eb bllokimeve, lidhja direkte e faqeve n\u00eb memorie me ato n\u00eb ruajtjen e p\u00ebrhershme, aplikimi i mekanizmit CoW (copy-on-write) gjat\u00eb ruajtjes s\u00eb pikave t\u00eb kontrollit p\u00ebr t\u00eb krijuar hap\u00ebsira t\u00eb qarta n\u00eb \u00e7do moment, dhe nj\u00eb mod t\u00eb ruajtjes s\u00eb t\u00eb dh\u00ebnave n\u00eb form\u00eb t\u00eb kompresuar duke p\u00ebrdorur algoritmin ZSTD. <\/p>\n
N\u00eb betan e shtat\u00eb t\u00eb OrioleDB, nj\u00eb nga kufizimet e pranishme \u00ebsht\u00eb se vet\u00ebm indekset n\u00eb formatin B-tree jan\u00eb t\u00eb disponueshme (mb\u00ebshtetje p\u00ebr t\u00eb gjith\u00eb llojet e indekseve t\u00eb PostgreSQL do t\u00eb shtohet n\u00eb t\u00eb ardhmen), si dhe mungesa e mb\u00ebshtetjes p\u00ebr transaksionet e paracaktuara (PREPARE TRANSACTION) dhe urdhri 'REINDEX' n\u00eb modalitetin 'CONCURRENTLY'. OrioleDB \u00ebsht\u00eb implementuar si nj\u00eb zgjerim i instaluar, q\u00eb k\u00ebrkon ndryshime n\u00eb baz\u00ebn kryesore t\u00eb kodit t\u00eb PostgreSQL. <\/p>\n
N\u00eb testet e performanc\u00ebs TPC-C, t\u00eb cilat modelojn\u00eb ngarkes\u00ebn e p\u00ebrpunimit tranzaksional n\u00eb kushte reale, versioni i shtat\u00eb beta i OrioleDB tregoi nj\u00eb p\u00ebrpar\u00ebsi t\u00eb dukshme krahasuar me motorin e zakonsh\u00ebm t\u00eb PostgreSQL. Testimi u krye me nj\u00eb num\u00ebr t\u00eb ndrysh\u00ebm klient\u00ebsh q\u00eb punonin nj\u00ebkoh\u00ebsisht, p\u00ebr t\u00eb vler\u00ebsuar shkall\u00ebzueshm\u00ebrin\u00eb dhe performanc\u00ebn e sistemit kur ngarkesa rritej. <\/p>\n
N\u00eb testet q\u00eb vler\u00ebsojn\u00eb kapacitetin e transaksioneve, motori OrioleDB arriti nj\u00eb kapacitet m\u00eb t\u00eb lart\u00eb, i matur n\u00eb transaksione p\u00ebr minut\u00eb (tpmC). Me rritjen e numrit t\u00eb klient\u00ebve, performanca e OrioleDB vazhdoi t\u00eb rritet n\u00eb m\u00ebnyr\u00eb lineare, nd\u00ebrsa motori Heap n\u00eb PostgreSQL tregoi nj\u00eb tendenc\u00eb p\u00ebr stagnim dhe madje ulje pas nj\u00eb pragu t\u00eb caktuar.
<\/center>
<\/center>
<\/center> <\/p>\n
N\u00eb testet mbi koh\u00ebn e p\u00ebrgjigjes, koha mesatare e p\u00ebrgjigjes p\u00ebr transaksionet n\u00eb OrioleDB ishte duksh\u00ebm m\u00eb e ul\u00ebt krahasuar me PostgreSQL. K\u00ebshtu, sistemet e bazuara n\u00eb OrioleDB mund t\u00eb p\u00ebrpunojn\u00eb m\u00eb shum\u00eb transaksione n\u00eb t\u00eb nj\u00ebjt\u00ebn periudh\u00eb kohore, duke ofruar nj\u00eb sh\u00ebrbim m\u00eb t\u00eb shpejt\u00eb p\u00ebr k\u00ebrkesat. Duke matur p\u00ebrdorimin e burimeve, motori OrioleDB tregoi nj\u00eb p\u00ebrdorim m\u00eb efikas t\u00eb CPU dhe memories, fal\u00eb menaxhimit t\u00eb optimizuar t\u00eb burimeve. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
![\"Versioni](\"\/wp-content\/uploads\/2024\/12\/8cac8a61b8daee1fbf8027a4aec2de1e.png\")
<\/center> ![\"Versioni](\"\/wp-content\/uploads\/2024\/12\/39e3a4f1943e4263d0f0960ac5f45366.png\")
<\/center> ![\"Versioni](\"\/wp-content\/uploads\/2024\/12\/a6a1d6e1c9b09b10dcc2d9b4bc61c805.png\")
<\/center> <\/p>\n