{"id":182581,"date":"2026-07-10T10:53:26","date_gmt":"2026-07-10T08:53:26","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/pgrust-klon-postgresql-na-rust-prohodyashhij-vse-regressionnye-testy"},"modified":"2026-07-10T10:53:26","modified_gmt":"2026-07-10T08:53:26","slug":"pgrust-klon-postgresql-na-rust-prohodyashhij-vse-regressionnye-testy","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/pgrust-klon-postgresql-na-rust-prohodyashhij-vse-regressionnye-testy","title":{"rendered":"pgrust \u2014 kloni PostgreSQL n\u00eb Rust, q\u00eb kalon t\u00eb gjitha testet e regresionit","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Projekti pgrust \u00ebsht\u00eb publikuar me implementimin e DBMS PostgreSQL, i shkruar n\u00eb gjuh\u00ebn Rust duke p\u00ebrdorur p\u00ebrkthyesin c2rust dhe ndihm\u00ebsin AI. \u00cbsht\u00eb deklaruar se projekti ende nuk \u00ebsht\u00eb i gatsh\u00ebm p\u00ebr t'u p\u00ebrdorur n\u00eb projekte t\u00eb pun\u00ebs, por tashm\u00eb kalon me sukses t\u00eb gjitha testet regresive t\u00eb PostgreSQL, \u00ebsht\u00eb i p\u00ebrputhshme me formatin e ruajtjes s\u00eb t\u00eb dh\u00ebnave PostgreSQL 18.3 dhe mund t\u00eb p\u00ebrdor\u00eb katalogun e dh\u00ebnave nga PostgreSQL 18.3. Kodi i projektit shp\u00ebrndahet n\u00ebn licens\u00ebn AGPLv3, n\u00eb ndryshim nga PostgreSQL origjinal, i cili ofrohet n\u00ebn nj\u00eb licens\u00eb permissive PostgreSQL, e af\u00ebrt me licencat BSD dhe MIT. Nj\u00eb demonstrim online i mund\u00ebsive \u00ebsht\u00eb i disponuesh\u00ebm, i bazuar n\u00eb nj\u00eb grumbullim n\u00eb WebAssembly, si dhe nj\u00eb imazh docker p\u00ebr nj\u00eb nisje t\u00eb shpejt\u00eb. <\/p>\n
Si nj\u00eb q\u00ebllim t\u00eb zhvillimit, p\u00ebrmendet arritja e nj\u00eb p\u00ebrputhshm\u00ebrie t\u00eb plot\u00eb me PostgreSQL 18.3, si dhe realizimi i eksperimentimeve p\u00ebr ndryshimin e struktur\u00ebs s\u00eb brendshme dhe krijimin e nj\u00eb versioni PostgreSQL, i liruar nga kufizimet arkitekturore, nga t\u00eb cilat nuk \u00ebsht\u00eb e mundur t\u00eb largohemi p\u00ebr arsye historike. Projekti kalon me sukses nj\u00eb set m\u00eb shum\u00eb se 46,000 teste regresive t\u00eb PostgreSQL, por p\u00ebr momentin \u00ebsht\u00eb i pap\u00ebrputhsh\u00ebm me shtesa t\u00eb PostgreSQL, nuk ofron optimizimet e d\u00ebshiruara t\u00eb performanc\u00ebs dhe nuk realizon plot\u00ebsisht gjuh\u00ebt procedurale PL\/Python, PL\/Perl dhe PL\/Tcl. <\/p>\n
Planet p\u00ebr t\u00eb ardhmen: <\/p>\n
\n
Kthimi n\u00eb nj\u00eb arkitektur\u00eb t\u00eb brendshme me shum\u00eb skeda.\n
Mund\u00ebsia e krijimit t\u00eb kopjeve dhe deg\u00ebve t\u00eb elementeve t\u00eb DB n\u00eb modin Copy-on-Write pa kopjimin e t\u00eb dh\u00ebnave.\n
Eksperimentet me nj\u00eb arkitektur\u00eb q\u00eb nuk k\u00ebrkon kryerjen e operacionit VACUUM.\n
Sistemi i kufizimeve t\u00eb SQL-query-t, q\u00eb lejon bllokimin e konsumit t\u00eb tep\u00ebrt t\u00eb burimeve gjat\u00eb ekzekutimit t\u00eb queries me cil\u00ebsi t\u00eb ul\u00ebt.\n
Mbrojtja nga kalimi i optimizuesit n\u00eb planet e ekzekutimit t\u00eb queries m\u00eb pak efektive. <\/ul>\n
Sipas autorit t\u00eb projektit, aktualisht po punohen mbi versionin e ardhsh\u00ebm t\u00eb pgrust, ku n\u00eb vend t\u00eb nj\u00eb grupi punonj\u00ebsish do t\u00eb zbatohet nj\u00eb model shum\u00ebthjesht\u00ebsor p\u00ebr p\u00ebrpunimin e lidhjeve, si dhe do t\u00eb p\u00ebrfshihen optimizime t\u00eb tjera, si p\u00ebrpunimi n\u00eb grupe i rreshtave n\u00eb tabela dhe ngarkimi parashikues i t\u00eb dh\u00ebnave. Gjat\u00eb testimit me instrumentin percona-tpcc, p\u00ebr p\u00ebrpunimin e transaksioneve, versioni i ri i pgrust doli t\u00eb ishte 50% m\u00eb i shpejt\u00eb se PostgreSQL-i standard, nd\u00ebrsa p\u00ebr p\u00ebrpunimin e k\u00ebrkesave analitike \u2014 300 her\u00eb. <\/p>\n
Gjat\u00eb p\u00ebrkthimit n\u00eb Rust, \u00ebsht\u00eb p\u00ebrdorur nj\u00eb qasje hibride, n\u00eb t\u00eb cil\u00ebn kodi i PostgreSQL fillimisht u p\u00ebrpunua me ndihm\u00ebn e p\u00ebrkthyesit c2rust, i cili gjeneron nj\u00eb p\u00ebrfaq\u00ebsim unsafe t\u00eb Rust-it, t\u00eb ngjash\u00ebm me struktur\u00ebn e kodit origjinal n\u00eb C. Pas p\u00ebrpunimit n\u00eb c2rust, u krijuan rreth 1000 crate-pakete, t\u00eb cilat u p\u00ebrkthyen paralelisht n\u00eb Rust-in idiomatik me ndihm\u00ebn e modelit AI Claude dhe mjeteve t\u00eb Conductor p\u00ebr shp\u00ebrndarjen e detyrave midis sub-agjent\u00ebve q\u00eb punonin nj\u00ebkoh\u00ebsisht. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"