{"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\/sk\/blog\/news\/postgresql-19-released","title":{"rendered":"Vydanie DBMS PostgreSQL 19","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Po roku v\u00fdvoja bola zverejnen\u00e1 nov\u00e1 stabiln\u00e1 verzia datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 19. Aktualiz\u00e1cie pre nov\u00fa vetvu bud\u00fa vych\u00e1dza\u0165 po\u010das piatich rokov a\u017e do novembra 2031. Podpora PostgreSQL 14.x, najstar\u0161ej z podporovan\u00fdch vetiev, bola ukon\u010den\u00e1 tento mesiac. Vydanie bolo zverejnen\u00e9 takmer o dva mesiace nesk\u00f4r ako p\u00f4vodne pl\u00e1novan\u00fd term\u00edn kv\u00f4li neobvykl\u00e9mu po\u010dtu hl\u00e1sen\u00ed ch\u00fdb, zisten\u00fdch anal\u00fdzou k\u00f3du pomocou AI n\u00e1strojov.       <\/p>\n<p>Hlavn\u00e9 novinky:     <\/p>\n<ul>\n<li class=\"l\"> Implement\u00e1cia subsyst\u00e9mu asynchr\u00f3nneho vstupu\/v\u00fdstupu bola vylep\u0161en\u00e1, \u010do zvy\u0161uje priepustnos\u0165 vstupu\/v\u00fdstupu a eliminuje oneskorenia. V univerz\u00e1lnej implement\u00e1cii AIO (io_method=worker) pribudla mo\u017enos\u0165 automaticky zvy\u0161ova\u0165 alebo zni\u017eova\u0165 po\u010det spusten\u00fdch procesov spracovate\u013eov vstupu\/v\u00fdstupu v z\u00e1vislosti od za\u0165a\u017eenia. Na ur\u010denie minim\u00e1lneho a maxim\u00e1lneho po\u010dtu spracovate\u013esk\u00fdch procesov, ako aj \u010dasov\u00e9ho limitu neaktivity pred ukon\u010den\u00edm a oneskorenia pred spusten\u00edm procesov, boli navrhnut\u00e9 parametre io_min_workers, io_max_workers, io_worker_idle_timeout a io_worker_launch_interval.\n<p>Okrem toho je pl\u00e1nova\u010d predik\u010dn\u00e9ho \u010d\u00edtania aplikovan\u00fd v AIO optimalizovan\u00fd na zv\u00fd\u0161enie v\u00fdkonu dopytov, ktor\u00e9 si vy\u017eaduj\u00fa na\u010d\u00edtanie ve\u013ek\u00e9ho objemu \u00fadajov z disku. Optimaliz\u00e1cia je realizovan\u00e1 prostredn\u00edctvom adapt\u00edvneho stanovenia pr\u00edpustn\u00e9ho po\u010dtu oper\u00e1ci\u00ed predik\u010dn\u00e9ho \u010d\u00edtania v z\u00e1vislosti od charakteru a ve\u013ekosti dopytu (napr\u00edklad pre oper\u00e1cie skenovania ve\u013ek\u00fdch tabuliek a indexov sa teraz vopred na\u010d\u00edtava z disku viac \u00fadajov). Pre anal\u00fdzu vykon\u00e1vania oper\u00e1ci\u00ed vstupu\/v\u00fdstupu v asynchr\u00f3nnom re\u017eime bola do pr\u00edkazu &#171;EXPLAIN ANALYZE&#187; pridan\u00e1 mo\u017enos\u0165 &#171;IO&#187;.      <\/p>\n<li class=\"l\"> Pridali sa roz\u0161\u00edrenia pg_plan_advice a pg_stash_advice na prenos parametrov-n\u00e1povedy pl\u00e1nova\u010du dopytov pomocou mini-jazyka &#171;plan advice&#187;, ktor\u00fd umo\u017e\u0148uje ovplyvni\u0165 v\u00fdber pl\u00e1nov vykon\u00e1vania, fixova\u0165 vybran\u00e9 pl\u00e1ny a experimentova\u0165 s r\u00f4znymi pl\u00e1nmi. Na z\u00edskanie zoznamu parametrov, ktor\u00e9 pl\u00e1nova\u010d vybral pri vykon\u00e1van\u00ed dopytu, bola do pr\u00edkazu EXPLAIN pridan\u00e1 mo\u017enos\u0165 &#171;PLAN_ADVICE&#187;, a na nastavenie vlastn\u00fdch parametrov pred vykonan\u00edm dopytu mo\u017eno pou\u017ei\u0165 v\u00fdraz &#171;SET pg_plan_advice.advice = &#8216;re\u0165azec so zoznamom parametrov'&#187;. Roz\u0161\u00edrenie pg_stash_advice dop\u013a\u0148a pg_plan_advice o mo\u017enosti pri\u013enutia parametrov k identifik\u00e1torom dopytov, aby ich nebolo potrebn\u00e9 prid\u00e1va\u0165 pred ka\u017ed\u00fd dopyt. EXPLAIN (COSTS OFF, PLAN_ADVICE) SELECT * FROM join_fact f JOIN join_dim d ON f.dim_id = d.id; &#8230; Vygenerovan\u00e1 poradov\u00e1 rada: 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\"> Do procesu automatick\u00e9ho sp\u00fa\u0161\u0165ania \u010distenia (autovacuum) bola pridan\u00e1 mo\u017enos\u0165 paraleln\u00e9ho pou\u017e\u00edvania viacer\u00fdch spracovate\u013eov pri \u010disten\u00ed indexov. Po\u010det spracovate\u013eov sa nastavuje cez vo\u013ebu autovacuum_max_parallel_workers. Taktie\u017e boli pridan\u00e9 nov\u00e9 vo\u013eby autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight a autovacuum_analyze_score_weight na ur\u010denie priority \u010distenia tabuliek.\n<li class=\"l\"> Bola implementovan\u00e1 nov\u00e1 strat\u00e9gia \u010distenia, ktor\u00e1 umo\u017e\u0148uje zn\u00ed\u017ei\u0165 objem pr\u00e1ce v bud\u00facnosti, aktualizovan\u00edm mapy vidite\u013enosti str\u00e1nok po\u010das skenovania tabuliek pri vykon\u00e1van\u00ed SELECT po\u017eiadaviek, bez \u010dakania na spustenie pr\u00edkazu VACUUM.\n<li class=\"l\"> Pridan\u00fd nov\u00fd SQL pr\u00edkaz &#171;REPACK&#187; na prestavbu tabuliek s ni\u017e\u0161\u00edmi n\u00e1kladmi. Pr\u00edkaz REPACK \u00faplne prepisuje cel\u00fd obsah tabu\u013eky do nov\u00e9ho s\u00faboru na disku, \u010do umo\u017e\u0148uje operat\u00edvnemu syst\u00e9mu vr\u00e1ti\u0165 miesto na disku, ktor\u00e9 zaberaj\u00fa nepou\u017e\u00edvan\u00e9 bloky. Na rozdiel od pr\u00edkazu &#171;VACUUM FULL&#187;, po\u010das prepisovania s tvrdou z\u00e1mkou, m\u00e1 pr\u00edkaz REPACK mo\u017enos\u0165 &#171;CONCURRENTLY&#187;, pri ktorej sa po\u010das op\u00e4tovn\u00e9ho balenia povo\u013euje pou\u017e\u00edvanie tabu\u013eky in\u00fdmi transakciami. Na rozdiel od roz\u0161\u00edrenia pg_repack je REPACK v\u00fdrazne r\u00fdchlej\u0161ie, preto\u017ee neprip\u00e1ja k tabu\u013eke dodato\u010dn\u00e9 sp\u00fa\u0161\u0165a\u010de, ale nepodporuje spracovanie cel\u00fdch particionovan\u00fdch tabuliek.\n<li class=\"l\"> A\u017e dvojn\u00e1sobne zv\u00fd\u0161en\u00fd v\u00fdkon oper\u00e1cie INSERT pre tabu\u013eky, v ktor\u00fdch sa kontroluj\u00fa z\u00e1znamy pomocou cudz\u00edch k\u013e\u00fa\u010dov (Foreign Key). Zr\u00fdchlenie bolo dosiahnut\u00e9 vyu\u017eit\u00edm indexu na kontrolu cudz\u00edch k\u013e\u00fa\u010dov, \u010do umo\u017enilo vyhn\u00fa\u0165 sa vykon\u00e1vaniu n\u00e1ro\u010dn\u00e9ho intern\u00e9ho dopytu na tabu\u013eku.\n<li class=\"l\"> V pl\u00e1nova\u010di dotaz\u016f bylo zaji\u0161t\u011bno rozpozn\u00e1v\u00e1n\u00ed operac\u00ed Anti-Join (ur\u010den\u00ed z\u00e1znam\u016f z prvn\u00ed tabulky, pro kter\u00e9 neexistuj\u00ed shody ve druh\u00e9 tabulce) ve slo\u017eit\u00fdch dotazech s \u201eLEFT JOIN\u201c a dotazech s v\u00fdrazy \u201eNOT IN\u201c pro vyu\u017eit\u00ed specifick\u00fdch optimalizac\u00ed. Bylo roz\u0161\u00ed\u0159eno pou\u017eit\u00ed inkrement\u00e1ln\u00edho t\u0159\u00edd\u011bn\u00ed. Byla p\u0159id\u00e1na optimalizace \u201eeager aggregation\u201c, kter\u00e1 p\u0159esouv\u00e1 agrega\u010dn\u00ed operace do f\u00e1ze p\u0159ed slou\u010den\u00edm tabulek, aby se sn\u00ed\u017eil po\u010det \u0159\u00e1dk\u016f zpracov\u00e1van\u00fdch p\u0159i procesu slou\u010den\u00ed. Zrychleno paraleln\u00ed prov\u00e1d\u011bn\u00ed operac\u00ed sekven\u010dn\u00edho skenov\u00e1n\u00ed (parallel seq scan). Bylo realizov\u00e1no sn\u00ed\u017een\u00ed konstrukc\u00ed \u201eIS DISTINCT FROM\u201c a \u201eIS NOT DISTINCT FROM\u201c na v\u00fdrazy s oper\u00e1tory \u201e\u201c a \u201e=\u201c, pokud ob\u011b operandov\u00e9 hodnoty nemohou nab\u00fdvat hodnoty NULL.\n<li class=\"l\"> Zv\u00fd\u0161en\u00e1 efektivita doru\u010dovania notifik\u00e1ci\u00ed pomocou pr\u00edkazu NOTIFY v konfigur\u00e1ci\u00e1ch s viacer\u00fdmi kan\u00e1lmi notifik\u00e1ci\u00ed. V zdie\u013eanej pam\u00e4ti sa teraz uchov\u00e1va mapa kan\u00e1lov, ktor\u00e1 umo\u017e\u0148uje adresne sa obraca\u0165 iba na backendy prihl\u00e1sen\u00e9 na dan\u00fd kan\u00e1l.\n<li class=\"l\"> Do p\u0159\u00edkazu \u201eINSERT\u201c byla p\u0159id\u00e1na podpora v\u00fdrazu ON CONFLICT DO SELECT \u2026 RETURNING, kter\u00fd vrac\u00ed z\u00e1znamy v p\u0159\u00edpad\u011b nemo\u017enosti jejich p\u0159id\u00e1n\u00ed prost\u0159ednictv\u00edm \u201eINSERT\u201c, vedle v\u00fdraz\u016f \u201eON CONFLICT DO NOTHING\/UPDATE\u201c, kter\u00e9 ti\u0161e ignoruj\u00ed konflikty p\u0159i vlo\u017een\u00ed nebo prov\u00e1d\u011bj\u00ed aktualizaci m\u00edsto vlo\u017een\u00ed.\n<li class=\"l\"> Do pr\u00edkazu COPY bola pridan\u00e1 podpora v\u00fdstupu \u00fadajov vo form\u00e1te JSON.\n<li class=\"l\"> Do jazyka SQL\/JSON boli pridan\u00e9 met\u00f3dy na spracovanie re\u0165azcov lower(), upper(), replace(), split_part() a btrim().\n<li class=\"l\"> V ok\u00e9nkov\u00fdch funkc\u00edch lead(), lag(), first_value(), last_value() a nth_value() byla p\u0159id\u00e1na podpora v\u00fdrazu \u201eIGNORE NULLS\u201c pro p\u0159esko\u010den\u00ed hodnot NULL.\n<li class=\"l\"> Byl p\u0159id\u00e1n p\u0159\u00edkaz \u201eWAIT FOR LSN\u201c, kter\u00fd p\u0159i asynchronn\u00ed replikaci pro zabr\u00e1n\u011bn\u00ed zobrazen\u00ed zastaral\u00fdch dat umo\u017e\u0148uje pozastavit SELECT dotaz na replikovan\u00e9m serveru, dokud se neaplikuj\u00ed zm\u011bny z hlavn\u00edho. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sk\/server\/dts-los-angeles\/\"   title=\"servera\" data-wpil-keyword-link=\"linked\">servera<\/a>, ktor\u00e9 zodpovedaj\u00fa ur\u010ditej LSN poz\u00edcii (Log Sequence Number) v WAL logu.\n<li class=\"l\"> Do funkcie random() bola pridan\u00e1 podpora typov date a timestamp na generovanie n\u00e1hodn\u00fdch d\u00e1tumov a \u010dasov v ur\u010denom rozsahu.\n<li class=\"l\"> Bola pridan\u00e1 mo\u017enos\u0165 vytv\u00e1ra\u0165 funkcie v PL\/Python pre sp\u00fa\u0161\u0165anie udalost\u00ed (event trigger).\n<li class=\"l\"> Do prij\u00edmaj\u00faceho sie\u0165ov\u00e9ho pripojenia <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sk\/server\/\"   title=\"server\" data-wpil-keyword-link=\"linked\">server<\/a> bola pridan\u00e1 podpora TLS roz\u0161\u00edrenia SNI (Server Name Indication) na pou\u017eitie TLS certifik\u00e1tov viazan\u00fdch na n\u00e1zvy hostite\u013eov, ku ktor\u00fdm sa klient prihlasuje pri nastavovan\u00ed \u0161ifrovan\u00e9ho spojenia cez jednu IP adresu.\n<li class=\"l\"> Do konfigura\u010dn\u00e9ho s\u00faboru postgresql.conf bol pridan\u00fd parameter password_expiration_warning_threshold, pomocou ktor\u00e9ho je mo\u017en\u00e9 nastavi\u0165 v\u00fdstup varovania o bl\u00ed\u017eiacom sa uplynut\u00ed platnosti hesla.\n<li class=\"l\"> V\u00fdstup varovan\u00ed pri pou\u017e\u00edvan\u00ed algoritmu MD5 pri autentifik\u00e1cii, ktor\u00fd bol ozna\u010den\u00fd za zastaran\u00fd, je teraz predvolene zapnut\u00fd. Na vypnutie tak\u00fdchto varovan\u00ed bol pridan\u00fd parameter md5_password_warnings.\n<li class=\"l\"> Byly p\u0159id\u00e1ny pohledy: \u201epg_stat_lock\u201c pro zobrazen\u00ed nahromad\u011bn\u00e9 statistiky o z\u00e1mc\u00edch v z\u00e1vislosti na typech z\u00e1mk\u016f; \u201epg_stat_recovery\u201c pro z\u00edsk\u00e1n\u00ed informac\u00ed o stavu obnovovac\u00edch operac\u00ed; \u201epg_stat_autovacuum_scores\u201c pro ur\u010den\u00ed priority zpracov\u00e1n\u00ed tabulek v autovacuum. Do mnoha syst\u00e9mov\u00fdch pohled\u016f byl p\u0159id\u00e1n sloupec \u201estats_reset\u201c, ve kter\u00e9m je uvedeno posledn\u00ed \u010dasov\u00e9 raz\u00edtko pro vy\u010di\u0161t\u011bn\u00ed \u010d\u00edta\u010d\u016f. Do pohled\u016f \u201epg_stat_progress_vacuum\u201c a \u201epg_stat_progress_analyze\u201c byl p\u0159id\u00e1n sloupec \u201estarted_by\u201c, kter\u00fd ukazuje inici\u00e1tora operace. Do pohledu pg_stat_progress_vacuum byl p\u0159id\u00e1n sloupec \u201emode\u201c, kter\u00fd odr\u00e1\u017e\u00ed pou\u017eit\u00fd re\u017eim \u010di\u0161t\u011bn\u00ed.\n<li class=\"l\"> Bola pridan\u00e1 mo\u017enos\u0165 ur\u010di\u0165 minim\u00e1lne \u00farovne informat\u00edvnosti logov (log_min_messages) viazan\u00e9 na typy procesov.\n<li class=\"l\"> Do \u0161tatistiky, zobrazen\u00e9 po oper\u00e1ci\u00e1ch VACUUM a ANALYZE, ako aj do zobrazenia &#171;pg_stat_wal&#187;, boli pridan\u00e9 inform\u00e1cie o ve\u013ekosti zap\u00edsan\u00fdch v WAL-logu cel\u00fdch str\u00e1n, \u010do u\u013eah\u010duje rozbor pr\u00ed\u010din nadmern\u00e9ho rastu WAL-logu (je mo\u017en\u00e9 pochopi\u0165, \u010di je rast spojen\u00fd s pou\u017eit\u00edm parametra full_page_writes).\n<li class=\"l\"> V mechanizme logickej replik\u00e1cie bola implementovan\u00e1 podpora replik\u00e1cie hodn\u00f4t sekvenci\u00ed (SEQUENCE), ktor\u00e9 je mo\u017en\u00e9 publikova\u0165 pr\u00edkazom &#171;CREATE PUBLICATION&#187; pomocou v\u00fdrazu &#171;FOR ALL SEQUENCES&#187;.\n<li class=\"l\"> Bol pridan\u00fd syntaktick\u00fd v\u00fdraz &#171;CREATE PUBLICATION &#8230; EXCEPT&#187; pre replik\u00e1ciu v\u0161etk\u00fdch tabuliek s v\u00fdnimkou explicitne uveden\u00fdch.\n<li class=\"l\"> Bolo pridan\u00e9 vyjadrenie &#171;CREATE SUBSCRIPTION &#8230; SERVER&#187;, ktor\u00e9 umo\u017e\u0148uje vytv\u00e1ra\u0165 predplatn\u00e9 logickej replik\u00e1cie s prijat\u00edm nastaven\u00ed pripojenia zo vzdialen\u00e9ho servera.\n<li class=\"l\"> Bola pridan\u00e1 mo\u017enos\u0165 aktiv\u00e1cie logickej replik\u00e1cie za behu bez re\u0161tartu servera, aj ke\u010f je parameter &#171;wal_level&#187; nastaven\u00fd na hodnotu &#171;replica&#187; namiesto &#171;logical&#187;. Pre ur\u010denie skuto\u010dn\u00e9ho \u00farovne denn\u00edka, ktor\u00e1 nie je viazan\u00e1 na nastavenie wal_level v konfigura\u010dnom s\u00fabore, bol pridan\u00fd parameter &#171;effective_wal_level&#187;.\n<li class=\"l\"> Vo mechanizme pripojenia extern\u00fdch tabuliek Foreign Data Wrapper (postgres_fdw) boli implementovan\u00e9 mo\u017enosti na presmerovanie oper\u00e1ci\u00ed s poliami na vzdialen\u00fd server a pridan\u00e1 mo\u017enos\u0165 import_stats pre import \u0161tatist\u00edk pre tabu\u013eky z extern\u00e9ho servera pri vykon\u00e1van\u00ed pr\u00edkazu ANALYZE na zv\u00fd\u0161enie efektivity lok\u00e1lneho pl\u00e1novania vykon\u00e1vania dopytov.\n<li class=\"l\"> Predvolene je JIT-kompil\u00e1cia vypnut\u00e1, preto\u017ee v\u00fdrazn\u00e9 zisky v v\u00fdkonu poskytuje hlavne pre \u0165a\u017ek\u00e9 analytick\u00e9 dopyty a v be\u017en\u00fdch OLTP z\u00e1\u0165a\u017eiach m\u00f4\u017ee vies\u0165 k poklesu v\u00fdkonu kv\u00f4li chyb\u00e1m pri predpovedan\u00ed zdrojov potrebn\u00fdch na vykon\u00e1vanie dopytov.\n<li class=\"l\">  Na zlep\u0161enie v\u00fdkonu kompresie a dekompresie TOAST-tabuliek je parameter &#171;default_toast_compression&#187; nastaven\u00fd na hodnotu &#171;lz4&#187;.\n<li class=\"l\"> Podpora autentifik\u00e1cie pomocou protokolu RADIUS bola odstr\u00e1nen\u00e1.\n<li class=\"l\"> V pr\u00edkaze &#171;vacuumdb &#8212;analyze-only&#187; je predvolene zahrnut\u00e1 anal\u00fdza  sekcionovan\u00fdch tabuliek.<\/ul>\n<p>Vzh\u013eadom na probl\u00e9my, ktor\u00e9 sa objavili v kone\u010dnej f\u00e1ze testovania, niektor\u00e9 mo\u017enosti predstaven\u00e9 v beta verzii neboli zahrnut\u00e9 do vydania, ako napr\u00edklad syntaktick\u00fd v\u00fdraz &#171;GROUP BY ALL&#187;, podpora netextov\u00fdch form\u00e1tov v\u00fdstupu v pg_dumpall, SQL\/PGQ pre grafov\u00e9 dotazy, aktiv\u00e1cia podpory kontroln\u00fdch s\u00fam bez re\u0161tartu a reinicializ\u00e1cie, vyjadrenie &#171;FOR PORTION OF&#187; v UPDATE a DELETE, v\u00fdrazy &#171;ALTER TABLE &#8230; MERGE PARTITIONS&#187; a &#171;ALTER TABLE &#8230; SPLIT PARTITIONS&#187; na reorganiz\u00e1ciu sekcionovan\u00fdch tabuliek, nastavenie LC_COLLATE na hodnotu &#171;C&#187; pre proces postmaster a nov\u00e9 funkcie pg_get_role_ddl(), pg_get_tablespace_ddl() a pg_get_database_ddl(). Sponzorom spr\u00e1vy je spolo\u010dnos\u0165 Hi-Square, v\u00fdvoj\u00e1r Low Code platformy XSQUARE na PostgreSQL (reklama, s.r.o. &#171;Hi-Square&#187;, I\u010cO 7718990614).<br \/>\n<br \/>Zdroj: <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\/sk\/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=\"sk_SK\" \/>\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\/sk\/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\udd47Uvo\u013enenie datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 19 | ProHoster","description":"Po roku v\u00fdvoja bola vydan\u00e1 nov\u00e1 stabiln\u00e1 vetva datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 19. Aktualiz\u00e1cie pre nov\u00fa vetvu bud\u00fa vyd\u00e1van\u00e9 po dobu piatich rokov a\u017e do novembra 2031.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/postgresql-19-released","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/184329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=184329"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/184329\/revisions"}],"predecessor-version":[{"id":184330,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/184329\/revisions\/184330"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=184329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=184329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=184329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}