{"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\/bs\/blog\/news\/reliz-subd-postgresql-17","title":{"rendered":"Objava PostgreSQL 17.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nakon godine razvoja objavljena je nova stabilna grana SGBD PostgreSQL 17. A\u017euriranja za novu granu \u0107e se objavljivati tokom pet godina do novembra 2029. godine. Podr\u0161ka za PostgreSQL 12.x, najstariju od podr\u017eavanih grana, bi\u0107e prekinuta 14. novembra.     <\/p>\n<p>Glavne novine:  <\/p>\n<ul>\n<li class=\"l\"> Tokom izvo\u0111enja operacije VACUUM (sakupljanje sme\u0107a, \u010di\u0161\u0107enje i pakovanje diskovnog skladi\u0161ta) uvedena je nova struktura podataka koja tro\u0161i do 20 puta manje memorije. Prelazak na novu strukturu omogu\u0107io je ubrzanje izvr\u0161enja operacija VACUUM i smanjenje potro\u0161nje zajedni\u010dkih resursa.\n<li class=\"l\"> Nastavljena je optimizacija performansi ulaza\/izlaza. Zahvaljuju\u0107i pobolj\u0161anju koda za obradu loga odlo\u017eene transakcije WAL, postignuta je dvostruka propusnost operacija upisa u sistemima sa velikim brojem aktivnih upita. Predlo\u017een je novo su\u010delje za strimovanje ulaza\/izlaza, \u0161to je pove\u0107alo brzinu sekvencijalnog pretra\u017eivanja podataka u tabelama i ubrzalo a\u017euriranje statistike za planira\u010d upita nakon izvo\u0111enja operacije ANALYZE.\n<li class=\"l\"> Pove\u0107ana je performansa upita sa izrazom 'IN' kada se koriste indeksi bazirani na B-stablima. Implementirana je mogu\u0107nost paralelnog gra\u0111enja BRIN (Block Range Index) indeksa. U planeru upita optimizovane su provere 'NOT NULL' i ubrzana obrada generi\u010dkih tabelarnih izraza (Common Table Expression, CTE) definisanih SQL komandom 'WITH'. Obezbe\u0111eno je kori\u0161\u0107enje instrukcija vektorskog procesora (SIMD) za ubrzavanje odre\u0111enih prora\u010duna, na primer, za ubrzanje funkcije bit_count kori\u0161\u0107ene su AVX-512 instrukcije.\n<li class=\"l\"> Implementirana je podr\u0161ka za nove mogu\u0107nosti rada sa JSON formatom, definisanim u standardu SQL\/JSON. Dodata je funkcija JSON-TABLE za konvertovanje podataka iz JSON formata u obi\u010dne PostgreSQL tabele, kao i novi operateri jsonpath za konvertovanje JSON podataka u prirodne PostgreSQL tipove podataka. Predlo\u017eene su nove funkcije za kreiranje (JSON, JSON_SCALAR i JSON_SERIALIZE) i upit (JSON_EXISTS, JSON_QUERY i JSON_VALUE) podataka u JSON formatu.\n<li class=\"l\"> Pro\u0161irene su mogu\u0107nosti SQL komande 'MERGE', koja omogu\u0107ava kreiranje uslovnih SQL izraza koji u jednom izrazu kombinuju operacije INSERT, UPDATE i DELETE. Dodata je podr\u0161ka za izraz RETURNING, koji omogu\u0107ava izra\u010dunavanje i vra\u0107anje vrednosti na osnovu dodatih, a\u017euriranih ili obrisanih redova. Implementirana je podr\u0161ka za a\u017euriranje prikaza.\n<li class=\"l\"> Pro\u0161irene su mogu\u0107nosti u\u010ditavanja i izvoza podataka u paketnom re\u017eimu. U komandi COPY brzina izvoza velikih redova je pove\u0107ana do dva puta, optimizovano je kopiranje kada se izvornik i ciljne kodne stranice poklapaju, dodana je opcija ON_ERROR koja omogu\u0107ava nastavak uvoza nakon gre\u0161aka prilikom umetanja podataka.\n<li class=\"l\"> Za sekcionisane tabele dodana je mogu\u0107nost kori\u0161\u0107enja kolona sa jedinstvenim identifikatorima i podr\u0161ka za tehniku optimizacije upita 'Constraint exclusion'.\n<li class=\"l\"> U mehanizmu povezivanja spolja\u0161njih tabela Foreign Data Wrapper (postgres_fdw) omogu\u0107ena je proslijediti na spolja\u0161nji <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/bs\/server\/\"   title=\"server\" data-wpil-keyword-link=\"linked\">server<\/a> podupitima 'EXISTS' i 'IN'.\n<li class=\"l\"> Implementiran je ugra\u0111eni platformno nezavisni motor za obradu svojstava lokaliteta 'Collation', koji se koriste za postavljanje pravila sortiranja i metoda pore\u0111enja uzimaju\u0107i u obzir zna\u010denje simbola (na primer, prilikom sortiranja numeri\u010dkih vrednosti uzima se u obzir prisustvo minus i ta\u010dke pre broja i razli\u010diti na\u010dini pisanja, dok se prilikom pore\u0111enja ne uzima u obzir velika i mala slova i prisustvo naglaska). Novi motor garantuje jedinstveno pona\u0161anje prilikom sortiranja rezultata upita, nezavisno od toga na kojoj platformi se PostgreSQL pokre\u0107e.\n<li class=\"l\"> U mehanizmu logi\u010dke replikacije, koji omogu\u0107ava prenos promena na drugi server koje su napravljene u Bazi podataka tokom dodavanja, brisanja ili a\u017euriranja zapisa, pojednostavljen je proces a\u017euriranja SGBD-a. Dok je ranije bilo potrebno ukloniti slotove logi\u010dke replikacije i ponovo sinhronizovati podatke prilikom prelaska na novu zna\u010dajnu verziju, sada se mo\u017ee obi\u0107i bez uklanjanja slotova. Za konfiguracije otpornosti na gre\u0161ke omogu\u0107ena je opcija upravljanja prebacivanjem na rezervni server (failover) za logi\u010dku replikaciju. Dodata je nova alatka pg_createsubscriber za pretvaranje fizi\u010dke replike u novu logi\u010dku repliku.\n<li class=\"l\"> Dodata je nova opcija 'sslnegotiation' za direktno dogovoranje za\u0161ti\u0107enih TLS veza koriste\u0107i TLS ekstenziju ALPN.\n<li class=\"l\"> Implementirana je unaprijed definirana uloga pg_maintain, koja korisniku daje pravo na obavljanje operacija vezanih uz odr\u017eavanje DBMS-a.\n<li class=\"l\"> U alat pg_basebackup, koji se koristi za pravljenje rezervnih kopija Baze Podataka, dodata je podr\u0161ka za inkrementalne bekape. Za rekonstrukciju pune rezervne kopije iz seta inkrementalnih kopija predlo\u017eena je nova alatka pg_combinebackup. U alat pg_dump dodata je opcija '--filter' za odabir objekata koji \u0107e biti uklju\u010deni u dump.\n<li class=\"l\"> Prilikom analize zahteva pomo\u0107u SQL komande &lt;EXPLAIN&gt; omogu\u0107en je prikaz vremena utro\u0161enog na \u010ditanje i pisanje lokalnih blokova prilikom ulaza\/izlaza. U komandu &lt;EXPLAIN&gt; tako\u0111e su dodane dve nove opcije &lt;MEMORY&gt; i &lt;SERIALIZE&gt;, pomo\u0107u kojih je mogu\u0107e odrediti veli\u010dinu kori\u0161\u0107ene memorije i vreme utro\u0161eno na transformaciju podataka za prenos preko mre\u017ee.\n<li class=\"l\"> Osigurana je indikacija napretka izvr\u0161enja operacije VACUUM s indeksima.\n<li class=\"l\"> Dodano je sistemsko prikazivanje pg_wait_events, koje u kombinaciji s prikazom pg_stat_activity omogu\u0107ava dublje prou\u010davanje uzroka zbog kojih aktivne sesije \u010dekaju.      <\/ul>\n<p>Izvor: <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.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 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\/bs\/blog\/news\/reliz-subd-postgresql-17\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.5.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"bs_BA\" \/>\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\/bs\/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\udd47Izdanje DBMS-a PostgreSQL 17 | ProHoster","description":"Nakon godine dana razvoja objavljena je nova stabilna grana DBMS-a PostgreSQL 17. A\u017euriranja za novu granu \u0107e izlaziti tokom pet godina do novembra 2029. godine.","canonical_url":"https:\/\/prohoster.info\/bs\/blog\/news\/reliz-subd-postgresql-17","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"bs_BA","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\/bs\/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\/bs\/wp-json\/wp\/v2\/posts\/119954","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/comments?post=119954"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/119954\/revisions"}],"predecessor-version":[{"id":173068,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/119954\/revisions\/173068"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/media?parent=119954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/categories?post=119954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/tags?post=119954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}