{"id":144010,"date":"2025-09-25T17:11:55","date_gmt":"2025-09-25T15:11:55","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-18"},"modified":"2025-09-25T17:11:55","modified_gmt":"2025-09-25T15:11:55","slug":"reliz-subd-postgresql-18","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-18","title":{"rendered":"Izlazak sustava za upravljanje podacima PostgreSQL 18","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nakon godine razvoja objavljena je nova stabilna verzija baze podataka PostgreSQL 18. A\u017euriranja za novu verziju izlazit \u0107e tijekom sljede\u0107ih pet godina do studenog 2030. godine. Podr\u0161ka za PostgreSQL 13.x, najstariju od podr\u017eanih verzija, prestaje 13. studenog.     <\/p>\n<p>Glavne novine:  <\/p>\n<ul>\n<li class=\"l\"> Dodana je podsustav za asinkrono ulaz\/izlaz, koji omogu\u0107uje pove\u0107anje propusnosti ulaz\/izlaza i eliminiranje zastoja. Osim dostupne univerzalne implementacije AIO (io_method=worker) koja se temelji na izvo\u0111enju vi\u0161e radnih procesa (zadano 3), u Linuxu se mo\u017ee koristiti su\u010delje za asinkrono ulaz\/izlaz io_uring (io_method=io_uring), podr\u017eano od kernela Linux 5.1. Asinkroni ulaz\/izlaz jo\u0161 je uvijek anga\u017eiran samo za ubrzanje izvr\u0161enja nekih operacija vezanih uz \u010ditanje podataka iz datote\u010dnog sustava, poput sekvencijalnog pretra\u017eivanja, skeniranja bitmap indeksa i provodi \u010di\u0161\u0107enje (vacuum). U nekim testovima primjena AIO dovela je do pove\u0107anja performansi 2-3 puta. Operacije pisanja nastavljaju se izvoditi u sinkronom na\u010dinu kako bi se zadovoljili ACID zahtjevi.\n<li class=\"l\"> Optimizirana je funkcionalnost &#171;skip scan&#187; u vi\u0161ekolumnim indeksima, \u0161to omogu\u0107uje kori\u0161tenje indeksa ne samo za provjeru prve indeksirane kolone i potpunog povezivanja kolona, ve\u0107 i za pojedina\u010dno obra\u0111ivanje ostalih indeksiranih kolona. Na primjer, ranije je B-tree indeks koji se koristi za kolone &#171;(status, date)&#187; bio primjenjiv samo za upite koji provjeravaju polje &#171;status&#187; ili oba polja &#171;status&#187; i &#171;date&#187;, dok je za provjeru samo polja &#171;date&#187; bilo potrebno skeniranje sadr\u017eaja tablice. Na\u010din &#171;skip scan&#187; omogu\u0107ava u odre\u0111enim situacijama skeniranje indeksa samo prilikom upita za polje &#171;date&#187;. Ovaj na\u010din se primjenjuje samo na &#171;B-tree&#187; indekse kada se koristi uvjetni operator &#171;=&#187; nad indeksiranim poljem, u situacijama kada propu\u0161teno polje ima mali broj razli\u010ditih vrijednosti (na primjer, optimizacija \u0107e raditi ako polje status &#171;status&#187; ima nekoliko fiksnih vrijednosti).\n<li class=\"l\"> Dodane su optimizacije koje u\u010dinkovitije koriste indekse za upite koji sadr\u017ee konstrukcije &#171;OR&#187; i &#171;IN (&#8230;)&#187; u bloku &#171;WHERE&#187;, kao i one koje pobolj\u0161avaju u\u010dinkovitost planiranja i izvr\u0161enja spajanja tablica (na primjer, ubrzan je kod za spajanje he\u0161ova i omogu\u0107ena je inkrementalna sortiranja tokom spajanja tablica).\n<li class=\"l\"> Dodana podr\u0161ka za paralelizaciju izgradnje GIN indeksa (Generalized Inverted Index), koji se koriste za indeksiranje slo\u017eenih vrijednosti, kao \u0161to su nizovi, i organizaciju pretra\u017eivanja po punom tekstu ili strukturama JSON.\n<li class=\"l\"> Dodana je mogu\u0107nost kreiranja materializiranih prikaza i klju\u010deva za particioniranje tablica s indeksima ozna\u010denim kao &#171;unique&#187;, koji ne koriste B-tree strukturu.\n<li class=\"l\"> Pove\u0107ana je ukupna u\u010dinkovitost zaklju\u010davanja za upite koji rade s velikim brojem tablica, a tako\u0111er su unesena pobolj\u0161anja u obradi upita na sekcioniranim tablicama, \u0161to ubrzava filtriranje neiskori\u0161tenih sekcija i operacije spajanja (JOIN).\n<li class=\"l\"> Ubrzane su operacije s tekstom, kao \u0161to su funkcije za prebacivanje u velika\/mala slova. Dodan je na\u010din PG_UNICODE_FAST za ubrzavanje uzimanja u obzir svojstava lokalnih Unicode simbola.\n<li class=\"l\"> Implementirana je mogu\u0107nost \u010duvanja statistike planera upita nakon a\u017euriranja izme\u0111u zna\u010dajnih izdanja PostgreSQL-a. Ova promjena omogu\u0107ava izbjegavanje izvo\u0111enja resursno intenzivne operacije &#171;ANALYZE&#187; nakon pokretanja nove verzije, nakon koje je uo\u010dena degradacija performansi DBMS-a.\n<li class=\"l\"> Pove\u0107ana je u\u010dinkovitost alata pg_upgrade, koji se koristi za automatizaciju prijelaza na novo zna\u010dajno izdanje PostgreSQL-a. Optimizacije su posebno vidljive prilikom nadogradnje baza podataka koje sadr\u017ee veliki broj objekata, kao \u0161to su tablice i sekvence. Kako bi se ubrzalo kori\u0161tenje pg_upgrade, dodana su i nova opcija &#171;&#8212;jobs N&#187; za paralelizaciju provjera u N niti i opcija &#171;&#8212;swap&#187; za potpuno zamjenjivanje direktorija s podacima bez postavljanja poveznica, bez kloniranja i bez kopiranja datoteka.\n<li class=\"l\"> Dodana je podr\u0161ka za virtualne generirane stupce \u010dije se vrijednosti ra\u010dunaju u trenutku izvr\u0161avanja upita, bez pohrane na disk. Ako se u izrazu &#171;CREATE TABLE&#8230;&#187; za generirane stupce koristi samo klju\u010dna rije\u010d &#171;GENERATED&#187; bez navo\u0111enja tipa (STORED ili VIRTUAL), novi oblik se primjenjuje kao zadani umjesto stare implementacije. U staroj implementaciji, vrijednosti su se generirale tijekom izvr\u0161avanja operacija &#171;INSERT&#187; ili &#171;UPDATE&#187; i pohranjivale su se na disk za daljnju upotrebu. Nedostatak virtualnih generiranih stupaca je nemogu\u0107nost njihove upotrebe u indeksima, dok je prednost mogu\u0107nost normalizacije i promjene podataka u trenutku (\u0161to je va\u017eno pri radu s JSON podacima). \u0160to se ti\u010de klasi\u010dnih pohranjenih generiranih stupaca, nova verzija pru\u017ea podr\u0161ku za logi\u010dku replikaciju.\n<li class=\"l\"> U naredbama INSERT, UPDATE, DELETE i MERGE implementirana je mogu\u0107nost ispisivanja prethodnih (OLD) i trenutnih (CURRENT) vrijednosti u izrazu RETURNING. Na primjer, &#171;UPDATE&#8230; RETURNING WITH (OLD AS o, NEW AS n) o.*, n.*.&#187;\n<li class=\"l\"> Dodana je funkcija uuidv7() za generiranje slu\u010dajnih jedinstvenih identifikatora u formatu UUIDv7. Za razliku od stare funkcije za generiranje UUID-a (gen_random_uuid), koja je sada dodatno dostupna pod imenom uuidv4(), UUIDv7 uklju\u010duje vrijeme generacije uz slu\u010dajnu vrijednost. Prisutnost ure\u0111enih dijelova u vrijednosti UUID (prvih 12 znakova \u2014 epoha vremena, a sljede\u0107ih 18 \u2014 slu\u010dajna vrijednost) pobolj\u0161ava u\u010dinkovitost sortiranja i indeksiranja, \u0161to je va\u017eno s obzirom na to da se UUID obi\u010dno koriste za primarne klju\u010deve (na primjer, klju\u010devi stvoreni u bliskom vremenu postavljaju se jedni pored drugih u indeksu).\n<li class=\"l\"> U operaciji &#171;LIKE&#187; implementirana je podr\u0161ka za usporedbe s tekstom u kojima se koriste nedeterministi\u010dke zna\u010dajke lokalizacije &#171;collation&#187;, omogu\u0107uju\u0107i usporedbe uzimaju\u0107i u obzir zna\u010denje simbola (na primjer, kod usporedbe se mo\u017ee zanemariti naglasak). Dodana je funkcija CASEFOLD za promjenu registra simbola uzimaju\u0107i u obzir zna\u010dajke lokalizacije &#171;collation&#187; (na primjer, neki simboli imaju vi\u0161e od dva mala oblika ili u usporedbi zahtijevaju pretvorbu u velika slova, a ne u mala).\n<li class=\"l\"> Dodana je mogu\u0107nost kori\u0161tenja vremenskih ograni\u010denja (temporal constraint). U vrijednostima &#171;PRIMARY KEY&#187; i &#171;UNIQUE&#187; za dodavanje vremenskih ograni\u010denja treba koristiti izraz &#171;WITHOUT OVERLAPS&#187;, a u vrijednosti &#171;FOREIGN KEY&#187; \u2014 izraz PERIOD. Na primjer, prilikom definiranja primarnih klju\u010deva mogu\u0107e je ograni\u010diti klju\u010deve s preklapaju\u0107im vremenskim intervalima.\n<li class=\"l\"> Dodana je naredba &#171;CREATE FOREIGN TABLE &#8230; LIKE command&#187; za stvaranje sheme vanjske tablice na temelju definicije lokalne tablice.\n<li class=\"l\"> Dodana je podr\u0161ka za povezivanje s DBMS-om koriste\u0107i autentikaciju temeljem OAUTH 2.0 s primjenom tokena pristupa umjesto lozinke. Kori\u0161tenje OAUTH omogu\u0107uje nepohranjivanje lozinki u Bazi podataka, identifikaciju korisnika putem vanjskih servisa, kao i kori\u0161tenje mogu\u0107nosti poput dvofaktorske autentifikacije i jedinstvene to\u010dke pristupa (SSO).\n<li class=\"l\"> Dodana je funkcija ssl_tls13_ciphers(), preko koje se mo\u017ee odrediti popis algoritama \u0161ifriranja dozvoljenih pri povezivanju koriste\u0107i protokol TLSv1.3.\n<li class=\"l\"> U kategoriju zastarjelih i planiranih za uklanjanje preba\u010dena je podr\u0161ka za autentikaciju koriste\u0107i algoritam md5 za he\u0161iranje lozinki. Umjesto md5 preporu\u010duje se koristiti algoritam SCRAM (SCRAM-SHA-256), koji je uveden u PostgreSQL 10. Dodatno se isti\u010de implementacija podr\u0161ke za preusmjeravanje autentikacije temeljem SCRAM prilikom povezivanja putem postgres_fdw i dblink na vanjske PostgreSQL servere.\n<li class=\"l\"> Prilikom izvo\u0111enja operacije &#171;EXPLAIN ANALYZE&#187; osigurano je ispisivanje informacija o broju pretra\u017eivanja u indeksima prilikom skeniranja indeksa i broju pristupa buferima tijekom izvr\u0161avanja upita. U ispis &#171;EXPLAIN ANALYZE VERBOSE&#187; uklju\u010dena je statistika o CPU-u, WAL-logs i intenzitetu operacija \u010ditanja. U tablicu pg_stat_all_tables dodane su informacije o vremenu potro\u0161enom na operaciju VACUUM i analizu tablica. Osigurana je statistika o intenzitetu ulaza\/izlaza i optere\u0107enju WAL-logs prema pojedina\u010dnim vezama. U pg_stat_subscription_stats i zapisima dodane su informacije s dijagnostikom sukoba prilikom izvr\u0161avanja operacija pisanja tijekom logi\u010dke replikacije.\n<li class=\"l\"> U novim instalacijama uklju\u010dena je prema zadanim postavkama upotreba kontrolnih zbrojeva za provjeru cjelovitosti pohranjenih podataka. Za poni\u0161tavanje ovog pona\u0161anja prilikom pokretanja initdb treba navesti opciju &#171;&#8212;no-data-checksums&#187;.\n<li class=\"l\"> U alat pg_createsubscriber dodana je zastavica &#171;&#8212;all&#187; za stvaranje logi\u010dkih replika jednim naredbom odjednom za sve baze podataka.\n<li class=\"l\"> Implementirana je nova verzija (3.2) protokola koji se koristi za interakciju vanjskih alata s DBMS-om i realizirana je u biblioteci libpq. Posljednje a\u017euriranje protokola izvedeno je u PostgreSQL 7.4 (2003. godina). U biblioteci libpq i dalje se koristi verzija 3.0 po defaultu.          <\/ul>\n<p>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=63877\">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 18. \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 2030 \u0433\u043e\u0434\u0430. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 PostgreSQL 13.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, \u0431\u0443\u0434\u0435\u0442 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430 13 \u043d\u043e\u044f\u0431\u0440\u044f. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043d\u043e\u0432\u0448\u0435\u0441\u0442\u0432\u0430: \u0414\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0434\u0441\u0438\u0441\u0442\u0435\u043c\u0430 \u0430\u0441\u0438\u043d\u0445\u0440\u043e\u043d\u043d\u043e\u0433\u043e \u0432\u0432\u043e\u0434\u0430\/\u0432\u044b\u0432\u043e\u0434\u0430, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0430\u044f \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0442\u044c \u043f\u0440\u043e\u043f\u0443\u0441\u043a\u043d\u0443\u044e \u0441\u043f\u043e\u0441\u043e\u0431\u043d\u043e\u0441\u0442\u044c \u0432\u0432\u043e\u0434\u0430\/\u0432\u044b\u0432\u043e\u0434\u0430 \u0438 \u0438\u0437\u0431\u0430\u0432\u0438\u0442\u044c\u0441\u044f \u043e\u0442 \u0437\u0430\u0434\u0435\u0440\u0436\u0435\u043a. \u041f\u043e\u043c\u0438\u043c\u043e \u0434\u043e\u0441\u0442\u0443\u043f\u043d\u043e\u0439 \u043d\u0430 \u0432\u0441\u0435\u0445 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-144010","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 18. \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 2030 \u0433\u043e\u0434\u0430.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-18\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"hr_HR\" \/>\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 18 | 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 18. \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 2030 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-18\" \/>\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=\"2025-09-25T15:11:55+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-09-25T15:11:55+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Izdanje DBMS-a PostgreSQL 18 | ProHoster","description":"Nakon godine dana razvoja objavljena je nova stabilna grana DBMS-a PostgreSQL 18. A\u017euriranja za novu granu izlazit \u0107e u narednih pet godina do novembra 2030. godine.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-18","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hr_HR","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 18 | 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 18. \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 2030 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-18","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":"2025-09-25T15:11:55+00:00","article:modified_time":"2025-09-25T15:11:55+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"144010","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-23 14:59:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 14:59:19","updated":"2026-01-23 14:59:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/144010","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/comments?post=144010"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/144010\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=144010"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=144010"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=144010"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}