{"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\/sl\/blog\/news\/postgresql-19-released","title":{"rendered":"Izpustitev SDB PostgreSQL 19","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Po letu razvoja je javna nova stabilna razli\u010dica SGBD PostgreSQL 19. Posodobitve za novo razli\u010dico bodo izhajale pet let do novembra 2031. Podpora za PostgreSQL 14.x, trenutno najstarej\u0161o med podprtimi razli\u010dicami, se ta mesec kon\u010duje. Izid je bil objavljen skoraj dva meseca pozneje, kot je bilo prvotno na\u010drtovano, zaradi nenavadno velikega \u0161tevila poro\u010dil o napakah, ugotovljenih s pomo\u010djo AI orodij pri analizi kode.       <\/p>\n<p>Glavne novosti:     <\/p>\n<ul>\n<li class=\"l\"> Izbolj\u0161ana je bila izvedba podsistema asinhronega vnosa\/izvoza, ki omogo\u010da pove\u010danje prepustnosti vnosa\/izvoza in odpravo zakasnitev. V univerzalni izvedbi AIO (io_method=worker) je dodana mo\u017enost samodejnega pove\u010devanja ali zmanj\u0161evanja \u0161tevila delujo\u010dih procesov za obdelavo vnosa\/izvoza glede na obremenitev. Predlagani so parametri io_min_workers, io_max_workers, io_worker_idle_timeout in io_worker_launch_interval za dolo\u010ditev minimalnega in maksimalnega \u0161tevila delujo\u010dih procesov ter zakasnitve pred za\u010detkom procesov.\n<p>Poleg tega je na\u010drtovalnik v AIO, ki uporablja predvidevanje branja, optimiziran za izbolj\u0161anje uspe\u0161nosti poizvedb, ki zahtevajo nalaganje velike koli\u010dine podatkov z diska. Optimizacija je izvedena z adaptivno dolo\u010ditvijo sprejemljivega \u0161tevila operacij predvidevanja branja, odvisno od narave in velikosti poizvedbe (na primer, za operacije skeniranja velikih tabel in indeksov se predhodno nalo\u017ei ve\u010d podatkov z diska). Za analizo izvajanja vhodno\/izhodnih operacij v asinhronem na\u010dinu je bila ukazu \u201eEXPLAIN ANALYZE\u201c dodana mo\u017enost \u201eIO\u201c.      <\/p>\n<li class=\"l\"> Dodani sta bili raz\u0161iritvi pg_plan_advice in pg_stash_advice za posredovanje na\u010drtovalniku poizvedb parametrov-nasvetov v mini jeziku \u201eplan advice\u201c, ki omogo\u010dajo vpliv na izbiro izvajalskih na\u010drtov, zabele\u017eitev izbranih na\u010drtov in eksperimentiranje z razli\u010dnimi na\u010drti. Za pridobitev seznama parametrov, ki jih je izbral na\u010drtovalnik pri izvajanju poizvedbe, je bila ukazu EXPLAIN dodana mo\u017enost \u201ePLAN_ADVICE\u201c, za nastavljanje lastnih parametrov pred izvajanjem poizvedbe pa je mogo\u010de uporabiti izraz \u201eSET pg_plan_advice.advice = 'niz s seznamom parametrov'\u201c. Raz\u0161iritev pg_stash_advice dopolnjuje pg_plan_advice z mo\u017enostmi za vezavo parametrov na identifikatorje poizvedb, da jih ni treba dodajati pred vsakim poizvedbo. EXPLAIN (COSTS OFF, PLAN_ADVICE) SELECT * FROM join_fact f JOIN join_dim d ON f.dim_id = d.id; \u2026 Generirani nasveti za na\u010drt: 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\"> V proces samodejnega pro\u017eanja \u010di\u0161\u010denja (autovacuum) je bila dodana mo\u017enost paralelne uporabe ve\u010d obdelovalcev pri izvajanju \u010di\u0161\u010denja indeksov. \u0160tevilo obdelovalcev se nastavi prek mo\u017enosti autovacuum_max_parallel_workers. Prav tako so bile dodane nove mo\u017enosti autovacuum_vacuum_score_weight, autovacuum_vacuum_insert_score_weight in autovacuum_analyze_score_weight za dolo\u010danje prednosti \u010di\u0161\u010denja tabel.\n<li class=\"l\"> Uvedena je bila nova strategija \u010di\u0161\u010denja, ki omogo\u010da zmanj\u0161anje obsega dela v prihodnosti z posodabljanjem karte vidnosti strani med skeniranjem tabel pri izvajanju SELECT poizvedb, ne da bi \u010dakali na zagon ukaza VACUUM.\n<li class=\"l\"> Dodana je nova SQL ukazna beseda \u201eREPACK\u201c za ponovno gradnjo tabel z manj\u0161imi re\u017eijskimi stro\u0161ki. Ukaz REPACK popolnoma prepi\u0161e vsebino tabele v novo datoteko na disku, kar omogo\u010da operacijskemu sistemu, da sprosti prostor na disku, ki ga zasedajo neuporabljeni bloki. V nasprotju z ukazom \u201eVACUUM FULL\u201c, ki med prepisovanjem postavi strogo zaklepanje, ukaz REPACK vsebuje mo\u017enost \u201eCONCURRENTLY\u201c, s katero je med ponovno pakiranjem dovoljeno uporabo tabele z drugimi transakcijami. V nasprotju z raz\u0161iritvijo pg_repack, je REPACK precej hitrej\u0161i, saj ne pripenja dodatnih spro\u017eilcev k tabeli, ne podpira pa obdelave celotno razdeljenih tabel.\n<li class=\"l\"> Produktivnost operacije INSERT je pove\u010dana do dvakrat za tabele, pri katerih se izvajajo preverjanja zapisov po zunanjih klju\u010dih (Foreign Key). Pospe\u0161ek je dose\u017een z uporabo indeksa za preverjanje zunanjega klju\u010da, kar je omog\u010dilo izognitev zahtevnemu notranjemu poizvedovanju v tabeli.\n<li class=\"l\"> \u041f\u0440\u043e\u0433\u0440\u0430\u043c\u0443 \u0437\u0430 \u0437\u0430\u043f\u0438\u0442\u0430\u043c\u0438 \u0440\u043e\u0437\u0448\u0438\u0440\u0435\u043d\u043e: \u0442\u0435\u043f\u0435\u0440 \u0440\u043e\u0437\u043f\u0456\u0437\u043d\u0430\u044e\u0442\u044c\u0441\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0456\u0457 Anti-Join (\u0432\u0438\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044f \u0440\u044f\u0434\u043a\u0456\u0432 \u0437 \u043f\u0435\u0440\u0448\u043e\u0457 \u0442\u0430\u0431\u043b\u0438\u0446\u0456, \u0434\u043b\u044f \u044f\u043a\u0438\u0445 \u0432\u0456\u0434\u0441\u0443\u0442\u043d\u0456 \u0437\u0431\u0456\u0433\u0438 \u0443 \u0434\u0440\u0443\u0433\u0456\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u0456) \u0443 \u0441\u043a\u043b\u0430\u0434\u043d\u0438\u0445 \u0437\u0430\u043f\u0438\u0442\u0430\u0445 \u0456\u0437 'LEFT JOIN' \u0442\u0430 \u0443 \u0437\u0430\u043f\u0438\u0442\u0430\u0445 \u0456\u0437 \u0432\u0438\u0440\u0430\u0437\u0430\u043c\u0438 'NOT IN' \u0434\u043b\u044f \u0437\u0430\u0441\u0442\u043e\u0441\u0443\u0432\u0430\u043d\u043d\u044f \u0441\u043f\u0435\u0446\u0438\u0444\u0456\u0447\u043d\u0438\u0445 \u043e\u043f\u0442\u0438\u043c\u0456\u0437\u0430\u0446\u0456\u0439. \u0420\u043e\u0437\u0448\u0438\u0440\u0435\u043d\u043e \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u0430\u043d\u043d\u044f \u0456\u043d\u043a\u0440\u0435\u043c\u0435\u043d\u0442\u043d\u043e\u0433\u043e \u0441\u043e\u0440\u0442\u0443\u0432\u0430\u043d\u043d\u044f. \u0414\u043e\u0434\u0430\u043d\u043e \u043e\u043f\u0442\u0438\u043c\u0456\u0437\u0430\u0446\u0456\u044e 'eager aggregation', \u044f\u043a\u0430 \u043f\u0435\u0440\u0435\u043d\u043e\u0441\u0438\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0456\u0457 \u0430\u0433\u0440\u0435\u0433\u0443\u0432\u0430\u043d\u043d\u044f \u043d\u0430 \u0441\u0442\u0430\u0434\u0456\u044e \u0434\u043e \u0437\u043b\u0438\u0442\u0442\u044f \u0442\u0430\u0431\u043b\u0438\u0446\u044c, \u0449\u043e\u0431 \u0437\u043c\u0435\u043d\u0448\u0438\u0442\u0438 \u043a\u0456\u043b\u044c\u043a\u0456\u0441\u0442\u044c \u0440\u044f\u0434\u043a\u0456\u0432, \u0449\u043e \u043e\u0431\u0440\u043e\u0431\u043b\u044f\u044e\u0442\u044c\u0441\u044f \u043f\u0456\u0434 \u0447\u0430\u0441 \u0437\u043b\u0438\u0442\u0442\u044f. \u041f\u0440\u0438\u0441\u043a\u043e\u0440\u0435\u043d\u043e \u043f\u0430\u0440\u0430\u043b\u0435\u043b\u044c\u043d\u0435 \u0432\u0438\u043a\u043e\u043d\u0430\u043d\u043d\u044f \u043e\u043f\u0435\u0440\u0430\u0446\u0456\u0439 \u043f\u043e\u0441\u043b\u0456\u0434\u043e\u0432\u043d\u043e\u0433\u043e \u0441\u043a\u0430\u043d\u0443\u0432\u0430\u043d\u043d\u044f (parallel seq scan). \u0420\u0435\u0430\u043b\u0456\u0437\u043e\u0432\u0430\u043d\u043e \u0441\u043a\u043e\u0440\u043e\u0447\u0435\u043d\u043d\u044f \u043a\u043e\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0456\u0439 'IS DISTINCT FROM' \u0456 'IS NOT DISTINCT FROM' \u0434\u043e \u0432\u0438\u0440\u0430\u0437\u0456\u0432 \u0437 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430\u043c\u0438 '' \u0456 '=', \u044f\u043a\u0449\u043e \u043e\u0431\u0438\u0434\u0432\u0430 \u043e\u043f\u0435\u0440\u0430\u043d\u0434\u0438 \u043d\u0435 \u043c\u043e\u0436\u0443\u0442\u044c \u043f\u0440\u0438\u0439\u043c\u0430\u0442\u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044f NULL.\n<li class=\"l\"> U\u010dinkovitost dostave obvestil s pomo\u010djo ukaza NOTIFY je izbolj\u0161ana v konfiguracijah z ve\u010d kanali obvestil. V skupni pomnilnik je sedaj shranjena karta kanalov, ki omogo\u010da naslavljanje samo na zadnje, prijavljene na dolo\u010den kanal.\n<li class=\"l\"> \u0414\u043e \u043a\u043e\u043c\u0430\u043d\u0434\u0438 'INSERT' \u0434\u043e\u0434\u0430\u043d\u043e \u043f\u0456\u0434\u0442\u0440\u0438\u043c\u043a\u0443 \u0432\u0438\u0440\u0430\u0437\u0443 ON CONFLICT DO SELECT ... RETURNING, \u044f\u043a\u0438\u0439 \u043f\u043e\u0432\u0435\u0440\u0442\u0430\u0454 \u0437\u0430\u043f\u0438\u0441\u0438 \u0443 \u0440\u0430\u0437\u0456 \u043d\u0435\u043c\u043e\u0436\u043b\u0438\u0432\u043e\u0441\u0442\u0456 \u0457\u0445 \u0434\u043e\u0434\u0430\u0432\u0430\u043d\u043d\u044f \u0447\u0435\u0440\u0435\u0437 'INSERT', \u043d\u0430 \u0434\u043e\u0434\u0430\u0442\u043e\u043a \u0434\u043e \u0432\u0438\u0440\u0430\u0437\u0456\u0432 'ON CONFLICT DO NOTHING\/UPDATE', \u044f\u043a\u0456 \u043c\u043e\u0432\u0447\u043a\u0438 \u0456\u0433\u043d\u043e\u0440\u0443\u044e\u0442\u044c \u043a\u043e\u043d\u0444\u043b\u0456\u043a\u0442\u0438 \u043f\u0440\u0438 \u0432\u0441\u0442\u0430\u0432\u0446\u0456 \u0430\u0431\u043e \u0432\u0438\u043a\u043e\u043d\u0443\u044e\u0442\u044c \u043e\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f \u0437\u0430\u043c\u0456\u0441\u0442\u044c \u0432\u0441\u0442\u0430\u0432\u043a\u0438.\n<li class=\"l\"> Ukazu COPY je dodana podpora za izhod podatkov v formatu JSON.\n<li class=\"l\"> V jezik SQL\/JSON so dodane metode za obdelavo nizov lower(), upper(), replace(), split_part() in btrim().\n<li class=\"l\"> \u0423 \u0432\u0456\u043a\u043e\u043d\u043d\u0438\u0445 \u0444\u0443\u043d\u043a\u0446\u0456\u044f\u0445 lead(), lag(), first_value(), last_value() \u0456 nth_value() \u0434\u043e\u0434\u0430\u043d\u043e \u043f\u0456\u0434\u0442\u0440\u0438\u043c\u043a\u0443 \u0432\u0438\u0440\u0430\u0437\u0443 'IGNORE NULLS' \u0434\u043b\u044f \u043f\u0440\u043e\u043f\u0443\u0441\u043a\u0443 \u0437\u043d\u0430\u0447\u0435\u043d\u044c NULL.\n<li class=\"l\"> \u0414\u043e\u0434\u0430\u043d\u043e \u043a\u043e\u043c\u0430\u043d\u0434\u0443 'WAIT FOR LSN', \u044f\u043a\u0430 \u043f\u0440\u0438 \u0430\u0441\u0438\u043d\u0445\u0440\u043e\u043d\u043d\u0456\u0439 \u0440\u0435\u043f\u043b\u0456\u043a\u0430\u0446\u0456\u0457 \u0434\u043e\u0437\u0432\u043e\u043b\u044f\u0454 \u043f\u0440\u0438 \u0437\u0443\u043f\u0438\u043d\u0435\u043d\u043d\u0456 SELECT-\u0437\u0430\u043f\u0438\u0442\u0443 \u043d\u0430 \u0440\u0435\u043f\u043b\u0456\u043a\u043e\u0432\u0430\u043d\u043e\u043c\u0443 \u0441\u0435\u0440\u0432\u0435\u0440\u0456 \u0447\u0435\u043a\u0430\u0442\u0438, \u043f\u043e\u043a\u0438 \u0437\u043c\u0456\u043d\u0438 \u0437 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0433\u043e \u043d\u0435 \u0431\u0443\u0434\u0443\u0442\u044c \u0437\u0430\u0441\u0442\u043e\u0441\u043e\u0432\u0430\u043d\u0456, \u0449\u043e\u0431 \u0443\u043d\u0438\u043a\u043d\u0443\u0442\u0438 \u0432\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044f \u0437\u0430\u0441\u0442\u0430\u0440\u0456\u043b\u0438\u0445 \u0434\u0430\u043d\u0438\u0445. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sl\/server\/dts-los-angeles\/\"   title=\"stre\u017enika\" data-wpil-keyword-link=\"linked\">stre\u017enika<\/a>, ki ustrezajo dolo\u010deni LSN-polo\u017eaju (Log Sequence Number) v WAL-dnevniki.\n<li class=\"l\"> Funkcija random() je dobila podr\u0161ku za tipove date i timestamp za generisanje slu\u010dajnih datuma i vremena u zadanom opsegu.\n<li class=\"l\"> Dodana mogu\u0107nost kreiranja funkcija na jeziku PL\/Python za okida\u010de doga\u0111aja (event trigger).\n<li class=\"l\"> dodana podr\u0161ka za TLS pro\u0161irenje SNI (Server Name Indication) za kori\u0161\u0107enje TLS sertifikata u vezi sa imenima hostova na koje se klijent obra\u0107a prilikom uspostavljanja enkriptovane veze preko jedne IP adrese. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/sl\/server\/\"   title=\"stre\u017enik\" data-wpil-keyword-link=\"linked\">stre\u017enik<\/a> U konfiguracioni fajl postgresql.conf dodat je parametar password_expiration_warning_threshold, pomo\u0107u kojeg se mo\u017ee podesiti prikaz upozorenja o predstoje\u0107em isteku vremena va\u017eenja lozinke.\n<li class=\"l\"> Podrazumevano je uklju\u010deno prikazivanje upozorenja pri kori\u0161\u0107enju MD5 algoritma prilikom autentifikacije, koji je progla\u0161en zastarelim. Za isklju\u010divanje takvih upozorenja dodat je parametar md5_password_warnings.\n<li class=\"l\"> Dodati su prikazi: \u201epg_stat_lock\u201c za pregled nagomilanih statistika o blokadama vezano za tipove blokada; \u201epg_stat_recovery\u201c za informacije o stanju operacija oporavka; \u201epg_stat_autovacuum_scores\u201c za odre\u0111ivanje prioriteta obrade tabela u autovacuum. U mnogim sistemskim prikazima dodat je stupac \u201estats_reset\u201c, koji pokazuje vreme poslednjeg resetovanja broja\u010da. U prikaze \u201epg_stat_progress_vacuum\u201c i \u201epg_stat_progress_analyze\u201c dodat je stupac \u201estarted_by\u201c, koji prikazuje inicijatora operacije. U prikaz pg_stat_progress_vacuum dodat je stupac \u201emode\u201c, koji prikazuje primenjeni re\u017eim \u010di\u0161\u0107enja.\n<li class=\"l\"> \u0414\u043e\u0434\u0430\u043d\u043e \u043f\u043e\u0434\u0430\u043d\u043d\u044f: 'pg_stat_lock' \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u0433\u043b\u044f\u0434\u0443 \u043d\u0430\u043a\u043e\u043f\u0438\u0447\u0435\u043d\u043e\u0457 \u0441\u0442\u0430\u0442\u0438\u0441\u0442\u0438\u043a\u0438 \u043f\u0440\u043e \u0431\u043b\u043e\u043a\u0443\u0432\u0430\u043d\u043d\u044f \u0437 \u043f\u0440\u0438\u0432'\u044f\u0437\u043a\u043e\u044e \u0434\u043e \u0442\u0438\u043f\u0456\u0432 \u0431\u043b\u043e\u043a\u0443\u0432\u0430\u043d\u044c; 'pg_stat_recovery' \u0434\u043b\u044f \u043e\u0442\u0440\u0438\u043c\u0430\u043d\u043d\u044f \u0456\u043d\u0444\u043e\u0440\u043c\u0430\u0446\u0456\u0457 \u043f\u0440\u043e \u0441\u0442\u0430\u043d \u043e\u043f\u0435\u0440\u0430\u0446\u0456\u0439 \u0432\u0456\u0434\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f; 'pg_stat_autovacuum_scores' \u0434\u043b\u044f \u0432\u0438\u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044f \u043f\u0440\u0456\u043e\u0440\u0438\u0442\u0435\u0442\u0443 \u043e\u0431\u0440\u043e\u0431\u043a\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044c \u0443 autovacuum. \u0423 \u0431\u0430\u0433\u0430\u0442\u043e \u0441\u0438\u0441\u0442\u0435\u043c\u043d\u0438\u0445 \u043f\u043e\u0434\u0430\u043d\u044c \u0434\u043e\u0434\u0430\u043d\u043e \u0441\u0442\u043e\u0432\u043f\u0435\u0446\u044c 'stats_reset', \u0443 \u044f\u043a\u043e\u043c\u0443 \u0432\u0456\u0434\u043e\u0431\u0440\u0430\u0436\u0430\u0454\u0442\u044c\u0441\u044f \u043e\u0441\u0442\u0430\u043d\u043d\u0456\u0439 \u0447\u0430\u0441 \u043e\u0447\u0438\u0449\u0435\u043d\u043d\u044f \u043b\u0456\u0447\u0438\u043b\u044c\u043d\u0438\u043a\u0456\u0432. \u0423 \u043f\u043e\u0434\u0430\u043d\u043d\u044f 'pg_stat_progress_vacuum' \u0456 'pg_stat_progress_analyze' \u0434\u043e\u0434\u0430\u043d\u043e \u0441\u0442\u043e\u0432\u043f\u0435\u0446\u044c 'started_by', \u0443 \u044f\u043a\u043e\u043c\u0443 \u0432\u0456\u0434\u043e\u0431\u0440\u0430\u0436\u0430\u0454\u0442\u044c\u0441\u044f \u0456\u043d\u0456\u0446\u0456\u0430\u0442\u043e\u0440 \u043e\u043f\u0435\u0440\u0430\u0446\u0456\u0457. \u0423 \u043f\u043e\u0434\u0430\u043d\u043d\u0456 pg_stat_progress_vacuum \u0434\u043e\u0434\u0430\u043d\u043e \u0441\u0442\u043e\u0432\u043f\u0435\u0446\u044c 'mode', \u044f\u043a\u0438\u0439 \u0432\u0456\u0434\u043e\u0431\u0440\u0430\u0436\u0430\u0454 \u0437\u0430\u0441\u0442\u043e\u0441\u043e\u0432\u0443\u0432\u0430\u043d\u0438\u0439 \u0440\u0435\u0436\u0438\u043c \u043e\u0447\u0438\u0449\u0435\u043d\u043d\u044f.\n<li class=\"l\"> U statistiku koja se prikazuje posle operacija VACUUM i ANALYZE, kao i u prikaz \u201epg_stat_wal\u201c, dodate su informacije o veli\u010dini zabele\u017eenih punih stranica u WAL log-u, \u0161to olak\u0161ava razumevanje razloga prekomernog rasta WAL log-a (mo\u017ee se razumeti da li je rast povezan sa kori\u0161\u0107enjem parametra full_page_writes).\n<li class=\"l\"> V statistiko, prikazano po operacijah VACUUM in ANALYZE, ter v predstavitvi &lt;pg_stat_wal&gt;, so dodane informacije o velikosti zapisov v WAL-logging celotnih strani, kar poenostavi razumevanje razlogov za prekomerno rast WAL-logging (lahko ugotovite, ali je rast povezana z uporabo parametra full_page_writes).\n<li class=\"l\"> V mehanizmu logi\u010dne replikacije je bila implementirana podpora za replikacijo vrednosti zaporedij (SEQUENCE), ki jih je mogo\u010de objaviti z ukazom &lt;CREATE PUBLICATION&gt; s pomo\u010djo izraza &lt;FOR ALL SEQUENCES&gt;.\n<li class=\"l\"> Dodana je sintaksa &lt;CREATE PUBLICATION \u2026 EXCEPT&gt; za replikacijo vseh tabel, razen tistih, ki so izrecno navedene.\n<li class=\"l\"> Dodana je izjava &lt;CREATE SUBSCRIPTION \u2026 SERVER&gt;, ki omogo\u010da ustvarjanje naro\u010dnin logi\u010dne replikacije, pri \u010demer se nastavitve povezovanja pridobyjo od zunanjega stre\u017enika.\n<li class=\"l\"> Dodana je mo\u017enost omogo\u010danja logi\u010dne replikacije v \u017eivo brez ponovnega zagonitve stre\u017enika, tudi \u010de je parameter &lt;wal_level&gt; nastavljen na vrednost &lt;replica&gt; namesto &lt;logical&gt;. Za dolo\u010ditev dejansko veljavnega nivoja bele\u017eenja, ki ni povezan z nastavitvijo wal_level v konfiguracijski datoteki, je dodan parameter &lt;effective_wal_level&gt;.\n<li class=\"l\"> U mehanizmu povezivanja spolja\u0161njih tabela Foreign Data Wrapper (postgres_fdw) implementirane su mogu\u0107nosti za prosle\u0111ivanje operacija sa nizovima na udaljeni server i dodat je parametar import_stats za uvoz statistike za tabele sa spoljnog servera prilikom izvo\u0111enja komande ANALYZE radi pove\u0107anja efikasnosti lokalnog planiranja izvr\u0161enja upita.\n<li class=\"l\"> Podrazumevano je isklju\u010dena JIT-kompilacija jer primetne dobitke u performansama donosi uglavnom za te\u0161ke analiti\u010dke upite, dok u obi\u010dnim OLTP optere\u0107enjima mo\u017ee dovesti do propada u performansama zbog gre\u0161aka u predvi\u0111anju resursa potrebnih za izvr\u0161enje upita.\n<li class=\"l\">  Za pove\u010danje zmogljivosti stiskanja in razpakiranja TOAST-tabel je parameter &lt;default_toast_compression&gt; nastavljen na vrednost &lt;lz4&gt;.\n<li class=\"l\"> Uklonjena je podr\u0161ka za autentifikaciju koriste\u0107i RADIUS protokol.\n<li class=\"l\"> V ukazu &lt;vacuumdb \u2014analyze-only&gt; je privzeto vklju\u010den pregled sekcioniranih tabel.<\/ul>\n<p>Zaradi te\u017eav, ugotovljenih v kon\u010dni fazi testiranja, so v razli\u010dico vstopile nekatere mo\u017enosti, predstavljene v beta razli\u010dici, kot so sintaksa &lt;GROUP BY ALL&gt;, podpora netekstovnim formatom izhoda v pg_dumpall, SQL\/PGQ za poizvedbe grafov, vklju\u010ditev podpore za kontrolne vsote v \u017eivo brez ponovnega zagona in ponovne inicializacije, izjava &lt;FOR PORTION OF&gt; v UPDATE in DELETE, izrazi &lt;ALTER TABLE \u2026 MERGE PARTITIONS&gt; in &lt;ALTER TABLE \u2026 SPLIT PARTITIONS&gt; za reorganizacijo sekcioniranih tabel ter nastavitev LC_COLLATE na vrednost &lt;C&gt; za proces postmaster in nove funkcije pg_get_role_ddl(), pg_get_tablespace_ddl() in pg_get_database_ddl(). Sponzor novice je podjetje Hi-Kvadraat, razvijalec Low Code platforme XSQUARE na PostgreSQL (ogla\u0161evanje, d.o.o. &lt;Hi-Kvadraat&gt;, dav\u010dna \u0161tevilka 7718990614).<br \/>\n<br \/>Izvor: <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\/sl\/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=\"sl_SI\" \/>\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\/sl\/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\udd47Izdaja DBMS PostgreSQL 19 | ProHoster","description":"Nakon godine dana razvoja, objavljena je nova stabilna grana DBMS PostgreSQL 19. A\u017euriranja za novu granu izlazi\u0107e tokom pet godina do novembra 2031. godine.","canonical_url":"https:\/\/prohoster.info\/sl\/blog\/news\/postgresql-19-released","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sl_SI","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\/sl\/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\/sl\/wp-json\/wp\/v2\/posts\/184329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/comments?post=184329"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/184329\/revisions"}],"predecessor-version":[{"id":184330,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/posts\/184329\/revisions\/184330"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/media?parent=184329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/categories?post=184329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sl\/wp-json\/wp\/v2\/tags?post=184329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}