{"id":119954,"date":"2024-09-26T21:43:01","date_gmt":"2024-09-26T19:43:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-17"},"modified":"2024-09-26T21:43:01","modified_gmt":"2024-09-26T19:43:01","slug":"reliz-subd-postgresql-17","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/news\/reliz-subd-postgresql-17","title":{"rendered":"Vyd\u00e1n\u00ed SGBD PostgreSQL 17","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Po roce v\u00fdvoje byla vyd\u00e1na nov\u00e1 stabiln\u00ed verze datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 17. Aktualizace pro tuto novou verzi budou vych\u00e1zet po dobu p\u011bti let do listopadu 2029. Podpora PostgreSQL 12.x, nejstar\u0161\u00ed z podporovan\u00fdch verz\u00ed, bude ukon\u010dena 14. listopadu.     <\/p>\n<p>Hlavn\u00ed novinky:  <\/p>\n<ul>\n<li class=\"l\"> P\u0159i prov\u00e1d\u011bn\u00ed operace VACUUM (\u00faklid, \u010di\u0161t\u011bn\u00ed a balen\u00ed diskov\u00e9ho \u00falo\u017ei\u0161t\u011b) byla pou\u017eita nov\u00e1 datov\u00e1 struktura, kter\u00e1 spot\u0159ebov\u00e1v\u00e1 a\u017e 20kr\u00e1t m\u00e9n\u011b pam\u011bti. P\u0159echod na tuto novou strukturu umo\u017enil zrychlit prov\u00e1d\u011bn\u00ed operac\u00ed VACUUM a sn\u00ed\u017eit spot\u0159ebu sd\u00edlen\u00fdch zdroj\u016f.\n<li class=\"l\"> Pokra\u010duje optimalizace v\u00fdkonnosti vstupu\/v\u00fdstupu. D\u00edky vylep\u0161en\u00ed k\u00f3du pro zpracov\u00e1n\u00ed logu odlo\u017een\u00e9ho z\u00e1pisu WAL se poda\u0159ilo a\u017e dvakr\u00e1t zv\u00fd\u0161it propustnost z\u00e1pisov\u00fdch operac\u00ed ve syst\u00e9mech s velk\u00fdm po\u010dtem sou\u010dasn\u011b vykon\u00e1van\u00fdch dotaz\u016f. Byl navr\u017een nov\u00fd rozhran\u00ed pro streamov\u00e1n\u00ed vstupu\/v\u00fdstupu, kter\u00e9 zv\u00fd\u0161ilo rychlost sekven\u010dn\u00edho proch\u00e1zen\u00ed dat v tabulk\u00e1ch a urychlilo aktualizaci statistik pro pl\u00e1nova\u010d dotaz\u016f po proveden\u00ed operace ANALYZE.\n<li class=\"l\"> Byla zv\u00fd\u0161ena v\u00fdkonnost dotaz\u016f s v\u00fdrazem 'IN', pokud pou\u017e\u00edvaj\u00ed indexy na z\u00e1klad\u011b struktury B-tree. Byla implementov\u00e1na mo\u017enost paraleln\u00edho vytv\u00e1\u0159en\u00ed index\u016f BRIN (Block Range Index). V pl\u00e1nova\u010di dotaz\u016f byly optimalizov\u00e1ny kontroly 'NOT NULL' a zrychlena zpracov\u00e1n\u00ed obecn\u00e9ho tabulkov\u00e9ho v\u00fdrazu (Common Table Expression, CTE) definovan\u00e9ho pomoc\u00ed SQL p\u0159\u00edkazu 'WITH'. Bylo zaji\u0161t\u011bno vyu\u017eit\u00ed instrukc\u00ed vektorov\u00e9ho procesoru (SIMD) pro urychlen\u00ed n\u011bkter\u00fdch v\u00fdpo\u010dt\u016f, nap\u0159\u00edklad pro urychlen\u00ed funkce bit_count byly pou\u017eity instrukce AVX-512.\n<li class=\"l\"> Byla realizov\u00e1na podpora nov\u00fdch funkc\u00ed pro pr\u00e1ci s form\u00e1tem JSON, definovan\u00fdch ve standardu SQL\/JSON. Byla p\u0159id\u00e1na funkce JSON-TABLE pro p\u0159evod dat z form\u00e1tu JSON na b\u011b\u017en\u00e9 tabulky PostgreSQL a tak\u00e9 nov\u00e9 oper\u00e1tory jsonpath pro p\u0159evod dat JSON na nativn\u00ed datov\u00e9 typy PostgreSQL. Byly navr\u017eeny nov\u00e9 funkce pro vytv\u00e1\u0159en\u00ed (JSON, JSON_SCALAR a JSON_SERIALIZE) a dotazov\u00e1n\u00ed (JSON_EXISTS, JSON_QUERY a JSON_VALUE) dat ve form\u00e1tu JSON.\n<li class=\"l\"> Byly roz\u0161\u00ed\u0159eny mo\u017enosti SQL p\u0159\u00edkazu 'MERGE', kter\u00fd umo\u017e\u0148uje vytv\u00e1\u0159et podm\u00edn\u011bn\u00e9 SQL v\u00fdrazy kombinuj\u00edc\u00ed v jednom v\u00fdrazu operace INSERT, UPDATE a DELETE. Byla p\u0159id\u00e1na podpora v\u00fdrazu RETURNING, kter\u00fd umo\u017e\u0148uje po\u010d\u00edtat a vracet hodnoty na z\u00e1klad\u011b p\u0159idan\u00fdch, aktualizovan\u00fdch nebo odstran\u011bn\u00fdch \u0159\u00e1dk\u016f. Byla realizov\u00e1na podpora aktualizace pohled\u016f.\n<li class=\"l\"> Mo\u017enosti hromadn\u00e9ho na\u010d\u00edt\u00e1n\u00ed a exportu dat byly roz\u0161\u00ed\u0159eny. Rychlost exportu velk\u00fdch \u0159\u00e1dk\u016f v p\u0159\u00edkazu COPY se zv\u00fd\u0161ila a\u017e dvakr\u00e1t, optimalizov\u00e1no je kop\u00edrov\u00e1n\u00ed p\u0159i shod\u011b vstupn\u00ed a c\u00edlov\u00e9 k\u00f3dov\u00e1n\u00ed, byla p\u0159id\u00e1na volba ON_ERROR, kter\u00e1 umo\u017e\u0148uje pokra\u010dovat v importu po chyb\u00e1ch p\u0159i vkl\u00e1d\u00e1n\u00ed dat.\n<li class=\"l\"> Pro partitionovan\u00e9 tabulky byla p\u0159id\u00e1na mo\u017enost pou\u017eit\u00ed sloupc\u016f s jedine\u010dn\u00fdmi identifik\u00e1tory a podpora techniky optimalizace dotaz\u016f 'Constraint exclusion'.\n<li class=\"l\"> V mechanismu p\u0159ipojen\u00ed extern\u00edch tabulek Foreign Data Wrapper (postgres_fdw) byla implementov\u00e1na mo\u017enost p\u0159ed\u00e1v\u00e1n\u00ed na extern\u00ed <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/cs\/server\/\"   title=\"server\" data-wpil-keyword-link=\"linked\">server<\/a> poddotaz\u016f 'EXISTS' a 'IN'.\n<li class=\"l\"> Byl implementov\u00e1n integrovan\u00fd platformov\u011b nez\u00e1visl\u00fd engine pro zpracov\u00e1n\u00ed vlastnost\u00ed locale 'Collation', kter\u00e9 se pou\u017e\u00edvaj\u00ed k ur\u010den\u00ed pravidel \u0159azen\u00ed a metod porovn\u00e1v\u00e1n\u00ed s ohledem na v\u00fdznam symbol\u016f (nap\u0159\u00edklad p\u0159i \u0159azen\u00ed \u010d\u00edseln\u00fdch hodnot se zohled\u0148uje p\u0159\u00edtomnost m\u00ednusu a te\u010dky p\u0159ed \u010d\u00edslem a r\u016fzn\u00e9 zp\u016fsoby z\u00e1pisu, zat\u00edmco p\u0159i porovn\u00e1v\u00e1n\u00ed se nebere v \u00favahu velk\u00e9\/mal\u00e9 p\u00edsmo a p\u0159\u00edtomnost diakritiky). Nov\u00fd engine zaji\u0161\u0165uje jednotn\u00e9 chov\u00e1n\u00ed p\u0159i \u0159azen\u00ed v\u00fdsledk\u016f dotaz\u016f, nez\u00e1visl\u00e9 na tom, na jak\u00e9 platform\u011b je PostgreSQL spu\u0161t\u011bno.\n<li class=\"l\"> V mechanismu logick\u00e9 replikace, kter\u00fd umo\u017e\u0148uje p\u0159en\u00e1\u0161et zm\u011bny proveden\u00e9 v datab\u00e1zi na jin\u00fd server b\u011bhem p\u0159id\u00e1v\u00e1n\u00ed, odstra\u0148ov\u00e1n\u00ed nebo aktualizace z\u00e1znam\u016f, byl zjednodu\u0161en proces aktualizace DBMS. Pokud d\u0159\u00edve p\u0159i p\u0159echodu na novou v\u00fdznamnou verzi bylo nutn\u00e9 odstranit sloty logick\u00e9 replikace a znovu synchronizovat data, nyn\u00ed je mo\u017en\u00e9 se obej\u00edt bez odstra\u0148ov\u00e1n\u00ed slot\u016f. Pro vysoce dostupn\u00e9 konfigurace byla implementov\u00e1na mo\u017enost \u0159\u00edzen\u00ed p\u0159ep\u00edn\u00e1n\u00ed na z\u00e1lo\u017en\u00ed server (failover) pro logickou replikaci. Byla p\u0159id\u00e1na nov\u00e1 utilita pg_createsubscriber pro p\u0159evod fyzick\u00e9 repliky na novou logickou replikaci.\n<li class=\"l\"> Byla p\u0159id\u00e1na nov\u00e1 mo\u017enost 'sslnegotiation' pro p\u0159\u00edm\u00e9 vyjedn\u00e1v\u00e1n\u00ed zabezpe\u010den\u00fdch TLS spojen\u00ed s pou\u017eit\u00edm TLS roz\u0161\u00ed\u0159en\u00ed ALPN.\n<li class=\"l\"> Byla implementov\u00e1na p\u0159eddefinovan\u00e1 role pg_maintain, kter\u00e1 u\u017eivateli ud\u011bluje pr\u00e1vo prov\u00e1d\u011bt operace spojen\u00e9 s \u00fadr\u017ebou DBMS.\n<li class=\"l\"> Do utilit pg_basebackup, pou\u017e\u00edvan\u00e9 pro vytv\u00e1\u0159en\u00ed z\u00e1loh datab\u00e1z\u00ed, byla p\u0159id\u00e1na podpora inkrement\u00e1ln\u00edch z\u00e1loh. Pro rekonstrukci \u00fapln\u00e9 z\u00e1lohy z mno\u017einy inkrement\u00e1ln\u00edch kopi\u00ed byla navr\u017eena nov\u00e1 utilita pg_combinebacku. Do utilit pg_dump byla p\u0159id\u00e1na mo\u017enost '--filter' pro v\u00fdb\u011br objekt\u016f zahrnut\u00fdch do z\u00e1lohy.\n<li class=\"l\"> Anal\u00fdzou dotaz\u016f pomoc\u00ed SQL p\u0159\u00edkazu &#171;EXPLAIN&#187; se zobrazuje doba str\u00e1ven\u00e1 \u010dten\u00edm a z\u00e1pisem lok\u00e1ln\u00edch blok\u016f b\u011bhem vstupu\/v\u00fdstupu. Do p\u0159\u00edkazu &#171;EXPLAIN&#187; byly tak\u00e9 p\u0159id\u00e1ny dv\u011b nov\u00e9 mo\u017enosti &#171;MEMORY&#187; a &#171;SERIALIZE&#187;, pomoc\u00ed kter\u00fdch lze ur\u010dit velikost pou\u017eit\u00e9 pam\u011bti a \u010das str\u00e1ven\u00fd p\u0159evodem dat pro p\u0159enos p\u0159es s\u00ed\u0165.\n<li class=\"l\"> Byla zaji\u0161t\u011bna indikace postupu prov\u00e1d\u011bn\u00ed operace VACUUM s indexy.\n<li class=\"l\"> Bylo p\u0159id\u00e1no syst\u00e9mov\u00e9 zobrazen\u00ed pg_wait_events, kter\u00e9 v kombinaci se zobrazen\u00edm pg_stat_activity umo\u017e\u0148uje podrobn\u011bji prozkoumat d\u016fvody, pro\u010d jsou aktivn\u00ed relace ve stavu \u010dek\u00e1n\u00ed.      <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=61935\">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 17. \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 2029 \u0433\u043e\u0434\u0430. \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 PostgreSQL 12.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 14 \u043d\u043e\u044f\u0431\u0440\u044f. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u043d\u043e\u0432\u0448\u0435\u0441\u0442\u0432\u0430: \u041f\u0440\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 VACUUM (\u0441\u0431\u043e\u0440\u043a\u0430 \u043c\u0443\u0441\u043e\u0440\u0430, \u0447\u0438\u0441\u0442\u043a\u0430 \u0438 \u0443\u043f\u0430\u043a\u043e\u0432\u043a\u0430 \u0434\u0438\u0441\u043a\u043e\u0432\u043e\u0433\u043e \u0445\u0440\u0430\u043d\u0438\u043b\u0438\u0449\u0430) \u0437\u0430\u0434\u0435\u0439\u0441\u0442\u0432\u043e\u0432\u0430\u043d\u0430 \u043d\u043e\u0432\u0430\u044f \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430 \u0434\u0430\u043d\u043d\u044b\u0445, \u043f\u043e\u0442\u0440\u0435\u0431\u043b\u044f\u044e\u0449\u0430\u044f \u0434\u043e [&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-119954","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - 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 17. \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 2029 \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\/cs\/blog\/news\/reliz-subd-postgresql-17\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\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 17 | 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 17. \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 2029 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/cs\/blog\/news\/reliz-subd-postgresql-17\" \/>\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=\"2024-09-26T19:43:01+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-09-26T19:43:01+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\udd47Vyd\u00e1n\u00ed datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 17 | ProHoster","description":"Po roce v\u00fdvoje byla zve\u0159ejn\u011bna nov\u00e1 stabiln\u00ed verze datab\u00e1zov\u00e9ho syst\u00e9mu PostgreSQL 17. Aktualizace pro tuto novou verzi budou vych\u00e1zet po dobu p\u011bti let a\u017e do listopadu 2029.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/reliz-subd-postgresql-17","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 17 | 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 17. \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 2029 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/cs\/blog\/news\/reliz-subd-postgresql-17","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":"2024-09-26T19:43:01+00:00","article:modified_time":"2024-09-26T19:43:01+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"119954","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 06:51:33","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 06:51:33","updated":"2026-01-23 06:51:33","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/119954","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=119954"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/119954\/revisions"}],"predecessor-version":[{"id":173068,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/119954\/revisions\/173068"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=119954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=119954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=119954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}