{"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\/hr\/blog\/news\/reliz-subd-postgresql-17","title":{"rendered":"Objavljen je PostgreSQL 17","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nakon godine dana razvoja objavljena je nova stabilna verzija sustava za upravljanje podacima PostgreSQL 17. A\u017euriranja za novu verziju izlazit \u0107e tijekom idu\u0107ih pet godina do studenog 2029. godine. Podr\u0161ka za PostgreSQL 12.x, najstariju od podr\u017eavanih verzija, bit \u0107e okon\u010dana 14. studenog.     <\/p>\n<p>Glavne novine:  <\/p>\n<ul>\n<li class=\"l\"> Tijekom izvo\u0111enja operacije VACUUM (sakupljanje sme\u0107a, \u010di\u0161\u0107enje i pakiranje diska) uvedena je nova struktura podataka koja tro\u0161i do 20 puta manje memorije. Prijelaz na novu strukturu omogu\u0107io je ubrzanje izvo\u0111enja operacija VACUUM i smanjenje kori\u0161tenja zajedni\u010dkih resursa.\n<li class=\"l\"> Nastavljena je optimizacija performansi ulaza\/izlaza. Zahvaljuju\u0107i pobolj\u0161anju koda za obradu dnevnika odgo\u0111enog pisanja WAL, pove\u0107ana je propusnost zapisivanja u sustavima s velikim brojem simultanih upita do dva puta. Predlo\u017een je novi su\u010delje za strujni unos\/izlaz, \u0161to je omogu\u0107ilo pove\u0107anje brzine sekvencijalnog pretra\u017eivanja podataka u tablicama i ubrzanje a\u017euriranja statistike za planira\u010d upita nakon izvo\u0111enja operacije ANALYZE.\n<li class=\"l\"> Pove\u0107ana je u\u010dinkovitost upita s izrazom 'IN' kada se koriste indeksi temeljeni na strukturi B-stabla. Omogu\u0107ena je mogu\u0107nost paralelnog izrade BRIN indeksa (Block Range Index). U planeru upita optimizirane su provjere 'NOT NULL' i ubrzana obrada op\u0107ih tabli\u010dnih izraza (Common Table Expression, CTE) definiranih SQL naredbom 'WITH'. Osigurano je kori\u0161tenje vektorskih procesorskih instrukcija (SIMD) za ubrzanje nekih izra\u010duna, na primjer, za ubrzanje funkcije bit_count kori\u0161tene su AVX-512 instrukcije.\n<li class=\"l\"> Uvedena je podr\u0161ka za nove mogu\u0107nosti rada s JSON formatom, odre\u0111enim u standardu SQL\/JSON. Dodana je funkcija JSON-TABLE za pretvaranje podataka iz JSON formata u obi\u010dne PostgreSQL tablice, kao i novi operatori jsonpath za pretvaranje JSON podataka u izvorne PostgreSQL tipove podataka. Predlo\u017eene su nove funkcije za stvaranje (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 naredbe 'MERGE', koja omogu\u0107uje stvaranje uvjetnih SQL izraza koji spajaju operacije INSERT, UPDATE i DELETE u jednom izrazu. Dodana je podr\u0161ka za izraz RETURNING, koji omogu\u0107uje izra\u010dun i vra\u0107anje vrijednosti na temelju dodanih, a\u017euriranih ili uklonjenih redaka. Implementirana je podr\u0161ka za a\u017euriranje prikaza.\n<li class=\"l\"> Pro\u0161irene mogu\u0107nosti u\u010ditavanja i izvoza podataka u serijama. U COPY timu brzina izvoza velikih redaka pove\u0107ana je do dva puta, optimizirano je kopiranje kada se podudara izvorna i ciljana kodiranja, dodana je opcija ON_ERROR koja omogu\u0107ava nastavak uvoza nakon gre\u0161aka prilikom umetanja podataka.\n<li class=\"l\"> Za sekcionirane tablice dodana je mogu\u0107nost kori\u0161tenja stupaca s jedinstvenim identifikatorima i podr\u0161ka za metodu optimizacije upita 'Constraint exclusion'.\n<li class=\"l\"> U mehanizmu povezivanja vanjskih tablica Foreign Data Wrapper (postgres_fdw) implementirana je mogu\u0107nost prenosa na vanjske <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/hr\/server\/\"   title=\"server\" data-wpil-keyword-link=\"linked\">server<\/a> podupitima 'EXISTS' i 'IN'.\n<li class=\"l\"> Implementiran je ugra\u0111eni platformno neovisni motor za obradu svojstava lokalizacije 'Collation', koji se koristi za postavljanje pravila sortiranja i na\u010dina usporedbe uzimaju\u0107i u obzir zna\u010denje simbola (na primjer, prilikom sortiranja ra\u010dunalnih vrijednosti uzima se u obzir prisutnost minus i to\u010dke prije broja te razli\u010diti na\u010dini pisanja, dok se prilikom usporedbe ne uzima u obzir velika slova i prisustvo akcenta). Novi motor osigurava jedinstveno pona\u0161anje pri sortiranju rezultata upita, neovisno o platformi na kojoj se pokre\u0107e PostgreSQL.\n<li class=\"l\"> U mehanizmu logi\u010dke replikacije, koja omogu\u0107ava prijenos promjena u Bazi podataka na drugi poslu\u017eitelj tijekom dodavanja, uklanjanja ili a\u017euriranja zapisa, pojednostavljen je proces a\u017euriranja SUSTAVA. Ako se ranije prilikom prelaska na novo zna\u010dajno izdanje moralo brisati slotove logi\u010dke replikacije i ponovo sinkronizirati podatke, sada je mogu\u0107e bez brisanja slotova. Za konfiguracije otporne na kvar implementirana je mogu\u0107nost upravljanja prebacivanjem na rezervni poslu\u017eitelj (failover) za logi\u010dku replikaciju. Dodana je nova alatna komanda pg_createsubscriber za pretvaranje fizi\u010dke replike u novu logi\u010dku repliku.\n<li class=\"l\"> Dodana je nova opcija 'sslnegotiation' za izravno pregovaranje o za\u0161ti\u0107enim TLS vezama kori\u0161tenjem TLS pro\u0161irenja ALPN.\n<li class=\"l\"> Implementirana je unaprijed definirana uloga pg_maintain, koja korisniku daje pravo izvo\u0111enja operacija vezanih uz odr\u017eavanje RDBMS-a.\n<li class=\"l\"> U utilitu pg_basebackup, koja se koristi za izradu rezervnih kopija baza podataka, dodana je podr\u0161ka za inkrementalne sigurnosne kopije. Kako bi se rekonstruirala puna sigurnosna kopija iz skupa inkrementalnih kopija, predlo\u017eena je nova utilita pg_combinebacku. U utilitu pg_dump dodana je opcija '--filter' za odabir objekata koji \u0107e biti uklju\u010deni u iskop.\n<li class=\"l\"> Prilikom analize zahtjeva pomo\u0107u SQL naredbe <strong>EXPLAIN<\/strong> implementirano je prikazivanje vremena utro\u0161enog na \u010ditanje i pisanje lokalnih blokova prilikom ulaza\/izlaza. Naredbi <strong>EXPLAIN<\/strong> tako\u0111er su dodane dvije nove opcije <strong>MEMORY<\/strong> i <strong>SERIALIZE<\/strong>, pomo\u0107u kojih se mo\u017ee odrediti veli\u010dina kori\u0161tene memorije i vrijeme utro\u0161eno na pretvaranje podataka za prijenos mre\u017eom.\n<li class=\"l\"> Osigurana je indikacija napretka izvr\u0161enja operacije VACUUM s indeksima.\n<li class=\"l\"> Dodano je sustavno prikazivanje pg_wait_events, koje u kombinaciji s prikazom pg_stat_activity omogu\u0107uje detaljnije prou\u010davanje razloga za\u0161to 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\/hr\/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=\"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 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\/hr\/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 RDBMS-a PostgreSQL 17 | ProHoster","description":"Nakon godine dana razvoja objavljena je nova stabilna verzija RDBMS-a PostgreSQL 17. A\u017euriranja za novu verziju izlazit \u0107e pet godina do studenog 2029. godine.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-17","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 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\/hr\/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\/hr\/wp-json\/wp\/v2\/posts\/119954","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=119954"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/119954\/revisions"}],"predecessor-version":[{"id":173068,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/119954\/revisions\/173068"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=119954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=119954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=119954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}