{"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\/cs\/blog\/news\/postgresql-19-released","title":{"rendered":"Verze datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 19","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Po roce v\u00fdvoje byla zve\u0159ejn\u011bna nov\u00e1 stabiln\u00ed verze datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 19. Aktualizace pro tuto novou verzi budou vyd\u00e1v\u00e1ny po dobu p\u011bti let, do listopadu 2031. Podpora PostgreSQL 14.x, nejstar\u0161\u00ed z podporovan\u00fdch verz\u00ed, byla ukon\u010dena v tomto m\u011bs\u00edci. Uvoln\u011bn\u00ed bylo zve\u0159ejn\u011bno t\u00e9m\u011b\u0159 o dva m\u011bs\u00edce pozd\u011bji, ne\u017e bylo p\u016fvodn\u011b pl\u00e1nov\u00e1no, kv\u016fli nepot\u0159ebn\u00e9mu mno\u017estv\u00ed chybov\u00fdch zpr\u00e1v identifikovan\u00fdch anal\u00fdzou k\u00f3du pomoc\u00ed n\u00e1stroj\u016f zalo\u017een\u00fdch na um\u011bl\u00e9 inteligenci.       <\/p>\n<p>Hlavn\u00ed novinky:     <\/p>\n<ul>\n<li class=\"l\"> Byla vylep\u0161ena implementace subsyst\u00e9mu asynchronn\u00edho vstupu\/v\u00fdstupu, kter\u00fd umo\u017e\u0148uje zv\u00fd\u0161en\u00ed propustnosti vstupu\/v\u00fdstupu a eliminaci zpo\u017ed\u011bn\u00ed. V univerz\u00e1ln\u00ed implementaci AIO (io_method=worker) byla p\u0159id\u00e1na mo\u017enost automatick\u00e9ho zvy\u0161ov\u00e1n\u00ed nebo sni\u017eov\u00e1n\u00ed po\u010dtu spu\u0161t\u011bn\u00fdch proces\u016f zpracovatel\u016f vstupu\/v\u00fdstupu v z\u00e1vislosti na zat\u00ed\u017een\u00ed. Byly navr\u017eeny parametry io_min_workers, io_max_workers, io_worker_idle_timeout a io_worker_launch_interval pro ur\u010den\u00ed minim\u00e1ln\u00edho a maxim\u00e1ln\u00edho po\u010dtu zpracovatel\u016f, jako\u017e i timeoutu neaktivity p\u0159ed ukon\u010den\u00edm a zpo\u017ed\u011bn\u00ed p\u0159ed spu\u0161t\u011bn\u00edm proces\u016f.\n<p>Krom\u011b toho je pl\u00e1nova\u010d p\u0159edb\u011b\u017en\u00e9ho \u010dten\u00ed pou\u017e\u00edvan\u00fd v AIO optimalizov\u00e1n pro zlep\u0161en\u00ed v\u00fdkonu dotaz\u016f, kter\u00e9 vy\u017eaduj\u00ed na\u010d\u00edt\u00e1n\u00ed velk\u00e9ho objemu dat z disku. Optimalizace je realizov\u00e1na adaptivn\u00edm ur\u010den\u00edm povolen\u00e9ho po\u010dtu operac\u00ed p\u0159edb\u011b\u017en\u00e9ho \u010dten\u00ed v z\u00e1vislosti na charakteru a velikosti po\u017eadavku (nap\u0159\u00edklad pro operace skenov\u00e1n\u00ed velk\u00fdch tabulek a index\u016f se nyn\u00ed p\u0159edem na\u010d\u00edt\u00e1 z disku v\u00edce dat). Pro anal\u00fdzu prov\u00e1d\u011bn\u00ed operac\u00ed vstupu\/v\u00fdstupu v asynchronn\u00edm re\u017eimu byla do p\u0159\u00edkazu &#171;EXPLAIN ANALYZE&#187; p\u0159id\u00e1na volba &#171;IO&#187;.      <\/p>\n<li class=\"l\"> Byly p\u0159id\u00e1ny roz\u0161\u00ed\u0159en\u00ed pg_plan_advice a pg_stash_advice pro p\u0159ed\u00e1v\u00e1n\u00ed parametr\u016f-n\u00e1vrh\u016f pl\u00e1nova\u010di dotaz\u016f pomoc\u00ed mini-jazyka &#171;plan advice&#187;, co\u017e umo\u017e\u0148uje ovlivnit v\u00fdb\u011br pl\u00e1n\u016f prov\u00e1d\u011bn\u00ed, fixovat vybran\u00e9 pl\u00e1ny a experimentovat s r\u016fzn\u00fdmi pl\u00e1ny. Pro z\u00edsk\u00e1n\u00ed seznamu parametr\u016f vybran\u00fdch pl\u00e1nova\u010dem p\u0159i prov\u00e1d\u011bn\u00ed dotazu byla do p\u0159\u00edkazu EXPLAIN p\u0159id\u00e1na volba &#171;PLAN_ADVICE&#187;, a pro nastaven\u00ed vlastn\u00edch parametr\u016f p\u0159ed proveden\u00edm dotazu lze pou\u017e\u00edt v\u00fdraz &#171;SET pg_plan_advice.advice = &#8216;\u0159et\u011bzec se seznamem parametr\u016f'&#187;. Roz\u0161\u00ed\u0159en\u00ed pg_stash_advice dopl\u0148uje pg_plan_advice funkcemi pro p\u0159i\u0159azen\u00ed parametr\u016f k identifik\u00e1tor\u016fm dotaz\u016f, aby je nebylo nutn\u00e9 p\u0159id\u00e1vat p\u0159ed ka\u017ed\u00fdm dotazem.       EXPLAIN (COSTS OFF, PLAN_ADVICE) SELECT * FROM join_fact f JOIN join_dim d ON f.dim_id = d.id;     &#8230;     Vygenerovan\u00fd pl\u00e1n rady:        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 spou\u0161t\u011bn\u00ed \u010di\u0161t\u011bn\u00ed (autovacuum) byla p\u0159id\u00e1na mo\u017enost paraleln\u00edho pou\u017eit\u00ed n\u011bkolika zpracovatel\u016f p\u0159i vykon\u00e1v\u00e1n\u00ed \u010di\u0161t\u011bn\u00ed index\u016f. Po\u010det zpracovatel\u016f je nastavov\u00e1n prost\u0159ednictv\u00edm mo\u017enosti autovacuum_max_parallel_workers. Byly tak\u00e9 p\u0159id\u00e1ny nov\u00e9 mo\u017enosti autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight a autovacuum_analyze_score_weight pro ur\u010den\u00ed priority \u010di\u0161t\u011bn\u00ed tabulek.\n<li class=\"l\"> Byla implementov\u00e1na nov\u00e1 strategie \u010di\u0161t\u011bn\u00ed, kter\u00e1 umo\u017e\u0148uje sn\u00ed\u017eit objem pr\u00e1ce v budoucnu, d\u00edky aktualizaci mapy viditelnosti str\u00e1nek b\u011bhem skenov\u00e1n\u00ed tabulek p\u0159i vykon\u00e1v\u00e1n\u00ed SELECT dotaz\u016f, ani\u017e by bylo nutn\u00e9 \u010dekat na spu\u0161t\u011bn\u00ed p\u0159\u00edkazu VACUUM.\n<li class=\"l\"> Byl p\u0159id\u00e1n nov\u00fd SQL p\u0159\u00edkaz &#171;REPACK&#187; pro p\u0159eorganizov\u00e1n\u00ed tabulek s men\u0161\u00edmi n\u00e1klady. P\u0159\u00edkaz REPACK zcela p\u0159episuje ve\u0161ker\u00fd obsah tabulky do nov\u00e9ho souboru na disku, co\u017e umo\u017e\u0148uje vr\u00e1tit opera\u010dn\u00edmu syst\u00e9mu m\u00edsto na disku, kter\u00e9 zab\u00edraj\u00ed nevyu\u017e\u00edvan\u00e9 bloky. Na rozd\u00edl od p\u0159\u00edkazu &#171;VACUUM FULL&#187;, kter\u00fd b\u011bhem p\u0159episu nastavuje p\u0159\u00edsnou blokaci, m\u00e1 p\u0159\u00edkaz REPACK mo\u017enost &#171;CONCURRENTLY&#187;, p\u0159i jej\u00edm\u017e pou\u017eit\u00ed je b\u011bhem p\u0159eorganizace povoleno pou\u017e\u00edvat tabulku jin\u00fdmi transakcemi. Na rozd\u00edl od roz\u0161\u00ed\u0159en\u00ed pg_repack, je REPACK znateln\u011b rychlej\u0161\u00ed, proto\u017ee k tabulce nep\u0159ipojuje dal\u0161\u00ed spou\u0161t\u011b\u010de, ale nepodporuje zpracov\u00e1n\u00ed cel\u00fdch partitionovan\u00fdch tabulek.\n<li class=\"l\"> A\u017e dvojn\u00e1sobn\u011b zv\u00fd\u0161ena v\u00fdkonnost operace INSERT pro tabulky, ve kter\u00fdch prob\u00edh\u00e1 kontrola z\u00e1znam\u016f podle ciz\u00edch kl\u00ed\u010d\u016f (Foreign Key). Zrychlen\u00ed bylo dosa\u017eeno vyu\u017eit\u00edm indexu pro kontrolu ciz\u00edho kl\u00ed\u010de, co\u017e umo\u017enilo obej\u00edt se bez n\u00e1ro\u010dn\u00e9ho intern\u00edho dotazu na tabulku.\n<li class=\"l\"> V pl\u00e1nova\u010di dotaz\u016f bylo zavedeno rozpozn\u00e1v\u00e1n\u00ed operac\u00ed Anti-Join (ur\u010dov\u00e1n\u00ed \u0159\u00e1dk\u016f z prvn\u00ed tabulky, pro kter\u00e9 neexistuj\u00ed shody ve druh\u00e9 tabulce) v slo\u017eit\u00fdch dotazech s \u201eLEFT JOIN\u201c a dotazech s v\u00fdrazy \u201eNOT IN\u201c pro zapojen\u00ed specifick\u00fdch optimalizac\u00ed. Bylo roz\u0161\u00ed\u0159eno pou\u017eit\u00ed inkrement\u00e1ln\u00edho t\u0159\u00edd\u011bn\u00ed. 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 za \u00fa\u010delem sn\u00ed\u017een\u00ed po\u010dtu \u0159\u00e1dk\u016f zpracov\u00e1van\u00fdch v pr\u016fb\u011bhu slou\u010den\u00ed. Zrychleno paraleln\u00ed prov\u00e1d\u011bn\u00ed operac\u00ed sekven\u010dn\u00edho prohled\u00e1v\u00e1n\u00ed (parallel seq scan). Bylo implementov\u00e1no p\u0159ev\u00e1d\u011bn\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 oba operandy nemohou m\u00edt hodnotu NULL.\n<li class=\"l\"> Byla zv\u00fd\u0161ena \u00fa\u010dinnost doru\u010dov\u00e1n\u00ed ozn\u00e1men\u00ed pomoc\u00ed p\u0159\u00edkazu NOTIFY v konfigurac\u00edch s v\u00edce kan\u00e1ly ozn\u00e1men\u00ed. V sd\u00edlen\u00e9 pam\u011bti nyn\u00ed existuje mapa kan\u00e1l\u016f, kter\u00e1 umo\u017e\u0148uje adresn\u011b vyhled\u00e1vat pouze backendy p\u0159ihl\u00e1\u0161en\u00e9 k dan\u00e9mu kan\u00e1lu.\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, \u017ee je nelze p\u0159idat prost\u0159ednictv\u00edm \u201eINSERT\u201c, na rozd\u00edl od v\u00fdraz\u016f \u201eON CONFLICT DO NOTHING\/UPDATE\u201c, kter\u00e9 ti\u0161e ignoruj\u00ed kolize p\u0159i vkl\u00e1d\u00e1n\u00ed nebo prov\u00e1d\u011bj\u00ed aktualizaci m\u00edsto vlo\u017een\u00ed.\n<li class=\"l\"> Do p\u0159\u00edkazu COPY byla p\u0159id\u00e1na podpora pro v\u00fdstup dat ve form\u00e1tu JSON.\n<li class=\"l\"> Do jazyka SQL\/JSON byly p\u0159id\u00e1ny metody pro zpracov\u00e1n\u00ed \u0159et\u011bzc\u016f lower(), upper(), replace(), split_part() a btrim().\n<li class=\"l\"> Ve funkci okna lead(), lag(), first_value(), last_value() a nth_value() byla p\u0159id\u00e1na podpora v\u00fdrazu \u201eIGNORE NULLS\u201c, kter\u00fd vynech\u00e1v\u00e1 hodnoty NULL.\n<li class=\"l\"> Byl p\u0159id\u00e1n p\u0159\u00edkaz \u201eWAIT FOR LSN\u201c, kter\u00fd p\u0159i asynchronn\u00ed replikaci, aby se zabr\u00e1nilo zobrazen\u00ed zastaral\u00fdch dat, umo\u017e\u0148uje pozastavit SELECT dotaz na replikovan\u00e9m serveru, dokud nejsou aplikov\u00e1ny zm\u011bny z hlavn\u00edho. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/cs\/server\/dts-los-angeles\/\"   title=\"serveru\" data-wpil-keyword-link=\"linked\">serveru<\/a>, odpov\u00eddaj\u00edc\u00ed ur\u010dit\u00e9 LSN pozici (Log Sequence Number) v WAL logu.\n<li class=\"l\"> Funkce random() nyn\u00ed podporuje typy date a timestamp pro generov\u00e1n\u00ed n\u00e1hodn\u00fdch dat a \u010das\u016f v dan\u00e9m rozsahu.\n<li class=\"l\"> Byla p\u0159id\u00e1na mo\u017enost vytv\u00e1\u0159et funkce pro ud\u00e1lostn\u00ed spou\u0161t\u011b\u010de (event trigger) v jazyce PL\/Python.\n<li class=\"l\"> Ve funkci p\u0159ij\u00edmaj\u00edc\u00ed s\u00ed\u0165ov\u00e1 spojen\u00ed <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/cs\/server\/\"   title=\"server\" data-wpil-keyword-link=\"linked\">server<\/a> byla p\u0159id\u00e1na podpora roz\u0161\u00ed\u0159en\u00ed TLS SNI (Server Name Indication) pro pou\u017eit\u00ed TLS certifik\u00e1t\u016f v\u00e1zan\u00fdch na n\u00e1zvy hostitel\u016f, ke kter\u00fdm se klient p\u0159ipojuje p\u0159i nastavov\u00e1n\u00ed \u0161ifrovan\u00e9ho p\u0159ipojen\u00ed p\u0159es jednu IP adresu.\n<li class=\"l\"> Do konfigura\u010dn\u00edho souboru postgresql.conf byl p\u0159id\u00e1n parametr password_expiration_warning_threshold, pomoc\u00ed kter\u00e9ho lze nastavit v\u00fdstup varov\u00e1n\u00ed o brzk\u00e9m vypr\u0161en\u00ed platnosti hesla.\n<li class=\"l\"> Bylo ve v\u00fdchoz\u00edm nastaven\u00ed povoleno zobrazov\u00e1n\u00ed varov\u00e1n\u00ed p\u0159i pou\u017eit\u00ed algoritmu MD5 p\u0159i autentizaci, kter\u00fd byl prohl\u00e1\u0161en za zastaral\u00fd. K vypnut\u00ed t\u011bchto varov\u00e1n\u00ed byl p\u0159id\u00e1n parametr 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 n\u00e1vaznosti na typy z\u00e1mk\u016f; \u201epg_stat_recovery\u201c pro z\u00edsk\u00e1n\u00ed informac\u00ed o stavu operac\u00ed obnovy; \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, kter\u00fd zobrazuje posledn\u00ed \u010das 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 aplikovan\u00fd re\u017eim \u010di\u0161t\u011bn\u00ed.\n<li class=\"l\"> Byla p\u0159id\u00e1na mo\u017enost nastavit minim\u00e1ln\u00ed \u00farovn\u011b informativnosti log\u016f (log_min_messages) podle typ\u016f proces\u016f.\n<li class=\"l\"> Do statistiky, kter\u00e1 se zobrazuje po operac\u00edch VACUUM a ANALYZE, a tak\u00e9 do zobrazen\u00ed &#171;pg_stat_wal&#187;, byly p\u0159id\u00e1ny informace o velikosti zapsan\u00fdch podrobn\u00fdch str\u00e1nek do WAL-logu, co\u017e usnad\u0148uje anal\u00fdzu p\u0159\u00ed\u010din nadm\u011brn\u00e9ho r\u016fstu WAL-logu (je mo\u017en\u00e9 zjistit, zda je r\u016fst spojen s pou\u017eit\u00edm parametru full_page_writes).\n<li class=\"l\"> V mechanismu logick\u00e9 replikace byla implementov\u00e1na podpora replikace hodnot sekvenc\u00ed (SEQUENCE), kter\u00e9 lze publikovat p\u0159\u00edkazem &#171;CREATE PUBLICATION&#187; pomoc\u00ed v\u00fdrazu &#171;FOR ALL SEQUENCES&#187;.\n<li class=\"l\"> Byl p\u0159id\u00e1n syntax &#171;CREATE PUBLICATION &#8230; EXCEPT&#187; pro replikaci v\u0161ech tabulek krom\u011b t\u011bch, kter\u00e9 jsou v\u00fdslovn\u011b uvedeny.\n<li class=\"l\"> Byl p\u0159id\u00e1n v\u00fdraz &#171;CREATE SUBSCRIPTION &#8230; SERVER&#187;, kter\u00fd umo\u017e\u0148uje vytv\u00e1\u0159et p\u0159edplatn\u00e9 logick\u00e9 replikace a z\u00edskat nastaven\u00ed p\u0159ipojen\u00ed od extern\u00edho serveru.\n<li class=\"l\"> Byla p\u0159id\u00e1na mo\u017enost zapnout logickou replikaci za b\u011bhu bez restartu serveru, i kdy\u017e je parametr &#171;wal_level&#187; nastaven na hodnotu &#171;replica&#187; nam\u00edsto &#171;logical&#187;. Pro ur\u010den\u00ed skute\u010dn\u00e9 \u00farovn\u011b protokolov\u00e1n\u00ed, kter\u00e1 nen\u00ed v\u00e1z\u00e1na na nastaven\u00ed wal_level v konfigura\u010dn\u00edm souboru, byl p\u0159id\u00e1n parametr &#171;effective_wal_level&#187;.\n<li class=\"l\"> V mechanismu p\u0159ipojen\u00ed extern\u00edch tabulek Foreign Data Wrapper (postgres_fdw) byly implementov\u00e1ny mo\u017enosti pro p\u0159ed\u00e1v\u00e1n\u00ed operac\u00ed s poli na vzd\u00e1len\u00fd server a byla p\u0159id\u00e1na mo\u017enost import_stats pro importov\u00e1n\u00ed statistik pro tabulky z extern\u00edho serveru p\u0159i prov\u00e1d\u011bn\u00ed p\u0159\u00edkazu ANALYZE pro zv\u00fd\u0161en\u00ed efektivity m\u00edstn\u00edho pl\u00e1nov\u00e1n\u00ed vykon\u00e1v\u00e1n\u00ed dotaz\u016f.\n<li class=\"l\"> JIT kompilace je ve v\u00fdchoz\u00edm nastaven\u00ed vypnuta, proto\u017ee znateln\u00fd zisk v v\u00fdkonu poskytuje hlavn\u011b pro t\u011b\u017ek\u00e9 analytick\u00e9 dotazy, zat\u00edmco v b\u011b\u017en\u00fdch OLTP z\u00e1t\u011b\u017e\u00edch m\u016f\u017ee v\u00e9st k pokles\u016fm v\u00fdkonu kv\u016fli chyb\u00e1m p\u0159i p\u0159edpov\u00edd\u00e1n\u00ed pot\u0159ebn\u00fdch zdroj\u016f pro vykon\u00e1v\u00e1n\u00ed dotaz\u016f.\n<li class=\"l\">  Pro zv\u00fd\u0161en\u00ed v\u00fdkonu komprese a dekomprese tabulek TOAST byl parametr &#171;default_toast_compression&#187; nastaven na hodnotu &#171;lz4&#187;.\n<li class=\"l\"> Podpora autentizace pomoc\u00ed protokolu RADIUS byla odstran\u011bna.\n<li class=\"l\"> V p\u0159\u00edkazu &#171;vacuumdb &#8212;analyze-only&#187; je ve v\u00fdchoz\u00edm nastaven\u00ed zahrnut anal\u00fdza sekciovan\u00fdch tabulek.<\/ul>\n<p>Kv\u016fli probl\u00e9m\u016fm zji\u0161t\u011bn\u00fdm v z\u00e1v\u011bre\u010dn\u00e9 f\u00e1zi testov\u00e1n\u00ed nebyly do vyd\u00e1n\u00ed zahrnuty n\u011bkter\u00e9 funkce p\u0159edstaven\u00e9 v beta verzi, jako je syntax &#171;GROUP BY ALL&#187;, podpora netextov\u00fdch form\u00e1t\u016f v\u00fdstupu v pg_dumpall, SQL\/PGQ pro grafov\u00e9 dotazy, zapnut\u00ed za b\u011bhu podpory kontroln\u00edch sou\u010dt\u016f bez restartu a op\u011btovn\u00e9ho inicializov\u00e1n\u00ed, v\u00fdraz &#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; pro reorganizaci sekciovan\u00fdch tabulek, nastaven\u00ed LC_COLLATE na hodnotu &#171;C&#187; pro proces postmaster a nov\u00e9 funkce pg_get_role_ddl(), pg_get_tablespace_ddl() a pg_get_database_ddl(). Sponzorem zpr\u00e1vy je spole\u010dnost Hi-Kvadr\u00e1t, v\u00fdvoj\u00e1\u0159 Low Code platformy XSQUARE na PostgreSQL (reklama, s.r.o. &#171;Hi-Kvadr\u00e1t&#187;, I\u010c 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\/cs\/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=\"cs_CZ\" \/>\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\/cs\/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\udd47Uvoln\u011bn\u00ed datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 19 | ProHoster","description":"Po roce v\u00fdvoje byla zve\u0159ejn\u011bna nov\u00e1 stabiln\u00ed v\u011btev datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 19. Aktualizace pro novou v\u011btev budou vyd\u00e1v\u00e1ny po dobu p\u011bti let do listopadu 2031.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/postgresql-19-released","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/184329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=184329"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/184329\/revisions"}],"predecessor-version":[{"id":184330,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/184329\/revisions\/184330"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=184329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=184329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=184329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}