{"id":184329,"date":"2026-11-20T03:36:27","date_gmt":"2026-11-20T01:36:27","guid":{"rendered":"https:\/\/prohoster.info\/blog\/news\/reliz-subd-postgresql-19"},"modified":"2026-11-20T03:36:30","modified_gmt":"2026-11-20T01:36:30","slug":"postgresql-19-released","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/news\/postgresql-19-released","title":{"rendered":"L\u00ebshimi i DBMS PostgreSQL 19","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Pas nj\u00eb vit zhvillimi, \u00ebsht\u00eb publikuar dega e re stabile e DBMS PostgreSQL 19. P\u00ebrdit\u00ebsimet p\u00ebr deag\u00ebn e re do t\u00eb dalin p\u00ebr pes\u00eb vjet deri n\u00eb n\u00ebntor 2031. Mb\u00ebshtetje p\u00ebr PostgreSQL 14.x, dega m\u00eb e vjet\u00ebr e mb\u00ebshtetur, do t\u00eb nd\u00ebrpritet k\u00ebt\u00eb muaj. Publikimi doli pothuajse dy muaj m\u00eb von\u00eb nga data fillestare e parashikuar, p\u00ebr shkak t\u00eb nj\u00eb fluksi t\u00eb \u00e7uditsh\u00ebm mesazheve p\u00ebr gabime q\u00eb u zbuluan p\u00ebrmes analiz\u00ebs s\u00eb kodit me ndihm\u00ebn e mjeteve AI.       <\/p>\n<p>Novitetet kryesore:     <\/p>\n<ul>\n<li class=\"l\"> Implementimi i n\u00ebn-sistemit t\u00eb input\/output asinkron \u00ebsht\u00eb p\u00ebrmir\u00ebsuar, duke lejuar rritjen e kapacitetit t\u00eb input\/output dhe eliminimin e vonesave. N\u00eb implementimin universale AIO (io_method=worker) tani ka mund\u00ebsin\u00eb p\u00ebr rritjen ose zvog\u00eblimin automatik t\u00eb numrit t\u00eb proceseve p\u00ebrpunuese t\u00eb input\/output n\u00eb var\u00ebsi t\u00eb ngarkes\u00ebs. P\u00ebr t\u00eb p\u00ebrcaktuar numrin minimal dhe maksimal t\u00eb proceseve p\u00ebrpunuese, si dhe koh\u00ebn e pritjes para mbylljes dhe vones\u00ebn para nisjes s\u00eb proceseve, jan\u00eb propozuar parametrat io_min_workers, io_max_workers, io_worker_idle_timeout dhe io_worker_launch_interval.\n<p>P\u00ebrve\u00e7 k\u00ebsaj, planifikuesi i p\u00ebrparuar n\u00eb AIO \u00ebsht\u00eb optimizuar p\u00ebr t\u00eb rritur performanc\u00ebn e k\u00ebrkesave q\u00eb k\u00ebrkojn\u00eb ngarkimin e sasi t\u00eb m\u00ebdha t\u00eb t\u00eb dh\u00ebnave nga disku. Optimizimi realizohet p\u00ebrmes p\u00ebrcaktimit adaptiv t\u00eb numrit t\u00eb lejuar t\u00eb operacioneve t\u00eb leximit t\u00eb parakohsh\u00ebm, n\u00eb var\u00ebsi t\u00eb natyr\u00ebs dhe madh\u00ebsis\u00eb s\u00eb k\u00ebrkes\u00ebs (p.sh., p\u00ebr operacionet e skanimit t\u00eb tabelave dhe indekseve t\u00eb m\u00ebdha, tani ngarkohet m\u00eb shum\u00eb t\u00eb dh\u00ebna paraprakisht nga disku). P\u00ebr analiz\u00ebn e ekzekutimit t\u00eb operacioneve t\u00eb input\/output n\u00eb m\u00ebnyr\u00eb asinkrone, komand\u00ebs \u00abEXPLAIN ANALYZE\u00bb i \u00ebsht\u00eb shtuar opsioni \u00abIO\u00bb.      <\/p>\n<li class=\"l\"> Shtohen zgjerimet pg_plan_advice dhe pg_stash_advice p\u00ebr t\u00eb transmetuar planifikuesit t\u00eb k\u00ebrkesave parametrat e sugjerimeve n\u00eb mini-gjuh\u00ebn \u00abplan advice\u00bb, t\u00eb cilat lejojn\u00eb t\u00eb ndikojn\u00eb n\u00eb zgjedhjen e planeve t\u00eb ekzekutimit, t\u00eb regjistrojn\u00eb planet e zgjedhura dhe t\u00eb eksperimentojn\u00eb me plane t\u00eb ndryshme. P\u00ebr t\u00eb marr\u00eb nj\u00eb list\u00eb parametrash t\u00eb zgjedhur nga planifikuesi gjat\u00eb ekzekutimit t\u00eb k\u00ebrkes\u00ebs, komand\u00ebs EXPLAIN i \u00ebsht\u00eb shtuar opsioni \u00abPLAN_ADVICE\u00bb, nd\u00ebrsa p\u00ebr t\u00eb vendosur parametrat tuaj para ekzekutimit t\u00eb k\u00ebrkes\u00ebs, mund t\u00eb p\u00ebrdorni shprehjen \u00abSET pg_plan_advice.advice = 'string me list\u00ebn e parametrave'\u00bb. Zgjerimi pg_stash_advice plot\u00ebson pg_plan_advice me mund\u00ebsi p\u00ebr t\u00eb lidhur parametrat me identifikuesit e k\u00ebrkesave, n\u00eb m\u00ebnyr\u00eb q\u00eb t\u00eb mos i shtoni ato para \u00e7do k\u00ebrkese. EXPLAIN (COSTS OFF, PLAN_ADVICE) SELECT * FROM join_fact f JOIN join_dim d ON f.dim_id = d.id; ... Planimi i Krijuar: JOIN_ORDER(f d) HASH_JOIN(d) SEQ_SCAN(f d) NO_GATHER(f d) SET pg_plan_advice.advice = 'JOIN_ORDER(f d) NO_GATHER(f d)';\n<li class=\"l\"> N\u00eb procesin automatik t\u00eb pastrimit (autovacuum) \u00ebsht\u00eb shtuar mund\u00ebsia p\u00ebr p\u00ebrdorimin paralel t\u00eb disa trajtuesve gjat\u00eb pastrimit t\u00eb indekseve. Numri i trajtuesve konfigurohet p\u00ebrmes opsionit autovacuum_max_parallel_workers. Gjithashtu, jan\u00eb shtuar opsionet e reja autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight dhe autovacuum_analyze_score_weight p\u00ebr t\u00eb p\u00ebrcaktuar prioritetin e pastrimit t\u00eb tabelave.\n<li class=\"l\"> \u00cbsht\u00eb realizuar nj\u00eb strategji e re pastrimi, q\u00eb lejon t\u00eb zvog\u00ebloj\u00eb volumin e pun\u00ebs n\u00eb t\u00eb ardhmen, fal\u00eb p\u00ebrdit\u00ebsimit t\u00eb hart\u00ebs s\u00eb dukshm\u00ebris\u00eb s\u00eb faqeve gjat\u00eb skanimit t\u00eb tabelave kur ekzekutohen pyetje SELECT, pa pritur ekzekutimin e komand\u00ebs VACUUM.\n<li class=\"l\"> Shtohet nj\u00eb komand\u00eb e re SQL \u00abREPACK\u00bb p\u00ebr rind\u00ebrtimin e tabelave me shpenzime m\u00eb t\u00eb ul\u00ebta. Komanda REPACK e rip\u00ebrshkruan plot\u00ebsisht p\u00ebrmbajtjen e tabel\u00ebs n\u00eb nj\u00eb skedar t\u00eb ri n\u00eb disk, duke lejuar q\u00eb sistemi operativ t\u00eb kthej\u00eb hap\u00ebsir\u00ebn n\u00eb disk q\u00eb z\u00ebn\u00eb blloqet e pashfryt\u00ebzuara. Ndryshe nga komanda \u00abVACUUM FULL\u00bb, gjat\u00eb rip\u00ebrshkrimit q\u00eb vendos bllokimin e fort\u00eb, komanda REPACK ka opsionin \u00abCONCURRENTLY\u00bb, kur p\u00ebrdoret, ku lejohet p\u00ebrdorimi i tabel\u00ebs nga transaksione t\u00eb tjera gjat\u00eb rihapjes. Ndryshe nga zgjerimi pg_repack, REPACK \u00ebsht\u00eb duksh\u00ebm m\u00eb i shpejt\u00eb, pasi nuk i bashkangjit tabela shtes\u00eb trigger, por nuk mb\u00ebshtet trajtimin e tabelave t\u00eb plota t\u00eb sektor\u00ebve.\n<li class=\"l\"> Performanca e operacionit INSERT \u00ebsht\u00eb rritur deri n\u00eb dy her\u00eb p\u00ebr tabelat n\u00eb t\u00eb cilat kontrollohen regjistrat p\u00ebr ky\u00e7et e jashtme (Foreign Key). Ky p\u00ebrshpejtim \u00ebsht\u00eb arritur p\u00ebrmes p\u00ebrdorimit t\u00eb indeksit p\u00ebr kontrollimin e ky\u00e7it t\u00eb jasht\u00ebm, gj\u00eb q\u00eb ka lejuar shmangien e nj\u00eb k\u00ebrkese t\u00eb brendshme k\u00ebrkuese p\u00ebr tabel\u00ebn.\n<li class=\"l\"> Planifikuesi i pyetjeve siguron njohjen e operacioneve Anti-Join (p\u00ebrcaktimi i rreshtave nga tabela e par\u00eb, p\u00ebr t\u00eb cilat nuk ka p\u00ebrputhje n\u00eb tabel\u00ebn e dyt\u00eb) n\u00eb pyetje t\u00eb nd\u00ebrlikuara me &#171;LEFT JOIN&#187; dhe pyetje me shprehje &#171;NOT IN&#187; p\u00ebr t\u00eb angazhuar optimizime specifike. Zgjeruar p\u00ebrdorimin e renditjes inkrementale. Shtuar optimizimi &#171;eager aggregation&#187;, i cili \u00e7on operacionet e aggregimit n\u00eb nj\u00eb faz\u00eb p\u00ebrpara shkrirjes s\u00eb tabelave p\u00ebr t\u00eb reduktuar numrin e rreshtave q\u00eb trajtohen gjat\u00eb shkrirjes. Rritur ekzekutimi paralel i operacioneve t\u00eb skanimit sekondar (parallel seq scan). Realizuar reduktimi i konstruksioneve &#171;IS DISTINCT FROM&#187; dhe &#171;IS NOT DISTINCT FROM&#187; n\u00eb shprehje me operator\u00ebt &#171;&lt;&gt;&#187; dhe &#171;=&#187;, n\u00ebse t\u00eb dy operand\u00ebt nuk mund t\u00eb marrin vler\u00ebn NULL.\n<li class=\"l\"> Efikasiteti i d\u00ebrgimit t\u00eb njoftimeve \u00ebsht\u00eb rritur duke p\u00ebrdorur komand\u00ebn NOTIFY n\u00eb konfigurime me disa kanale njoftimi. Tani n\u00eb memorjen e p\u00ebrbashk\u00ebt ruhet nj\u00eb hart\u00eb kanalesh q\u00eb lejon adresimin vet\u00ebm t\u00eb backend-eve t\u00eb regjistruar n\u00eb kanalin e caktuar.\n<li class=\"l\"> N\u00eb komand\u00ebn &#171;INSERT&#187; \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr shprehjen ON CONFLICT DO SELECT &#8230; RETURNING, e cila kthen regjistrimet, n\u00eb rast t\u00eb pamund\u00ebsis\u00eb s\u00eb shtimit t\u00eb tyre n\u00ebp\u00ebrmjet &#171;INSERT&#187;, p\u00ebrve\u00e7 shprehjeve &#171;ON CONFLICT DO NOTHING\/UPDATE&#187;, t\u00eb cilat heshtazi injorojn\u00eb konfliktet gjat\u00eb shtimit ose q\u00eb p\u00ebrfundojn\u00eb me p\u00ebrdit\u00ebsim n\u00eb vend t\u00eb shtimit.\n<li class=\"l\"> Komand\u00ebs COPY i \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr daljen e t\u00eb dh\u00ebnave n\u00eb formatin JSON.\n<li class=\"l\"> N\u00eb gjuh\u00ebn SQL\/JSON jan\u00eb shtuar metoda p\u00ebr p\u00ebrpunimin e vargjeve lower(), upper(), replace(), split_part() dhe btrim().\n<li class=\"l\"> N\u00eb funksionet e dritareve lead(), lag(), first_value(), last_value() dhe nth_value() \u00ebsht\u00eb shtuar mb\u00ebshtetje p\u00ebr shprehjen &#171;IGNORE NULLS&#187; p\u00ebr t\u00eb kaluar mbi vlerat NULL.\n<li class=\"l\"> Shtuar komanda &#171;WAIT FOR LSN&#187;, e cila gjat\u00eb replikimit asinkron p\u00ebr t\u00eb parandaluar nxjerrjen e t\u00eb dh\u00ebnave t\u00eb vjetra lejon pezullimin e pyetjes SELECT n\u00eb serverin e replikimit deri sa ndryshimet nga burimi t\u00eb aplikohen. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/dts-los-angeles\/\"   title=\"server\u00eb\" data-wpil-keyword-link=\"linked\">server\u00eb<\/a>, n\u00eb p\u00ebrputhje me nj\u00eb pozicion t\u00eb caktuar LSN (Log Sequence Number) n\u00eb logun WAL.\n<li class=\"l\"> Funksioni random() ka ndihm\u00eb p\u00ebr mb\u00ebshtetje t\u00eb tipeve date dhe timestamp p\u00ebr t\u00eb gjeneruar data dhe koh\u00eb t\u00eb rast\u00ebsishme brenda nj\u00eb game t\u00eb caktuar.\n<li class=\"l\"> Shtuar mund\u00ebsia p\u00ebr t\u00eb krijuar funksione n\u00eb gjuh\u00ebn PL\/Python p\u00ebr ngjarjet (event trigger).\n<li class=\"l\"> N\u00eb pranim t\u00eb lidhjeve rrjet. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sq\/server\/\"   title=\"server\" data-wpil-keyword-link=\"linked\">server<\/a> Shtuar mb\u00ebshtetje p\u00ebr zgjerimin TLS SNI (Server Name Indication) p\u00ebr p\u00ebrdorimin e certifikatave TLS t\u00eb lidhura me emrat e hosteve q\u00eb klienti i drejtohet n\u00eb vendosjen e nj\u00eb lidhjeje t\u00eb enkriptuar mbi nj\u00eb IP adres\u00eb.\n<li class=\"l\"> Shtuar parametrin password_expiration_warning_threshold n\u00eb skedarin e konfigurimit postgresql.conf, me t\u00eb cilin mund t\u00eb konfigurohet shfaqja e nj\u00eb paralajm\u00ebrimi p\u00ebr skadimin e shpejt\u00eb t\u00eb fjal\u00ebkalimit.\n<li class=\"l\"> Paralajm\u00ebrimet p\u00ebr p\u00ebrdorimin e algoritmit MD5 gjat\u00eb autentifikimit, i cili \u00ebsht\u00eb shpallur q\u00eb \u00ebsht\u00eb i vjetruar, jan\u00eb aktivizuar si parazgjedhje. P\u00ebr t\u00eb \u00e7aktivizuar k\u00ebto paralajm\u00ebrime, \u00ebsht\u00eb shtuar parametri md5_password_warnings.\n<li class=\"l\"> Shtuar pamjet: &#171;pg_stat_lock&#187; p\u00ebr t\u00eb shikuar statistikat e grumbulluara mbi bllokimet n\u00eb lidhje me llojet e bllokimeve; &#171;pg_stat_recovery&#187; p\u00ebr t\u00eb marr\u00eb informacion mbi gjendjen e operacioneve t\u00eb rikuperimit; &#171;pg_stat_autovacuum_scores&#187; p\u00ebr t\u00eb p\u00ebrcaktuar prioritetin e trajtimit t\u00eb tabelave n\u00eb autovacuum. N\u00eb shum\u00eb pamje sistemike \u00ebsht\u00eb shtuar kolona &#171;stats_reset&#187;, e cila tregon koh\u00ebn e fundit t\u00eb pastrimit t\u00eb num\u00ebruesve. N\u00eb pamjet &#171;pg_stat_progress_vacuum&#187; dhe &#171;pg_stat_progress_analyze&#187; \u00ebsht\u00eb shtuar kolona &#171;started_by&#187;, e cila tregon iniciatorin e operacionit. N\u00eb pamjen pg_stat_progress_vacuum \u00ebsht\u00eb shtuar kolona &#171;mode&#187;, e cila reflekton modin e p\u00ebrdorur p\u00ebr pastrimin.\n<li class=\"l\"> Shtuar mund\u00ebsia p\u00ebr t\u00eb p\u00ebrcaktuar nivelet minimale t\u00eb informueshm\u00ebris\u00eb s\u00eb log\u00ebve (log_min_messages) n\u00eb lidhje me llojet e proceseve.\n<li class=\"l\"> N\u00eb statistik\u00ebn q\u00eb shfaqet pas operacioneve VACUUM dhe ANALYZE, si dhe n\u00eb p\u00ebrfaq\u00ebsimin &#171;pg_stat_wal&#187;, jan\u00eb shtuar informacione mbi madh\u00ebsin\u00eb e faqeve t\u00eb plota t\u00eb shkruara n\u00eb log-un WAL, \u00e7ka leht\u00ebson analizimin e arsyeve t\u00eb rritjes s\u00eb tepruar t\u00eb log-ut WAL (mund t\u00eb kuptohet n\u00ebse rritja \u00ebsht\u00eb e lidhur me p\u00ebrdorimin e parametrave full_page_writes).\n<li class=\"l\"> N\u00eb mekanizmin e replikimit logjik \u00ebsht\u00eb implementuar mb\u00ebshtetje p\u00ebr replikimin e vlerave t\u00eb sekuencave (SEQUENCE), t\u00eb cilat mund t\u00eb publikohen me komand\u00ebn &#171;CREATE PUBLICATION&#187; duke p\u00ebrdorur shprehjen &#171;FOR ALL SEQUENCES&#187;.\n<li class=\"l\"> \u00cbsht\u00eb shtuar sintaksa &#171;CREATE PUBLICATION &#8230; EXCEPT&#187; p\u00ebr replikimin e t\u00eb gjitha tabelave me p\u00ebrjashtim t\u00eb atyre q\u00eb jan\u00eb t\u00eb caktuara qart\u00eb.\n<li class=\"l\"> \u00cbsht\u00eb shtuar shprehja &#171;CREATE SUBSCRIPTION &#8230; SERVER&#187;, q\u00eb lejon krijimin e abonimeve t\u00eb replikimit logjik duke marr\u00eb parametrat e lidhjes nga nj\u00eb server tjet\u00ebr.\n<li class=\"l\"> \u00cbsht\u00eb shtuar mund\u00ebsia e aktivizimit t\u00eb replikimit logjik n\u00eb fluks pa e rindezur serverin, edhe n\u00ebse parameteri &#171;wal_level&#187; \u00ebsht\u00eb caktuar n\u00eb vler\u00ebn &#171;replica&#187; n\u00eb vend t\u00eb &#171;logical&#187;. P\u00ebr t\u00eb p\u00ebrcaktuar nivelin real t\u00eb regjistrimit, i cili nuk \u00ebsht\u00eb i lidhur me cil\u00ebsimin wal_level n\u00eb skedarin e konfigurimit, \u00ebsht\u00eb shtuar parameteri &#171;effective_wal_level&#187;.\n<li class=\"l\"> N\u00eb mekanizmin e lidhjes p\u00ebr tabela t\u00eb jashtme Foreign Data Wrapper (postgres_fdw) jan\u00eb realizuar mund\u00ebsi p\u00ebr kalimin e operacioneve me vargje n\u00eb serverin e larg\u00ebt dhe \u00ebsht\u00eb shtuar opsioni import_stats p\u00ebr importimin e statistikave p\u00ebr tabelat nga nj\u00eb server i jasht\u00ebm gjat\u00eb ekzekutimit t\u00eb komand\u00ebs ANALYZE p\u00ebr t\u00eb rritur efikasitetin e planifikimit lokal t\u00eb ekzekutimit t\u00eb pyetjeve.\n<li class=\"l\"> P\u00ebr default, JIT-kompilimi \u00ebsht\u00eb \u00e7aktivizuar pasi p\u00ebrfitimi i duksh\u00ebm n\u00eb performanc\u00eb e tij jepet kryesisht p\u00ebr k\u00ebrkesa t\u00eb r\u00ebnda analitike, nd\u00ebrsa n\u00eb ngarkesat normale OLTP mund t\u00eb sjell\u00eb r\u00ebnie t\u00eb performanc\u00ebs p\u00ebr shkak t\u00eb gabimeve n\u00eb parashikimin e burimeve t\u00eb nevojshme p\u00ebr ekzekutimin e pyetjeve.\n<li class=\"l\">  P\u00ebr t\u00eb p\u00ebrmir\u00ebsuar performanc\u00ebn e kompresimit dhe \u00e7kompresimit t\u00eb tabelave TOAST, parameteri &#171;default_toast_compression&#187; \u00ebsht\u00eb caktuar n\u00eb vler\u00ebn &#171;lz4&#187;.\n<li class=\"l\"> K\u00ebtu \u00ebsht\u00eb hequr mb\u00ebshtetja p\u00ebr autentikimin duke p\u00ebrdorur protokollin RADIUS.\n<li class=\"l\"> N\u00eb komand\u00ebn &#171;vacuumdb &#8212;analyze-only&#187; \u00ebsht\u00eb aktivizuar analizimi i tabelave t\u00eb sektinuara si parazgjedhje.<\/ul>\n<p>P\u00ebr shkak t\u00eb problemeve t\u00eb evidentuara n\u00eb faz\u00ebn p\u00ebrfundimtare t\u00eb testimit, disa funksionalitete q\u00eb ishin paraqitur n\u00eb versionin beta nuk u p\u00ebrfshin\u00eb n\u00eb l\u00ebshimin p\u00ebrfundimtar, si sintaksa &#171;GROUP BY ALL&#187;, mb\u00ebshtetje p\u00ebr formate jo-tekstuale t\u00eb daljes n\u00eb pg_dumpall, SQL\/PGQ p\u00ebr pyetje grafike, aktivizimi n\u00eb fluks i mb\u00ebshtetjes p\u00ebr funksione kontrolli pa e rindezur dhe pa e ri-inicializuar, shprehja &#171;FOR PORTION OF&#187; n\u00eb UPDATE dhe DELETE, shprehjet &#171;ALTER TABLE &#8230; MERGE PARTITIONS&#187; dhe &#171;ALTER TABLE &#8230; SPLIT PARTITIONS&#187; p\u00ebr reorganizimin e tabelave t\u00eb sektinuara, caktimi i LC_COLLATE n\u00eb vler\u00ebn &#171;C&#187; p\u00ebr procesin postmaster dhe funksionet e reja pg_get_role_ddl(), pg_get_tablespace_ddl() dhe pg_get_database_ddl(). Sponsor i lajmit \u00ebsht\u00eb kompania Hi-Kvadrat, zhvilluese e platform\u00ebs Low Code XSQUARE n\u00eb PostgreSQL (reklama, LLC &#171;Hi-Kvadrat&#187;, INN 7718990614).<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=66693\">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 19. \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 2031 \u0433\u043e\u0434\u0430. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 PostgreSQL 14.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, \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430 \u0432 \u044d\u0442\u043e\u043c \u043c\u0435\u0441\u044f\u0446\u0435. \u0420\u0435\u043b\u0438\u0437 \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d \u043f\u043e\u0447\u0442\u0438 \u043d\u0430 \u0434\u0432\u0430 \u043c\u0435\u0441\u044f\u0446\u0430 \u043f\u043e\u0437\u0434\u043d\u0435\u0435 \u0438\u0437\u043d\u0430\u0447\u0430\u043b\u044c\u043d\u043e \u043d\u0430\u043c\u0435\u0447\u0435\u043d\u043d\u043e\u0439 \u0434\u0430\u0442\u044b \u0438\u0437-\u0437\u0430 \u043d\u0435\u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0435\u043d\u043d\u043e\u0433\u043e \u043f\u0440\u043e\u0448\u043b\u044b\u043c \u0432\u044b\u043f\u0443\u0441\u043a\u0430\u043c \u043f\u043e\u0442\u043e\u043a\u0430 \u0441\u043e\u043e\u0431\u0449\u0435\u043d\u0438\u0439 \u043e\u0431 \u043e\u0448\u0438\u0431\u043a\u0430\u0445, \u0432\u044b\u044f\u0432\u043b\u0435\u043d\u043d\u044b\u0445 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-184329","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.5.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 19. \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 2031 \u0433\u043e\u0434\u0430.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Alexander Kovalev\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/news\/postgresql-19-released\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.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 19 | 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 19. \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 2031 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/news\/postgresql-19-released\" \/>\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=\"2026-11-20T01:36:27+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-11-20T01:36:30+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Rilizi i SGBD PostgreSQL 19 | ProHoster","description":"Pas nj\u00eb viti zhvillimi, \u00ebsht\u00eb botuar dega e re stabile e DBMS PostgreSQL 19. P\u00ebrdit\u00ebsimet p\u00ebr deg\u00ebn e re do t\u00eb dalin p\u00ebr pes\u00eb vjet deri n\u00eb n\u00ebntor 2031.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/postgresql-19-released","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 19 | 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 19. \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 2031 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/postgresql-19-released","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":"2026-11-20T01:36:27+00:00","article:modified_time":"2026-11-20T01:36:30+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/184329","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=184329"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/184329\/revisions"}],"predecessor-version":[{"id":184330,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/184329\/revisions\/184330"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=184329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=184329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=184329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}