{"id":105303,"date":"2022-10-13T21:36:41","date_gmt":"2022-10-13T19:36:41","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/reliz-subd-postgresql-15"},"modified":"2022-10-13T21:36:41","modified_gmt":"2022-10-13T19:36:41","slug":"reliz-subd-postgresql-15","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-15","title":{"rendered":"Izlaz PostgreSQL 15","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nakon godinu dana razvoja, objavljena je nova stabilna verzija SDB-a PostgreSQL 15. A\u017euriranja za novu verziju izlazit \u0107e tijekom pet godina do studenog 2027.     <\/p>\n<p>Glavne novine:  <\/p>\n<ul>\n<li class=\"l\"> Dodana je podr\u0161ka za SQL naredbu \u00abMERGE\u00bb, koja podsje\u0107a na izraz \u00abINSERT \u2026 ON CONFLICT\u00bb. MERGE omogu\u0107ava stvaranje uvjetnih SQL izraza koji objedinjuju u jednom izrazu operacije INSERT, UPDATE i DELETE. Na primjer, uz pomo\u0107 MERGE mogu\u0107e je organizirati spajanje dviju tablica, umetnuti nedostaju\u0107e zapise i a\u017eurirati postoje\u0107e. MERGE INTO customer_account ca USING recent_transactions t ON t.customer_id = ca.customer_id WHEN MATCHED THEN UPDATE SET balance = balance + transaction_value WHEN NOT MATCHED THEN INSERT (customer_id, balance) VALUES (t.customer_id, t.transaction_value);\n<li class=\"l\"> Significantly improved sorting algorithms for data in memory and on disk. Depending on the data type, tests show sorting speed increases from 25% to 400%.\n<li class=\"l\"> Zna\u010dajno je ubrzan rad prozorskih funkcija koriste\u0107i row_number(), rank(), dense_rank() i count().\n<li class=\"l\"> Implementirana je mogu\u0107nost paralelnog izvr\u0161avanja upita s izrazom \u00abSELECT DISTINCT\u00bb.\n<li class=\"l\"> U mehanizmu povezivanja vanjskih tablica Foreign Data Wrapper (postgres_fdw) implementirana je podr\u0161ka za asinkrone potvrde uz prethodno dodanu mogu\u0107nost asinkronog obrade upita prema vanjskim poslu\u017eiteljima.\n<li class=\"l\"> Dodana je mogu\u0107nost primjene algoritama LZ4 i Zstandard (zstd) za kompresiju WAL logova transakcija, \u0161to u nekim optere\u0107enjima omogu\u0107ava istovremeno pove\u0107anje performansi i u\u0161tedu diskovnog prostora. Za smanjenje vremena oporavka nakon kvara dodana je podr\u0161ka za proaktivno va\u0111enje stranica koje se nalaze u WAL logu.\n<li class=\"l\"> U utilitu pg_basebackup dodana je podr\u0161ka za kompresiju datoteka sa sigurnosnim kopijama na strani, koriste\u0107i metode gzip, LZ4 ili zstd. Omogu\u0107ena je mogu\u0107nost kori\u0161tenja vlastitih modula za arhiviranje, \u0161to omogu\u0107ava izbjegavanje pokretanja shell komandi. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/hr\/server\/dts-los-angeles\/\"   title=\"poslu\u017eitelja\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3862\">poslu\u017eitelja<\/a>Dodana je serija novih funkcija za obradu nizova koriste\u0107i regularne izraze: regexp_count(), regexp_instr(), regexp_like() i regexp_substr().\n<li class=\"l\"> U funkciju range_agg() dodana je mogu\u0107nost agregiranja multidimenzionalnih tipova (\u2018multirange\u2019).\n<li class=\"l\"> Funkciji range_agg() dodana je mogu\u0107nost agregiranja vi\u0161edijapazonskih tipova (\u00abmultirange\u00bb).\n<li class=\"l\"> Dodane su nove opcije za rad s kontekstima koji osiguravaju dostupnost prihoda, poput prava za izvo\u0111enje na osnovu korisnika koji poziva.\n<li class=\"l\"> Za logi\u010dku replikaciju implementirana je podr\u0161ka za filtriranje redaka i definiranje lista stupaca, \u0161to omogu\u0107uje da po\u0161iljatelj izdvoji podskup podataka za replikaciju iz tablice. Osim toga, u novoj verziji pojednostavljeno je upravljanje sukobima, na primjer, dodana je mogu\u0107nost preskakanja sukobljenih transakcija i automatskog isklju\u010divanja pretplate prilikom otkrivanja gre\u0161ke. Prilikom logi\u010dke replikacije dopu\u0161tena je upotreba dvofaznih potvrda (2PC).\n<li class=\"l\"> Dodan je novi format logova \u2014 jsonlog, koji \u010duva informacije u strukturiranom obliku koriste\u0107i JSON format.\n<li class=\"l\"> Administratoru je omogu\u0107eno delegiranje odre\u0111enih ovlasti korisnicima za promjenu odre\u0111enih parametara. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/hr\/server\/\"   title=\"konfiguracije servera\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"999\">konfiguracije servera<\/a> PostgreSQL.\n<li class=\"l\"> U alat psql dodana je podr\u0161ka za pretra\u017eivanje informacija o postavkama (pg_settings) pomo\u0107u naredbe \u00abdconfig\u00bb.\n<li class=\"l\"> Osigurana je upotreba dijeljene memorije za prikupljanje statistike o radu poslu\u017eitelja, \u0161to je omogu\u0107ilo uklanjanje zasebnog procesa za prikupljanje statistike i periodi\u010dno spremanje stanja na disk.\n<li class=\"l\">  Omogu\u0107ena je upotreba ICU lokalizacijskih postavki \u00abICU Collation\u00bb kao zadanih, dosad se kao zadana lokalizacija mogla koristiti samo libc lokalizacija.\n<li class=\"l\"> Predlo\u017eeno je ugra\u0111eno pro\u0161irenje pg_walinspect, koje omogu\u0107ava inspekciju sadr\u017eaja WAL log datoteka putem SQL upita.\n<li class=\"l\"> Za shemu public povu\u010dene su ovlasti za izvr\u0161avanje naredbe CREATE za sve korisnike osim vlasnika Baze podataka.\n<li class=\"l\"> U PL\/Python uklonjena je podr\u0161ka za Python 2. Uklonjen je zastarjeli ekskluzivni na\u010din rezervnog kopiranja (\u00abexclusive backup\u00bb).    <\/ul>\n<p>Dodatak: Od 19:00 do 20:00 (MSK) odr\u017eat \u0107e se webinar o promjenama nove verzije s Pavlom Luzanovim (Postgres Professional). Za sve koji ne mogu prisustvovati prijenosu, dostupna je snimka lipanjskog izlaganja Pavla \u00abPostgreSQL 15: MERGE i ne samo to\u00bb na PGConf.Russia.<br \/>\n<br \/>Izvor: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=57914\">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 15. \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 2027 \u0433\u043e\u0434\u0430. \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\u0434\u0435\u0440\u0436\u043a\u0430 SQL-\u043a\u043e\u043c\u0430\u043d\u0434\u044b &#171;MERGE&#187;, \u043d\u0430\u043f\u043e\u043c\u0438\u043d\u0430\u044e\u0449\u0435\u0439 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 &#171;INSERT &#8230; ON CONFLICT&#187;. MERGE \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0443\u0441\u043b\u043e\u0432\u043d\u044b\u0435 SQL-\u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f, \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u044f\u044e\u0449\u0438\u0435 \u0432 \u043e\u0434\u043d\u043e\u043c \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 INSERT, UPDATE \u0438 DELETE. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 MERGE \u043c\u043e\u0436\u043d\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-105303","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.4 - 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 15. \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 2027 \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-15\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.4\" \/>\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 15 | 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 15. \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 2027 \u0433\u043e\u0434\u0430.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-15\" \/>\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=\"2022-10-13T19:36:41+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-10-13T19:36:41+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 PostgreSQL 15 | ProHoster","description":"Nakon godine dana razvoja objavljena je nova stabilna grana DBMS PostgreSQL 15. A\u017euriranja za novu granu izlazit \u0107e tijekom pet godina do studenog 2027. godine.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-15","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 15 | 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 15. \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 2027 \u0433\u043e\u0434\u0430.","og:url":"https:\/\/prohoster.info\/hr\/blog\/news\/reliz-subd-postgresql-15","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":"2022-10-13T19:36:41+00:00","article:modified_time":"2022-10-13T19:36:41+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"105303","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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-02-08 21:30:13","updated":"2026-02-22 15:31:03","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\/105303","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=105303"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/105303\/revisions"}],"predecessor-version":[{"id":162390,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/105303\/revisions\/162390"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=105303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=105303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=105303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}