{"id":119954,"date":"2024-09-26T21:43:01","date_gmt":"2024-09-26T19:43:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-17"},"modified":"2024-09-26T21:43:01","modified_gmt":"2024-09-26T19:43:01","slug":"reliz-subd-postgresql-17","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/reliz-subd-postgresql-17","title":{"rendered":"L\u00ebshimi i DBMS PostgreSQL 17","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Pas nj\u00eb viti zhvillimi, \u00ebsht\u00eb publikuar dega e re stabile e DBMS PostgreSQL 17. P\u00ebrdit\u00ebsimet p\u00ebr deg\u00ebn e re do t\u00eb publikohen p\u00ebr pes\u00eb vjet deri n\u00eb n\u00ebntor 2029. Mb\u00ebshtetja p\u00ebr PostgreSQL 12.x, deg\u00ebn m\u00eb t\u00eb vjet\u00ebr p\u00ebrkat\u00ebse, do t\u00eb p\u00ebrfundoj\u00eb m\u00eb 14 n\u00ebntor. <\/p>\n
Novitetet kryesore: <\/p>\n
\n
Gjat\u00eb kryerjes s\u00eb operacionit VACUUM (mbledhja e mbeturinave, pastrimi dhe paketimi i ruajtjes s\u00eb disks) \u00ebsht\u00eb angazhuar nj\u00eb struktur\u00eb t\u00eb dh\u00ebnash e re q\u00eb konsumon deri n\u00eb 20 her\u00eb m\u00eb pak memorie. Kalimi n\u00eb struktur\u00ebn e re ka lejuar t\u00eb shpejtoj\u00eb kryerjen e operacioneve VACUUM dhe t\u00eb zvog\u00ebloj\u00eb konsumimin e burimeve t\u00eb ndara.\n
Ka vazhduar optimizimi i performanc\u00ebs s\u00eb hyrjes\/daljes. Fal\u00eb p\u00ebrmir\u00ebsimit t\u00eb kodit p\u00ebr p\u00ebrpunimin e logut t\u00eb shkruar t\u00eb vonuar WAL, \u00ebsht\u00eb arritur t\u00eb dyfishohet kapaciteti i operacioneve t\u00eb shkruar n\u00eb sisteme me nj\u00eb num\u00ebr t\u00eb madh k\u00ebrkesash q\u00eb ekzekutohen nj\u00ebkoh\u00ebsisht. \u00cbsht\u00eb propozuar nj\u00eb nd\u00ebrfaqe e re p\u00ebr hyrje\/dalje t\u00eb rrjedhsh\u00ebm q\u00eb ka lejuar rritjen e shpejt\u00ebsis\u00eb s\u00eb skanimit t\u00eb t\u00eb dh\u00ebnave n\u00eb tabela dhe \u00ebsht\u00eb p\u00ebrshpejtuar p\u00ebrdit\u00ebsimi i statistikave p\u00ebr planifikuesin e k\u00ebrkesave pas ekzekutimit t\u00eb operacionit ANALYZE.\n
P\u00ebrmir\u00ebsimi i performanc\u00ebs s\u00eb k\u00ebrkesave me shprehjen «IN», kur ato p\u00ebrdoren indekse mbi struktur\u00ebn B-tree. \u00cbsht\u00eb realizuar mund\u00ebsia p\u00ebr nd\u00ebrtimin paralel t\u00eb indekseve BRIN (Block Range Index). N\u00eb planifikuesin e k\u00ebrkesave jan\u00eb optimizuar kontrollet «NOT NULL» dhe \u00ebsht\u00eb p\u00ebrshpejtuar p\u00ebrpunimi i shprehjeve t\u00eb tabelave t\u00eb p\u00ebrgjithshme (Common Table Expression, CTE) t\u00eb p\u00ebrcaktuara me komand\u00ebn SQL «WITH». \u00cbsht\u00eb siguruar p\u00ebrdorimi i instrukcioneve t\u00eb procesor\u00ebve vektor\u00eb (SIMD) p\u00ebr t\u00eb p\u00ebrshpejtuar disa llogaritje, p\u00ebr shembull, p\u00ebrshpejtimi i funksionit bit_count p\u00ebrdor instrukcione AVX-512.\n
\u00cbsht\u00eb realizuar mb\u00ebshtetje p\u00ebr mund\u00ebsi t\u00eb reja p\u00ebr pun\u00ebn me formatin JSON, t\u00eb p\u00ebrcaktuara n\u00eb standardin SQL\/JSON. \u00cbsht\u00eb shtuar funksioni JSON-TABLE p\u00ebr t\u00eb transformuar t\u00eb dh\u00ebnat nga formati JSON n\u00eb tabela t\u00eb zakonshme PostgreSQL, si dhe operator\u00eb t\u00eb rinj jsonpath p\u00ebr t\u00eb transformuar t\u00eb dh\u00ebnat JSON n\u00eb llojet e t\u00eb dh\u00ebnave native p\u00ebr PostgreSQL. Jan\u00eb propozuar funksione t\u00eb reja p\u00ebr krijimin (JSON, JSON_SCALAR dhe JSON_SERIALIZE) dhe k\u00ebrkimin (JSON_EXISTS, JSON_QUERY dhe JSON_VALUE) e t\u00eb dh\u00ebnave n\u00eb formatin JSON.\n
Jan\u00eb zgjeruar mund\u00ebsit\u00eb e komand\u00ebs SQL «MERGE», e cila lejon krijimin e shprehjeve SQL kushtezuese, duke bashkuar n\u00eb nj\u00eb shprehje operacionet INSERT, UPDATE dhe DELETE. \u00cbsht\u00eb shtuar mb\u00ebshtetje p\u00ebr shprehjen RETURNING, e cila lejon llogaritjen dhe kthimin e vlerave bazuar n\u00eb rreshtat e shtuar, t\u00eb p\u00ebrdit\u00ebsuar ose t\u00eb fshir\u00eb. \u00cbsht\u00eb realizuar mb\u00ebshtetje p\u00ebr p\u00ebrdit\u00ebsimin e pamjeve.\n
Aft\u00ebsit\u00eb e ngarkimit dhe eksportit t\u00eb t\u00eb dh\u00ebnave n\u00eb modin me grup jan\u00eb zgjeruar. N\u00eb komand\u00ebn COPY, shpejt\u00ebsia e eksportit t\u00eb rreshtave t\u00eb m\u00ebdhenj \u00ebsht\u00eb dyfishuar, \u00ebsht\u00eb optimizuar kopjimi kur p\u00ebrputhen kodet burimore dhe ato t\u00eb destinacionit, si dhe \u00ebsht\u00eb shtuar opsioni ON_ERROR, q\u00eb lejon vazhdimin e imaportit pas gabimeve gjat\u00eb futjes s\u00eb t\u00eb dh\u00ebnave.\n
P\u00ebr tabelat e ndara \u00ebsht\u00eb shtuar mund\u00ebsia e p\u00ebrdorimit t\u00eb kolonave me identifikues unik\u00eb dhe mb\u00ebshtetje p\u00ebr teknik\u00ebn e optimizimit t\u00eb k\u00ebrkesave «Constraint exclusion».\n
N\u00eb mekanizmin e lidhjes s\u00eb tabelave t\u00eb jashtme Foreign Data Wrapper (postgres_fdw) \u00ebsht\u00eb realizuar mund\u00ebsia e transmetimit n\u00eb jasht\u00eb server<\/a> n\u00ebnk\u00ebrkesat «EXISTS» dhe «IN.\n