{"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\/news\/reliz-subd-postgresql-18","title":{"rendered":"L\u00ebshimi i DBMS PostgreSQL 18","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Pas nj\u00eb vit zhvillimi, \u00ebsht\u00eb publikuar dega e re stabile e sistemit t\u00eb menaxhimit t\u00eb bazave t\u00eb dh\u00ebnash PostgreSQL 18. P\u00ebrdit\u00ebsimet p\u00ebr degen e re do t\u00eb dalin p\u00ebr pes\u00eb vitet e ardhshme deri n\u00eb n\u00ebntor 2030. Mb\u00ebshtetja p\u00ebr PostgreSQL 13.x, dega m\u00eb e vjet\u00ebr e mb\u00ebshtetur, do t\u00eb p\u00ebrfundoj\u00eb m\u00eb 13 n\u00ebntor.     <\/p>\n<p>Novitetet kryesore:  <\/p>\n<ul>\n<li class=\"l\"> \u00cbsht\u00eb shtuar n\u00ebn-sistemi p\u00ebr hyrje \/ dalje asinkrone, i cili lejon rritjen e kapacitetit t\u00eb hyrjes \/ daljes dhe eliminimin e vonesave. P\u00ebrve\u00e7 zbatimit univers t\u00eb AIO (io_method=worker) i cili \u00ebsht\u00eb n\u00eb dispozicion n\u00eb t\u00eb gjitha platformat, i bazuar n\u00eb ekzekutimin e disa proceseve p\u00ebrpunuese (default 3), n\u00eb Linux mund t\u00eb aplikohet nd\u00ebrfaqja p\u00ebr hyrje \/ dalje asinkrone io_uring (io_method=io_uring), e mb\u00ebshtetur q\u00eb nga b\u00ebrthama Linux 5.1. Hyrje \/ dalje asinkrone aktualisht p\u00ebrdoret vet\u00ebm p\u00ebr t\u00eb aceleruar kryerjen e disa operacioneve q\u00eb lidhen me leximin e t\u00eb dh\u00ebnave nga sistema i skedar\u00ebve, si skanimi sekuencial, skanimi i hart\u00ebs s\u00eb indekseve dhe procesi i pastrimit (vacuum). N\u00eb disa teste, p\u00ebrdorimi i AIO \u00e7on n\u00eb rritjen e performanc\u00ebs deri n\u00eb 2-3 her\u00eb. Operacionet e shkruar vazhdojn\u00eb t\u00eb kryhen n\u00eb m\u00ebnyr\u00eb sinkrone p\u00ebr t\u00eb arritur k\u00ebrkesat ACID.\n<li class=\"l\"> \u00cbsht\u00eb realizuar optimizimi 'skip scan' n\u00eb indekset me shum\u00eb kolona, duke mund\u00ebsuar q\u00eb indeksi t\u00eb p\u00ebrdoret jo vet\u00ebm p\u00ebr verifikimin e kolon\u00ebs s\u00eb par\u00eb t\u00eb indeksuar dhe lidhjen e plot\u00eb t\u00eb kolonave, por edhe p\u00ebr trajtimin ndaras t\u00eb kolonave t\u00eb tjera t\u00eb indeksuara. P\u00ebr shembull, m\u00eb par\u00eb, kur krijohej indeksi B-tree mbi kolonat '(status, date)', indeksi aplikohej vet\u00ebm p\u00ebr k\u00ebrkesat q\u00eb kontrollonin fush\u00ebn 'status' ose t\u00eb dy fushat 'status' dhe 'date', nd\u00ebrsa kur kontrollohej vet\u00ebm fusha 'date', k\u00ebrkohej p\u00ebrmbajtja e tabel\u00ebs. Rezhimi 'skip scan' lejon, n\u00eb disa raste, q\u00eb indeksi t\u00eb skanohet kur kontrollohet vet\u00ebm fusha 'date'. Ky mod p\u00ebrdoret vet\u00ebm p\u00ebr indekset 'B-tree' kur p\u00ebrdoret nj\u00eb operator kushtor '=' mbi fush\u00ebn e indeksuar, n\u00eb situata kur fusha e humbur ka nj\u00eb num\u00ebr t\u00eb vog\u00ebl vlerash t\u00eb ndryshme (p\u00ebr shembull, optimizimi do t\u00eb jet\u00eb efektiv n\u00ebse fusha status 'status' ka disa vlera fikse).\n<li class=\"l\"> Shtesa optimizimeve q\u00eb p\u00ebrdorin m\u00eb efektiv indekset p\u00ebr pyetje q\u00eb p\u00ebrmbajn\u00eb struktura \u00abOR\u00bb dhe \u00abIN (...)\u00bb n\u00eb bllokun \u00abWHERE\u00bb, si dhe rritja e performanc\u00ebs s\u00eb planifikimit dhe ekzekutimit t\u00eb bashkimeve t\u00eb tabelave (p\u00ebr shembull, \u00ebsht\u00eb p\u00ebrshpejtuar kodi i bashkimit t\u00eb hash-ave dhe lejohet p\u00ebrdorimi i renditjes inkrementale gjat\u00eb bashkimit t\u00eb tabelave).\n<li class=\"l\"> Shtuar p\u00ebrkrahjen p\u00ebr ndarjen n\u00eb m\u00ebnyr\u00eb paralele t\u00eb nd\u00ebrtimit t\u00eb indekseve GIN (Indeksi i Ngritur i P\u00ebrgjithsh\u00ebm), t\u00eb aplikuara p\u00ebr indeksonin vlera t\u00eb p\u00ebrb\u00ebr\u00eb, si\u00e7 jan\u00eb tabelat, dhe organizimin e k\u00ebrkimit n\u00eb t\u00eb dh\u00ebna tekstuale ose struktura JSON.\n<li class=\"l\"> Shtuar mund\u00ebsia p\u00ebr t\u00eb krijuar pamje materializuara dhe \u00e7el\u00ebsa p\u00ebr ndarjen e tabelave me indekse me shenj\u00ebn \u00abunique\u00bb, q\u00eb nuk p\u00ebrdorin struktur\u00ebn B-tree.\n<li class=\"l\"> Rritur performanca e p\u00ebrgjithshme e bllokimeve p\u00ebr pyetje q\u00eb punojn\u00eb me num\u00ebr t\u00eb madh tabelash, si dhe jan\u00eb b\u00ebr\u00eb p\u00ebrmir\u00ebsime n\u00eb p\u00ebrpunimin e pyetjeve p\u00ebr tabelat e ndara, duke p\u00ebrshpejtuar filt\u00ebrimin e seksioneve t\u00eb pap\u00ebrdorura dhe operacionet e bashkimit (JOIN).\n<li class=\"l\"> P\u00ebrshpejtuar operacionet me tekst, si funksionet p\u00ebrkthimi n\u00eb t\u00eb madhe\/t\u00eb vog\u00ebl. Shtuar m\u00ebnyra PG_UNICODE_FAST p\u00ebr t\u00eb p\u00ebrshpejtuar marrjen parasysh t\u00eb pronave t\u00eb lokaliteteve t\u00eb simboleve Unicode.\n<li class=\"l\"> Implementuar mund\u00ebsin\u00eb e ruajtjes s\u00eb statistikave t\u00eb planifikuesit t\u00eb pyetjeve pas azhurnimit midis lirimeve t\u00eb r\u00ebnd\u00ebsishme t\u00eb PostgreSQL. Ky ndryshim lejon shmangien e kryerjes s\u00eb operacionit t\u00eb nd\u00ebrlikuar \u00abANALYZE\u00bb pas fillimit t\u00eb versionit t\u00eb ri, deri n\u00eb p\u00ebrfundimin e t\u00eb cilit v\u00ebrehet nj\u00eb r\u00ebnie e performanc\u00ebs s\u00eb DBMS.\n<li class=\"l\"> Rritur performanca e utilitarit pg_upgrade, i cili aplikohet p\u00ebr automatizimin e kalimit n\u00eb nj\u00eb version t\u00eb ri t\u00eb r\u00ebnd\u00ebsish\u00ebm t\u00eb PostgreSQL. Optimizimet jan\u00eb sidomos t\u00eb dukshme gjat\u00eb azhurnimit t\u00eb DB, q\u00eb p\u00ebrmbajn\u00eb nj\u00eb num\u00ebr t\u00eb madhe objektesh, si\u00e7 jan\u00eb tabelat dhe sekuencat. P\u00ebr t\u00eb p\u00ebrshpejtuar pun\u00ebn e pg_upgrade \u00ebsht\u00eb shtuar gjithashtu floku \u00ab--jobs N\u00bb p\u00ebr ndarjen n\u00eb m\u00ebnyr\u00eb paralele t\u00eb verifikimeve n\u00eb N procese dhe floku \u00ab--swap\u00bb p\u00ebr t\u00eb z\u00ebvend\u00ebsuar katalog\u00ebt me t\u00eb dh\u00ebna plot\u00ebsisht pa vendosur referenca, pa kopjim dhe pa kopjuar skedar\u00ebt.\n<li class=\"l\"> Shtohet mb\u00ebshtetje p\u00ebr kolona t\u00eb gjeneruara virtuale, vlera e t\u00eb cilave llogaritet n\u00eb koh\u00eb reale gjat\u00eb ekzekutimit t\u00eb pyetjeve, pa u ruajtur n\u00eb disk. N\u00eb shprehjen \u201eCREATE TABLE\u2026\u201c p\u00ebr kolonat e gjeneruara, n\u00ebse \u00ebsht\u00eb e specifikuar vet\u00ebm fjala ky\u00e7e \u201eGENERATED\u201c pa sqarimin e llojit (STORED ose VIRTUAL), at\u00ebher\u00eb varianti i ri aplikohet si standard n\u00eb vend t\u00eb implementimit t\u00eb vjet\u00ebr. N\u00eb implementimin e vjet\u00ebr, vlerat jan\u00eb gjeneruar gjat\u00eb operacioneve \u201eINSERT\u201c ose \u201eUPDATE\u201c dhe jan\u00eb ruajtur n\u00eb disk p\u00ebr p\u00ebrdorim t\u00eb m\u00ebvonsh\u00ebm. Disavantazhi i kolonave t\u00eb gjeneruara virtuale \u00ebsht\u00eb pamund\u00ebsia p\u00ebr t'i p\u00ebrdorur ato n\u00eb indekse, nd\u00ebrsa avantazhi \u00ebsht\u00eb mund\u00ebsia p\u00ebr t\u00eb kryer normalizimin dhe modifikimin e t\u00eb dh\u00ebnave n\u00eb koh\u00eb reale (t\u00eb r\u00ebnd\u00ebsishme kur punoni me t\u00eb dh\u00ebnat JSON). Sa i p\u00ebrket kolonave t\u00eb gjeneruara t\u00eb ruajtura klasike, n\u00eb versionin e ri \u00ebsht\u00eb siguruar mb\u00ebshtetje p\u00ebr replikimin logjik.\n<li class=\"l\"> N\u00eb komandat INSERT, UPDATE, DELETE dhe MERGE \u00ebsht\u00eb realizuar mund\u00ebsia p\u00ebr t\u00eb nxjerr\u00eb vlerat e m\u00ebparshme (OLD) dhe ato aktuale (CURRENT) n\u00eb shprehjen RETURNING. P\u00ebr shembull, \u201eUPDATE\u2026 RETURNING WITH (OLD AS o, NEW AS n) o.*, n.*.\n<li class=\"l\"> Shtohet funksioni uuidv7() p\u00ebr gjenerimin e identifikuesve unik\u00eb t\u00eb rast\u00ebsish\u00ebm n\u00eb formatin UUIDv7. Ndryshe nga funksioni i vjet\u00ebr p\u00ebr gjenerimin e UUID (gen_random_uuid), i cili tani \u00ebsht\u00eb gjithashtu n\u00eb dispozicion n\u00ebn emrin uuidv4(), n\u00eb UUIDv7 p\u00ebrve\u00e7 vler\u00ebs rast\u00ebsore p\u00ebrfshihet edhe koha e gjenerimit. Prania e pjes\u00ebve t\u00eb renditura n\u00eb vler\u00ebn UUID (12 karakteret e para \u2014 koha epokale, dhe 18 t\u00eb tjerat \u2014 vler\u00eb rast\u00ebsore) rrit efektivitetin e renditjes dhe indeksonit, q\u00eb \u00ebsht\u00eb e r\u00ebnd\u00ebsishme pasi UUID zakonisht p\u00ebrdoren p\u00ebr \u00e7el\u00ebsa primar\u00eb (p.sh., \u00e7el\u00ebsat e krijuara n\u00eb koh\u00eb t\u00eb af\u00ebrt vendosen ngjitur me nj\u00ebra-tjetr\u00ebn n\u00eb indeks).\n<li class=\"l\"> N\u00eb operacionin \u201eLIKE\u201c \u00ebsht\u00eb realizuar mb\u00ebshtetje p\u00ebr p\u00ebrputhjet me tekstin, n\u00eb t\u00eb cilat p\u00ebrdoren pron\u00ebsi t\u00eb pap\u00ebrcaktuara t\u00eb lokalizimit \u201ecollation\u201c, duke lejuar realizimin e p\u00ebrputhjeve duke pasur parasysh kuptimin e simboleve (p.sh., gjat\u00eb krahasimit, mund t\u00eb mos merret parasysh shkronja e theksit). Shtohet funksioni CASEFOLD p\u00ebr t\u00eb ndryshuar regjistrin e simboleve duke pasur parasysh pron\u00ebsit\u00eb e lokalizimit \u201ecollation\u201c (p.sh., disa simbole kan\u00eb m\u00eb shum\u00eb se dy variacione t\u00eb vogla ose gjat\u00eb krahasimit k\u00ebrkohet transformimi n\u00eb shkronj\u00ebn e madhe, n\u00eb vend t\u00eb asaj t\u00eb vog\u00ebl).\n<li class=\"l\"> Shtuar mund\u00ebsia e p\u00ebrdorimit t\u00eb kufizimeve temporale (temporal constraint). N\u00eb vlerat \"PRIMARY KEY\" dhe \"UNIQUE\" p\u00ebr shtimin e kufizimeve temporale duhet t\u00eb p\u00ebrdoret shprehja \"WITHOUT OVERLAPS\", nd\u00ebrsa n\u00eb vler\u00ebn \"FOREIGN KEY\" \u2014 shprehja PERIOD. P\u00ebr shembull, kur p\u00ebrcaktohen \u00e7el\u00ebsat primar\u00eb, mund t\u00eb kufizohen \u00e7el\u00ebsat me periudha kohore q\u00eb p\u00ebrputhen.\n<li class=\"l\"> Shtuar komand\u00ebn \"CREATE FOREIGN TABLE \u2026 LIKE command\" p\u00ebr krijimin e nj\u00eb skeme tabele t\u00eb jashtme mbi baz\u00ebn e p\u00ebrkufizimit t\u00eb nj\u00eb tabele lokale.\n<li class=\"l\"> Shtuar mb\u00ebshtetje p\u00ebr lidhen n\u00eb DBMS duke p\u00ebrdorur autentifikimin me OAUTH 2.0 duke aplikuar nj\u00eb token akses n\u00eb vend t\u00eb fjal\u00ebkalimit. P\u00ebrdorimi i OAUTH lejon q\u00eb t\u00eb mos ruajm\u00eb fjal\u00ebkalimet n\u00eb DB, por t\u00eb identifikojm\u00eb p\u00ebrdoruesit p\u00ebrmes sh\u00ebrbimeve t\u00eb jashtme, si dhe t\u00eb p\u00ebrdorim mund\u00ebsi t\u00eb tilla si autentifikimi me dy faktor\u00eb dhe pika e vetme e hyrjes (SSO).\n<li class=\"l\"> Shtuar funksionin ssl_tls13_ciphers(), p\u00ebrmes t\u00eb cilit mund t\u00eb p\u00ebrcaktohet lista e algoritmeve t\u00eb enkriptimit t\u00eb lejuar p\u00ebr lidhjen duke p\u00ebrdorur protokollin TLSv1.3.\n<li class=\"l\"> Mb\u00ebshtetje p\u00ebr autentifikimin duke p\u00ebrdorur algoritmin md5 p\u00ebr hashimin e fjal\u00ebkalimeve \u00ebsht\u00eb kaluar n\u00eb kategorin\u00eb e vjetruar dhe t\u00eb planifikuar p\u00ebr heqje. N\u00eb vend t\u00eb md5, rekomandohet p\u00ebrdorimi i algoritmit SCRAM (SCRAM-SHA-256), i cili ka dal\u00eb n\u00eb PostgreSQL 10. Gjithashtu, \u00ebsht\u00eb v\u00ebn\u00eb n\u00eb dukje zbatimi i mb\u00ebshtetjes p\u00ebr p\u00ebr\u00e7imin e autentifikimit n\u00eb baz\u00eb t\u00eb SCRAM kur lidhemi p\u00ebrmes postgres_fdw dhe dblink n\u00eb servera t\u00eb jasht\u00ebm PostgreSQL.\n<li class=\"l\"> N\u00eb kryerjen e operacionit \"EXPLAIN ANALYZE\" \u00ebsht\u00eb siguruar nxjerrja e informacioneve mbi numrin e operacioneve t\u00eb k\u00ebrkimit n\u00eb indekse gjat\u00eb skanimit t\u00eb indeksit dhe numrin e thirrjeve n\u00eb bufer gjat\u00eb ekzekutimit t\u00eb k\u00ebrkes\u00ebs. N\u00eb daljen \"EXPLAIN ANALYZE VERBOSE\" \u00ebsht\u00eb p\u00ebrfshir\u00eb statistika p\u00ebr CPU, WAL-logun dhe intensitetin e operacioneve t\u00eb leximit. N\u00eb tabel\u00ebn pg_stat_all_tables jan\u00eb shtuar t\u00eb dh\u00ebna mbi koh\u00ebn e kaluar p\u00ebr operacionin VACUUM dhe analiz\u00ebn e tabelave. \u00cbsht\u00eb siguruar statistika mbi intensitetin e hyrjes\/portimit dhe ngarkes\u00ebn ndaj WAL-logut n\u00eb p\u00ebrputhje me lidhjet individuale. N\u00eb pg_stat_subscription_stats dhe n\u00eb ditar\u00ebt \u00ebsht\u00eb shtuar informacion mbi diagnostikimin e konflikteve gjat\u00eb ekzekutimit t\u00eb operacioneve t\u00eb shkrimit gjat\u00eb replikimit t\u00eb logjik\u00ebs.\n<li class=\"l\"> N\u00eb instalimet e reja \u00ebsht\u00eb aktivizuar sipas parazgjedhjes p\u00ebrdorimi i kontrolleve t\u00eb shumave p\u00ebr verifikimin e integritetit t\u00eb t\u00eb dh\u00ebnave t\u00eb ruajtura. P\u00ebr t\u00eb anuluar k\u00ebt\u00eb sjellje gjat\u00eb nisjes s\u00eb initdb duhet t\u00eb ceket opsioni \"\u2014no-data-checksums\".\n<li class=\"l\"> N\u00eb utilitarin pg_createsubscriber \u00ebsht\u00eb shtuar nj\u00eb flag &#171;&#8212;all&#187; p\u00ebr t\u00eb krijuar replika logjike me nj\u00eb komand\u00eb t\u00eb vetme p\u00ebr t\u00eb gjitha DB-t\u00eb.\n<li class=\"l\"> \u00cbsht\u00eb realizuar nj\u00eb version i ri (3.2) i protokollit, i p\u00ebrdorur p\u00ebr nd\u00ebrveprimin e mjeteve t\u00eb jashtme me DBMS-n\u00eb dhe i realizuar n\u00eb bibliotek\u00ebn libpq. P\u00ebrdit\u00ebsimi i fundit i protokollit u krye n\u00eb PostgreSQL 7.4 (viti 2003). N\u00eb bibliotek\u00ebn libpq vazhdon t\u00eb p\u00ebrdoret si version default versioni 3.0.          <\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=63877\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 18. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0443\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442\u044c \u0432 \u0442\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u044f\u0442\u0438 \u043b\u0435\u0442 \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2030 \u0433\u043e\u0434\u0430. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 PostgreSQL 13.x, \u0441\u0430\u043c\u043e\u0439 \u0441\u0442\u0430\u0440\u043e\u0439 \u0438\u0437 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a, \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430 13 \u043d\u043e\u044f\u0431\u0440\u044f. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043d\u043e\u0432\u0448\u0435\u0441\u0442\u0432\u0430: \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0434\u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0430\u0441\u0438\u043d\u0445\u0440\u043e\u043d\u043d\u043e\u0433\u043e \u0432\u0432\u043e\u0434\u0430\/\u0432\u044b\u0432\u043e\u0434\u0430, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0430\u044f \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043f\u0440\u043e\u043f\u0443\u0441\u043a\u043d\u0443\u044e \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u044c \u0432\u0432\u043e\u0434\u0430\/\u0432\u044b\u0432\u043e\u0434\u0430 \u0438 \u0438\u0437\u0431\u0430\u0432\u0438\u0442\u044c\u0441\u044f \u043e\u0442 \u0437\u0430\u0434\u0435\u0440\u0436\u0435\u043a. \u041f\u043e\u043c\u0438\u043c\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0439 \u043d\u0430 \u0432\u0441\u0435\u0445 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-144010","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.1.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 18. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0443\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442\u044c \u0432 \u0442\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u044f\u0442\u0438 \u043b\u0435\u0442 \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2030 \u0433\u043e\u0434\u0430.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/news\/reliz-subd-postgresql-18\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 PostgreSQL 18 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 18. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0443\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442\u044c \u0432 \u0442\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u044f\u0442\u0438 \u043b\u0435\u0442 \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2030 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/news\/reliz-subd-postgresql-18\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2025-09-25T15:11:55+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-09-25T15:11:55+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47L\u00ebshimi i DBMS PostgreSQL 18 | ProHoster","description":"Pas nj\u00eb vit zhvillimi, \u00ebsht\u00eb publikuar dega e re stabile e SGBD PostgreSQL 18. P\u00ebrdit\u00ebsimet p\u00ebr deg\u00ebn e re do t\u00eb dalin p\u00ebr pes\u00eb vjet deri n\u00eb n\u00ebntor 2030.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/reliz-subd-postgresql-18","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\u0420\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 PostgreSQL 18 | ProHoster","og:description":"\u041f\u043e\u0441\u043b\u0435 \u0433\u043e\u0434\u0430 \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u043a\u0438 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u0430\u044f \u0432\u0435\u0442\u043a\u0430 \u0421\u0423\u0411\u0414 PostgreSQL 18. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u043d\u043e\u0432\u043e\u0439 \u0432\u0435\u0442\u043a\u0438 \u0431\u0443\u0434\u0443\u0442 \u0432\u044b\u0445\u043e\u0434\u0438\u0442\u044c \u0432 \u0442\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u044f\u0442\u0438 \u043b\u0435\u0442 \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2030 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/reliz-subd-postgresql-18","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":"2025-09-25T15:11:55+00:00","article:modified_time":"2025-09-25T15:11:55+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"144010","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-23 14:59:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 14:59:19","updated":"2026-01-23 14:59:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/144010","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=144010"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/144010\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=144010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=144010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=144010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}