{"id":144010,"date":"2025-09-25T17:11:55","date_gmt":"2025-09-25T15:11:55","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-18"},"modified":"2025-09-25T17:11:55","modified_gmt":"2025-09-25T15:11:55","slug":"reliz-subd-postgresql-18","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/reliz-subd-postgresql-18","title":{"rendered":"L\u00ebshimi i DBMS PostgreSQL 18","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas nj\u00eb viti zhvillimi, \u00ebsht\u00eb publikuar dega e re stabile e DBMS PostgreSQL 18. P\u00ebrdit\u00ebsimet p\u00ebr deg\u00ebn e re do t\u00eb l\u00ebshohen p\u00ebr nj\u00eb periudh\u00eb pes\u00ebvje\u00e7are deri n\u00eb n\u00ebntor 2030. Mb\u00ebshtetje p\u00ebr PostgreSQL 13.x, deg\u00ebn m\u00eb t\u00eb vjet\u00ebr t\u00eb mb\u00ebshtetur, do t\u00eb ndalet m\u00eb 13 n\u00ebntor. <\/p>\n
T\u00eb rejat kryesore: <\/p>\n
\n
\u00cbsht\u00eb shtuar nj\u00eb n\u00ebnsiq\u00eb p\u00ebr hyrje\/dalja asinkron, e cila lejon rritjen e kapacitetit t\u00eb hyrje\/dalja dhe elimimin e vonesave. N\u00eb p\u00ebrve\u00e7oh q\u00eb egziston nj\u00eb implementim universali AIO (io_method=worker), i bazuar n\u00eb ekzekutimin e disa proceseve p\u00ebrpunuesish (3 \u00ebsht\u00eb parametrizimi i paracaktuar), n\u00eb Linux mund t\u00eb p\u00ebrdoret nd\u00ebrfaqja e hyrjes\/daljes asinkron io_uring (io_method=io_uring), e mb\u00ebshtetur q\u00eb nga b\u00ebrthama Linux 5.1. Hyrja\/dalja asinkron deri tani \u00ebsht\u00eb angazhuar vet\u00ebm p\u00ebr t\u00eb p\u00ebrshpejtuar ekzekutimin e disa operacioneve q\u00eb lidhen me leximin e t\u00eb dh\u00ebnave nga sistemi i skedave, si skanimi sekondar, skanimi i hart\u00ebs s\u00eb indekseve dhe realizimi i pastrimit (vacuum). N\u00eb disa teste, p\u00ebrdorimi i AIO \u00e7on n\u00eb rritjen e performanc\u00ebs p\u00ebr 2-3 her\u00eb. Operacionet e shk writehen vazhdojn\u00eb t\u00eb kryhen n\u00eb modalitetin sinkron p\u00ebr t\u00eb p\u00ebrmbushur k\u00ebrkesat ACID.\n
\u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr paralelizimin e nd\u00ebrtimit t\u00eb indekseve GIN (Indeksi i P\u00ebrgjith\u00ebsuar i Invertuar), t\u00eb cilat p\u00ebrdoren p\u00ebr indeksonin e vlerave t\u00eb p\u00ebrb\u00ebra, si p\u00ebr shembuj, p\u00ebr array dhe p\u00ebr organizimin e k\u00ebrkimeve mbi t\u00eb dh\u00ebna t\u00eb plota tekstuale ose struktura JSON.\n
\u00cbsht\u00eb p\u00ebrmir\u00ebsuar performanca e bllokimeve p\u00ebr k\u00ebrkesat q\u00eb punojn\u00eb me nj\u00eb num\u00ebr t\u00eb madh tabelash, si dhe jan\u00eb b\u00ebr\u00eb p\u00ebrmir\u00ebsime n\u00eb trajtimin e k\u00ebrkesave ndaj tabelave t\u00eb ndara, duke p\u00ebrshpejtuar p\u00ebrjashtimin e seksioneve t\u00eb pashfryt\u00ebzuara dhe operacionet e bashkimit (JOIN).\n
Jan\u00eb p\u00ebrshpejtuar operacionet me tekst, si funksionet p\u00ebr vendosjen n\u00eb shkronja t\u00eb m\u00ebdha\/t\u00eb vogla. \u00cbsht\u00eb shtuar modaliteti PG_UNICODE_FAST p\u00ebr p\u00ebrshpejtimin e llogaritjes s\u00eb pronave t\u00eb locale t\u00eb simboleve Unicode.\n
Shtuar mb\u00ebshtetje p\u00ebr lidhjen me DBMS, duke p\u00ebrdorur autentifikimin mbi baz\u00ebn e OAUTH 2.0 me p\u00ebrdorimin e tokenit t\u00eb aksesit n\u00eb vend t\u00eb fjal\u00ebkalimit. P\u00ebrdorimi i OAUTH lejon q\u00eb t\u00eb mos ruhen fjal\u00ebkalimet n\u00eb DB, por t\u00eb identifikohen p\u00ebrdoruesit p\u00ebrmes sh\u00ebrbimeve t\u00eb jashtme, si dhe t\u00eb p\u00ebrdoren mund\u00ebsi t\u00eb tilla si autentifikimi me dy faktor\u00eb dhe pika e vetme hyrjeje (SSO).\n
Shtuar funksioni ssl_tls13_ciphers(), p\u00ebrmes t\u00eb cilit mund t\u00eb p\u00ebrcaktohet lista e algoritmeve t\u00eb kodimit t\u00eb lejuar gjat\u00eb lidhjes me p\u00ebrdorimin e protokollit TLSv1.3.\n
N\u00eb kategorin\u00eb e mb\u00ebshtetjeve t\u00eb vjetra dhe t\u00eb planifikuara p\u00ebr t'u hequr \u00ebsht\u00eb kaluar mb\u00ebshtetjes p\u00ebr autentifikimin duke p\u00ebrdorur algoritmin md5 p\u00ebr heshimin e fjal\u00ebkalimeve. N\u00eb vend t\u00eb md5, rekomandohet p\u00ebrdorimi i algoritmit SCRAM (SCRAM-SHA-256), i cili u shfaq n\u00eb PostgreSQL 10. Po ashtu, \u00ebsht\u00eb e sh\u00ebnuar realizimi i mb\u00ebshtetjes p\u00ebr kalimin e autentifikimit mbi baz\u00ebn e SCRAM gjat\u00eb lidhjes p\u00ebrmes postgres_fdw dhe dblink me server\u00eb t\u00eb jasht\u00ebm PostgreSQL.\n
Versioni e reviduar (3.2) e protokollit, i p\u00ebrdorur p\u00ebr nd\u00ebrveprimin e mjeteve t\u00eb jashtme me DBMS, \u00ebsht\u00eb implementuar n\u00eb bibliotek\u00ebn libpq. Versioni i kaluar i protokollit u l\u00ebshua n\u00eb PostgreSQL 7.4 (2003). N\u00eb bibliotek\u00ebn libpq vazhdon t\u00eb p\u00ebrdoret versioni 3.0 si default. <\/ul>\n