{"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\/lv\/blog\/news\/postgresql-19-released","title":{"rendered":"PostgreSQL 19 versijas izlai\u0161ana","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>P\u0113c gada izstr\u0101des public\u0113ta jauna stabil\u0101 PostgreSQL 19 datu b\u0101zes versija. Jaunajai versijai atjaunin\u0101jumi tiks izlaisti piecus gadus l\u012bdz 2031. gada novembrim. Atbalsts PostgreSQL 14.x, pa\u0161laik vec\u0101kajai atbalst\u012btajai versijai, beidzas \u0161om\u0113nes. Izlai\u0161ana notika gandr\u012bz divus m\u0113ne\u0161us v\u0113l\u0101k nek\u0101 s\u0101kotn\u0113ji pl\u0101nots, zemo k\u013c\u016bdu zi\u0146ojumu pl\u016bsmas d\u0113\u013c, ko izrais\u012bja koda anal\u012bze, izmantojot AI r\u012bkus.       <\/p>\n<p>Galven\u0101s jaunin\u0101jumi:     <\/p>\n<ul>\n<li class=\"l\"> Uzlabota asinkr\u012bnas ievades\/izvades apak\u0161sist\u0113mas izpilde, kas \u013cauj palielin\u0101t ievades\/izvades caurlaidsp\u0113ju un nov\u0113rst aizkavi. Univers\u0101laj\u0101 AIO (io_method=worker) realiz\u0101cij\u0101 ir pievienota iesp\u0113ja autom\u0101tiski palielin\u0101t vai samazin\u0101t akt\u012bvo ievades\/izvades apstr\u0101d\u0101t\u0101ju procesu skaitu atkar\u012bb\u0101 no slodzes. Lai noteiktu minim\u0101lo un maksim\u0101lo apstr\u0101d\u0101t\u0101ju procesu skaitu, k\u0101 ar\u012b neaktivit\u0101tes laiku pirms izbeig\u0161anas un aizkavi pirms procesu uzs\u0101k\u0161anas, pied\u0101v\u0101ti parametri io_min_workers, io_max_workers, io_worker_idle_timeout un io_worker_launch_interval.\n<p>Turkl\u0101t AIO izmantot\u0101 pirmslas\u012b\u0161anas pl\u0101not\u0101ja optimiz\u0101cija ir v\u0113rsta uz piepras\u012bjumu, kas prasa lielu datu apjomu iel\u0101di no diska, veiktsp\u0113jas paaugstin\u0101\u0161anu. Optimiz\u0101cija tiek \u012bstenota, piel\u0101gojot pie\u013caujamo pirmslas\u012b\u0161anas oper\u0101ciju skaitu atkar\u012bb\u0101 no piepras\u012bjuma rakstura un apjoma (piem\u0113ram, lielo tabulu un indeksu sken\u0113\u0161anas oper\u0101cij\u0101m tagad iepriek\u0161 tiek iel\u0101d\u0113ts no diska vair\u0101k datu). Lai analiz\u0113tu ievade\/izvade oper\u0101ciju izpildi asinhron\u0101 re\u017e\u012bm\u0101, komandai &#171;EXPLAIN ANALYZE&#187; pievienota opcija &#171;IO&#187;.      <\/p>\n<li class=\"l\"> Ir pievienoti papla\u0161in\u0101jumi pg_plan_advice un pg_stash_advice, lai nodotu pl\u0101not\u0101jam piepras\u012bjumu parametrus-ieseju mini valod\u0101 &#171;plan advice&#187;, kas \u013cauj ietekm\u0113t izpildes pl\u0101nu izv\u0113li, fiks\u0113t izv\u0113l\u0113tos pl\u0101nus un eksperiment\u0113t ar da\u017e\u0101diem pl\u0101niem. Lai ieg\u016btu sarakstu ar parametriem, ko pl\u0101not\u0101js izv\u0113las izpildes laik\u0101, komandai EXPLAIN pievienota opcija &#171;PLAN_ADVICE&#187;, bet lai iestat\u012btu savus parametrus pirms piepras\u012bjuma izpildes, var izmantot izteiksmi &#171;SET pg_plan_advice.advice = &#8216;parametru saraksta rinda'&#187;. Papla\u0161in\u0101jums pg_stash_advice papildina pg_plan_advice ar iesp\u0113j\u0101m, lai piesaist\u012btu parametrus piepras\u012bjumu identifikatoriem, lai tos neb\u016btu j\u0101ievada pirms katra piepras\u012bjuma.       EXPLAIN (COSTS OFF, PLAN_ADVICE) SELECT * FROM join_fact f JOIN join_dim d ON f.dim_id = d.id;     &#8230;     Rad\u012bt\u0101 pl\u0101na ieteikums:        JOIN_ORDER(f d)        HASH_JOIN(d)        SEQ_SCAN(f d)        NO_GATHER(f d)       SET pg_plan_advice.advice = &#8216;JOIN_ORDER(f d) NO_GATHER(f d)&#8217;;\n<li class=\"l\"> Autom\u0101tisk\u0101s t\u012br\u012b\u0161anas (autovacuum) proces\u0101 ir pievienota iesp\u0113ja paral\u0113li izmantot vair\u0101kus apstr\u0101d\u0101t\u0101jus indeksu t\u012br\u012b\u0161anas izpildes laik\u0101. Apstr\u0101d\u0101t\u0101ju skaitu var konfigur\u0113t, izmantojot opciju autovacuum_max_parallel_workers. T\u0101pat ir pievienotas jaunas opcijas autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight un autovacuum_analyze_score_weight, lai noteiktu tabulu t\u012br\u012b\u0161anas priorit\u0101ti.\n<li class=\"l\"> Ieviesta jauna t\u012br\u012b\u0161anas strat\u0113\u0123ija, kas \u013cauj samazin\u0101t n\u0101kotnes darba apjomu, atjauninot lapu redzam\u012bbas karti tabulu sken\u0113\u0161anas laik\u0101 SELECT vaic\u0101jumu izpildes laik\u0101, negaidot VACUUM komandas izpildi.\n<li class=\"l\"> Jauna SQL komanda &#171;REPACK&#187; ir pievienota tabulu p\u0101rb\u016bvei ar maz\u0101kiem izdevumiem. Komanda REPACK piln\u012bb\u0101 p\u0101rraksta visu tabulas saturu jaun\u0101 fail\u0101 uz diska, kas \u013cauj oper\u0113t\u0101jsist\u0113mai atg\u016bt diska vietu, ko aiz\u0146em neizmantotie bloki. At\u0161\u0137ir\u012bb\u0101 no komandas &#171;VACUUM FULL&#187;, kas pieprasa stingru blo\u0137\u0113\u0161anu laik\u0101, kam\u0113r notiek p\u0101rrakst\u012b\u0161ana, komandai REPACK ir opcija &#171;CONCURRENTLY&#187;, kuras nor\u0101d\u012b\u0161ana \u013cauj citiem dar\u012bjumiem izmantot tabulu p\u0101repras\u012b\u0161anas laik\u0101. At\u0161\u0137ir\u012bb\u0101 no papla\u0161in\u0101juma pg_repack, REPACK ir iev\u0113rojami \u0101tr\u0101k, jo nepievieno papildu trigera tabulai, ta\u010du neatbalsta piln\u012bb\u0101 sektion\u0113to tabulu apstr\u0101di.\n<li class=\"l\"> Iev\u0113rojami palielin\u0101ta INSERT oper\u0101ciju veiktsp\u0113ja tabul\u0101s, kur\u0101s notiek ierakstu p\u0101rbaude p\u0113c \u0101r\u0113jiem atsl\u0113gas (Foreign Key). \u0145emot v\u0113r\u0101 indeksu izmanto\u0161anu \u0101r\u0113j\u0101s atsl\u0113gas p\u0101rbaudei, izdevies izvair\u012bties no resursu pras\u012bga iek\u0161\u0113j\u0101 piepras\u012bjuma izpildes tabul\u0101.\n<li class=\"l\"> Vaic\u0101jumu pl\u0101not\u0101j\u0101 ir \u012bstenota anti-junk (rindas no pirm\u0101s tabulas, kur\u0101m nav atbilst\u012bbu otraj\u0101 tabul\u0101) oper\u0101ciju atpaz\u012b\u0161ana sare\u017e\u0123\u012btajos vaic\u0101jumos ar 'LEFT JOIN' un vaic\u0101jumos ar izteiksm\u0113m 'NOT IN', lai aktiviz\u0113tu specifiskas optimiz\u0101cijas. Ir papla\u0161in\u0101ta inkrimentu \u0161\u0137iro\u0161anas izmanto\u0161ana. Ir pievienota 'eager aggregation' optimiz\u0101cija, kas p\u0101rnes agreg\u0113\u0161anas oper\u0101cijas uz posmu pirms tabulu apvieno\u0161anas, lai samazin\u0101tu apstr\u0101d\u0101to rindu skaitu apvieno\u0161anas laik\u0101. Ir pa\u0101trin\u0101ta paral\u0113l\u0101 sec\u012bgas sken\u0113\u0161anas izpilde (parallel seq scan). Ir \u012bstenota konstrukciju 'IS DISTINCT FROM' un 'IS NOT DISTINCT FROM' samazin\u0101\u0161ana l\u012bdz izteiksm\u0113m ar operatoriem '' un '=', ja abi operandus nevar \u0146emt par NULL.\n<li class=\"l\"> Uzlabota pazi\u0146ojumu pieg\u0101des efektivit\u0101te, izmantojot NOTIFY komandu konfigur\u0101cij\u0101s ar vair\u0101kiem pazi\u0146ojumu kan\u0101liem. Kop\u012bgaj\u0101 atmi\u0146\u0101 tagad tiek saglab\u0101ta kan\u0101lu karte, kas \u013cauj adres\u0113t tikai tos backend, kas ir parakst\u012bti uz konkr\u0113to kan\u0101lu.\n<li class=\"l\"> INSERT komand\u0101 ir pievienota atbalsta izteiksmei ON CONFLICT DO SELECT \u2026 RETURNING, kas atgrie\u017e ierakstus gad\u012bjum\u0101, ja tos nav iesp\u0113jams pievienot, papildus izteiksm\u0113m 'ON CONFLICT DO NOTHING\/UPDATE', kas klus\u0113jot ignor\u0113 konfliktus ievieto\u0161anas laik\u0101 vai veic atjaunin\u0101\u0161anu, nevis ievieto\u0161anu.\n<li class=\"l\"> COPY komand\u0101 pievienota atbalsts datu izvadei JSON form\u0101t\u0101.\n<li class=\"l\"> SQL\/JSON valod\u0101 pievienotas virk\u0146u apstr\u0101des metodes lower(), upper(), replace(), split_part() un btrim().\n<li class=\"l\"> Loga funkcij\u0101s lead(), lag(), first_value(), last_value() un nth_value() ir pievienota atbalsta izteiksmei 'IGNORE NULLS', lai izlaistu NULL v\u0113rt\u012bbas.\n<li class=\"l\"> Ir pievienota komanda 'WAIT FOR LSN', kas, izmantojot asinkronu replik\u0101ciju, nov\u0113r\u0161 novecoju\u0161u datu izn\u0101k\u0161anu, \u013caujot aptur\u0113t SELECT vaic\u0101jumu replik\u0113taj\u0101 server\u012b l\u012bdz br\u012bdim, kad izmai\u0146as no galven\u0101 servera ir piem\u0113rotas. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/lv\/server\/dts-los-angeles\/\"   title=\"serveris\" data-wpil-keyword-link=\"linked\">serveris<\/a>, kas atbilst noteiktai LSN poz\u012bcijai (Log Sequence Number) WAL \u017eurn\u0101l\u0101.\n<li class=\"l\"> Funkcij\u0101 random() pievienota date un timestamp tipu atbalsta iesp\u0113ja, \u013caujot \u0123ener\u0113t nejau\u0161as datumu un laiku v\u0113rt\u012bbas noteikt\u0101 diapazon\u0101.\n<li class=\"l\"> Pievienota iesp\u0113ja PL\/Python valod\u0101 veidot funkcijas notikumu trigeriem (event trigger).\n<li class=\"l\"> pievienots t\u012bkla savienojumu pie\u0146em\u0161ana <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/lv\/server\/\"   title=\"servera\" data-wpil-keyword-link=\"linked\">servera<\/a> pievienots TLS papla\u0161in\u0101juma SNI (Server Name Indication) atbalsts, lai izmantotu TLS sertifik\u0101tus, saistot tos ar viesu v\u0101rdiem, ar kuriem klients izveido \u0161ifr\u0113tu savienojumu, izmantojot vienu IP adresi.\n<li class=\"l\"> Konfigur\u0101cijas fail\u0101 postgresql.conf pievienots parametrs password_expiration_warning_threshold, ar kura pal\u012bdz\u012bbu var iestat\u012bt br\u012bdin\u0101juma izvad\u012b\u0161anu par gaid\u0101mo paroles der\u012bguma termi\u0146a izbeig\u0161anos.\n<li class=\"l\"> Noklus\u0113ti iesl\u0113gta br\u012bdin\u0101jumu izvad\u012b\u0161ana, izmantojot MD5 algoritmu autentifik\u0101cijai, kuram ir atz\u012bts novecojis statuss. Lai atsp\u0113jotu \u0161\u0101dus br\u012bdin\u0101jumus, pievienots parametrs md5_password_warnings.\n<li class=\"l\"> Ir pievienoti skati: 'pg_stat_lock' akumul\u0113t\u0101s statistikas skatam par blo\u0137\u0113jumiem, atkar\u012bb\u0101 no blo\u0137\u0113\u0161anas veidiem; 'pg_stat_recovery' oper\u0101ciju atjauno\u0161anas statusa inform\u0101cijai; 'pg_stat_autovacuum_scores' tabulu apstr\u0101des priorit\u0101tes noteik\u0161anai autovacuum. Daudzos sist\u0113mas skat\u012bjumos ir pievienota kolonna 'stats_reset', kur\u0101 ir redzams p\u0113d\u0113jais skait\u012bt\u0101ju t\u012br\u012b\u0161anas laiks. Skatos 'pg_stat_progress_vacuum' un 'pg_stat_progress_analyze' ir pievienota kolonna 'started_by', kur\u0101 par\u0101d\u0101s oper\u0101cijas iniciators. Skat\u0101 pg_stat_progress_vacuum ir pievienota kolonna 'mode', kas atspogu\u013co piem\u0113roto t\u012br\u012b\u0161anas re\u017e\u012bmu.\n<li class=\"l\"> Pievienota iesp\u0113ja noteikt minim\u0101los \u017eurn\u0101lu informat\u012bvo l\u012bme\u0146u (log_min_messages) attiec\u012bb\u0101 uz procesu veidiem.\n<li class=\"l\"> Statistik\u0101, kas tiek r\u0101d\u012bta p\u0113c VACUUM un ANALYZE darb\u012bb\u0101m, k\u0101 ar\u012b skat\u0101 &#171;pg_stat_wal&#187;, ir pievienota inform\u0101cija par ierakst\u012bto WAL \u017eurn\u0101la pilno lapu lielumiem, kas atvieglo WAL \u017eurn\u0101la p\u0101rm\u0113r\u012bgas izple\u0161an\u0101s c\u0113lo\u0146u izp\u0113ti (var saprast, vai pieaugums ir saist\u012bts ar parametra full_page_writes izmanto\u0161anu).\n<li class=\"l\"> Lo\u0123isk\u0101s replik\u0101cijas meh\u0101nism\u0101 ir ieviesta atbalsta sekvences (SEQUENCE) v\u0113rt\u012bbu replik\u0101cijai, kuras var public\u0113t ar komandu &#171;CREATE PUBLICATION&#187; izmantojot izteiksmi &#171;FOR ALL SEQUENCES&#187;.\n<li class=\"l\"> Ieviesis sintakse &#171;CREATE PUBLICATION &#8230; EXCEPT&#187; visu tabulu replik\u0101cijai, iz\u0146emot skaidri nor\u0101d\u012bt\u0101s.\n<li class=\"l\"> Pievienota izteiksme &#171;CREATE SUBSCRIPTION &#8230; SERVER&#187;, kas \u013cauj izveidot lo\u0123isk\u0101s replik\u0101cijas abonementus, ieg\u016bstot savienojuma iestat\u012bjumus no tre\u0161\u0101 servera.\n<li class=\"l\"> Tika pievienota iesp\u0113ja aktiviz\u0113t lo\u0123isko replik\u0101ciju tie\u0161i, nep\u0101rstart\u0113jot serveri, pat ja parametrs &#171;wal_level&#187; ir iestat\u012bts uz &#171;replica&#187; viet\u0101 &#171;logical&#187;. Lai noteiktu re\u0101li izpild\u012bto \u017eurn\u0101lo l\u012bmeni, kas nav saist\u012bts ar wal_level iestat\u012bjumu konfigur\u0101cijas fail\u0101, ir pievienots parametrs &#171;effective_wal_level&#187;.\n<li class=\"l\"> \u0100r\u0113jo tabulu pievieno\u0161anas meh\u0101nism\u0101 Foreign Data Wrapper (postgres_fdw) ieviestas iesp\u0113jas izs\u016bt\u012bt darb\u012bbas ar mas\u012bviem uz att\u0101lo serveri un pievienota opcija import_stats statistikas import\u0113\u0161anai no \u0101r\u0113j\u0101 servera, izpildot komandu ANALYZE, lai uzlabotu lok\u0101l\u0101s vaic\u0101jumu pl\u0101no\u0161anas efektivit\u0101ti.\n<li class=\"l\"> Noklus\u0113juma JIT kompil\u0101cija ir atsl\u0113gta, jo iev\u0113rojams sniegums tiek ieg\u016bts galvenok\u0101rt smagiem anal\u012btiskiem vaic\u0101jumiem, bet parast\u0101s OLTP slodz\u0113s tas var novest pie veiktsp\u0113jas krituma sakar\u0101 ar resursu prognoz\u0113\u0161anas k\u013c\u016bd\u0101m, kas nepiecie\u0161amas vaic\u0101jumu izpildei.\n<li class=\"l\">  Lai uzlabotu TOAST tabulu saspie\u0161anas un izsai\u0146o\u0161anas veiktsp\u0113ju, parametrs &#171;default_toast_compression&#187; ir iestat\u012bts uz &#171;lz4&#187;.\n<li class=\"l\"> Tika no\u0146emta atbalsta autentifik\u0101cija, izmantojot RADIUS protokolu.\n<li class=\"l\"> Komand\u0101 &#171;vacuumdb &#8212;analyze-only&#187; noklus\u0113juma iestat\u012bts anal\u012bze sekcij\u0101m tabul\u0101m.<\/ul>\n<p>D\u0113\u013c probl\u0113m\u0101m, kas tika konstat\u0113tas izstr\u0101des test\u0113\u0161anas p\u0113d\u0113j\u0101 posm\u0101, rel\u012bzes sast\u0101v\u0101 neiek\u013c\u0101v\u0101s da\u017eas iesp\u0113jas, kas tika pied\u0101v\u0101tas beta versij\u0101, piem\u0113ram, sintakse &#171;GROUP BY ALL&#187;, atbalsts ne-teksta izvades form\u0101tiem pg_dumpall, SQL\/PGQ grafikas vaic\u0101jumiem, iesp\u0113ja aktiviz\u0113t kontrolsumu atbalstu bez servera p\u0101rstart\u0113\u0161anas un reinicializ\u0101cijas, izteiksme &#171;FOR PORTION OF&#187; UPDATE un DELETE, izteiksmes &#171;ALTER TABLE &#8230; MERGE PARTITIONS&#187; un &#171;ALTER TABLE &#8230; SPLIT PARTITIONS&#187; sekciju tabulu reorganiz\u0101cijai, LC_COLLATE iestat\u012b\u0161ana uz &#171;C&#187; postmaster procesa laik\u0101, un jaunas funkcijas pg_get_role_ddl(), pg_get_tablespace_ddl() un pg_get_database_ddl(). Zi\u0146as sponsorts ir uz\u0146\u0113mums Hi-Kvadr\u0101ts, zemas koda platformas XSQUARE izstr\u0101d\u0101t\u0101js uz PostgreSQL (rekl\u0101ma, SIA &#171;Hi-Kvadr\u0101ts&#187;, VAT nr. 7718990614).<br \/>\n<br \/>Avots: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=66693\">opennet.lv<\/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\/lv\/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=\"lv_LV\" \/>\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\/lv\/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\udd47PostgreSQL 19 DB izlaidums | ProHoster","description":"P\u0113c gada izstr\u0101des public\u0113ta jauna stabila PostgreSQL 19 datub\u0101zu vad\u012bbas sist\u0113mas versija. Jaun\u0101s versijas atjaunin\u0101jumi tiks izlaisti piecu gadu laik\u0101 l\u012bdz 2031. gada novembrim.","canonical_url":"https:\/\/prohoster.info\/lv\/blog\/news\/postgresql-19-released","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"lv_LV","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\/lv\/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\/lv\/wp-json\/wp\/v2\/posts\/184329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/comments?post=184329"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/184329\/revisions"}],"predecessor-version":[{"id":184330,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/posts\/184329\/revisions\/184330"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/media?parent=184329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/categories?post=184329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/lv\/wp-json\/wp\/v2\/tags?post=184329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}