{"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\/bs\/blog\/news\/reliz-subd-postgresql-15","title":{"rendered":"Izdanje SBB-a PostgreSQL 15","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Nakon godine razvoja, objavljena je nova stabilna verzija SDB PostgreSQL 15. A\u017euriranja za novu verziju bi\u0107e dostupna tokom pet godina do novembra 2027. godine.     <\/p>\n<p>Glavne novine:  <\/p>\n<ul>\n<li class=\"l\"> Dodana je podr\u0161ka za SQL komandu \u201eMERGE\u201c, koja podsje\u0107a na izraz \u201eINSERT \u2026 ON CONFLICT\u201c. MERGE omogu\u0107ava kreiranje uslovnih SQL izraza koji kombinuju jednim izrazom operacije INSERT, UPDATE i DELETE. Na primer, pomo\u0107u MERGE mo\u017eete organizovati spajanje dve tabele, umetnuv\u0161i nedostaju\u0107e zapise i a\u017euriraju\u0107i 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\"> Signifikantno su pobolj\u0161ani algoritmi za sortiranje podataka u memoriji i na disku. U zavisnosti od tipa podataka, u testovima se prime\u0107uje pove\u0107anje brzine sortiranja od 25% do 400%.\n<li class=\"l\"> Ubrzana je obrada prozorskih funkcija koriste\u0107i row_number(), rank(), dense_rank() i count().\n<li class=\"l\"> Implementirana je mogu\u0107nost paralelno izvr\u0161avanje upita s izrazom \u201eSELECT DISTINCT\u201c.\n<li class=\"l\"> U mehanizmu povezivanja spolja\u0161njih tabela Foreign Data Wrapper (postgres_fdw) implementirana je podr\u0161ka za asinhrone komite, pored ranije dodate mogu\u0107nosti asinhrone obrade upita ka spoljnim serverima.\n<li class=\"l\"> Dodana je mogu\u0107nost primene algoritama LZ4 i Zstandard (zstd) za kompresiju WAL logova transakcija, \u0161to u nekim uslovima omogu\u0107ava istovremeno pove\u0107anje performansi i \u0161tednju prostora na disku. Da bi se skratio vreme oporavka nakon pada, dodata je podr\u0161ka za proaktivno izvla\u010denje stranica koje se nalaze u WAL logu.\n<li class=\"l\"> Alatu pg_basebackup dodata je podr\u0161ka za kompresiju fajlova sa rezervnim kopijama na strani, koriste\u0107i metode gzip, LZ4 ili zstd. Omogu\u0107ena je primena vlastitih modula za arhiviranje, \u0161to elimini\u0161e potrebu za pokretanjem shell komandi. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/bs\/server\/dts-los-angeles\/\"   title=\"servera\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3862\">servera<\/a>Dodana je serija novih funkcija za obradu stringova 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 tipova vi\u0161edomenih (\u201emultirange\u201c).\n<li class=\"l\"> Funkciji range_agg() dodana je mogu\u0107nost agregiranja multirangiranih tipova (\u201emultirange\u201c).\n<li class=\"l\"> Dodana je opcija security_invoker, koja omogu\u0107ava kreiranje pregleda koji se izvr\u0161avaju sa pravima pozivatelja, a ne stvaraoca pregleda.\n<li class=\"l\"> Za logi\u010dku replikaciju implementirana je podr\u0161ka za filtriranje redova i postavljanje lista kolona, \u0161to omogu\u0107ava da se na strani po\u0161iljaoca izdvoji podskup podataka iz tabele za replikaciju. Pored toga, u novoj verziji pojednostavljeno je upravljanje konfliktima, na primer, uvedena je mogu\u0107nost preskakanja konfliktnih transakcija i automatskog isklju\u010divanja pretplate prilikom otkrivanja gre\u0161ke. Tokom logi\u010dke replikacije dozvoljena 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 da delegira korisnicima odre\u0111ena ovla\u0161\u0107enja za izmene odre\u0111enih parametara. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/bs\/server\/\"   title=\"konfiguraciji servera\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"999\">konfiguraciji servera<\/a> PostgreSQL.\n<li class=\"l\"> U utilitu psql dodana je podr\u0161ka za pretra\u017eivanje informacija o pode\u0161avanjima (pg_settings) pomo\u0107u komande \u201e\\dconfig\u201c.\n<li class=\"l\"> Obezbe\u0111eno je kori\u0161\u0107enje deljene memorije za prikupljanje statistike o radu servera, \u0161to je omogu\u0107ilo uklanjanje zasebnog procesa prikupljanja statistike i periodi\u010dnog prepisivanja stanja na disk.\n<li class=\"l\">  Omogu\u0107eno je kori\u0161\u0107enje podrazumevanih ICU lokaliteta \u201eICU Collation\u201c, ranije je kao lokalitet po defaultu mogla da se koristi samo libc lokalitet.\n<li class=\"l\"> Predlo\u017eeno je ugra\u0111eno pro\u0161irenje pg_walinspect, koje omogu\u0107ava inspekciju sadr\u017eaja datoteka sa WAL logovima pomo\u0107u SQL upita.\n<li class=\"l\"> Za \u0161emu public, svim korisnicima, osim vlasniku Baze podataka, oduzeta su ovla\u0161\u0107enja za izvr\u0161enje komande CREATE.\n<li class=\"l\"> U PL\/Python uklonjena je podr\u0161ka za Python 2. Uklonjen je zastareli ekskluzivni re\u017eim rezervnog kopiranja (\u201eexclusive backup\u201c).    <\/ul>\n<p>Dopuna: Od 19:00 do 20:00 (MSK) odr\u017ea\u0107e se vebinar-diskusija o promenama nove verzije sa Pavlom Luzanovim (Postgres Professional). Za one koji ne mogu da se pridru\u017ee, otvorena je snimka junskog izlaganja Pavla \u201ePostgreSQL 15: MERGE i ne samo to\u201c 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.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 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\/bs\/blog\/news\/reliz-subd-postgresql-15\" \/>\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 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\/bs\/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 SDB PostgreSQL 15 | ProHoster","description":"Nakon godine razvoja, objavljena je nova stabilna grana SDB PostgreSQL 15. A\u017euriranja za novu granu \u0107e se izdavati tokom pet godina do novembra 2027. godine.","canonical_url":"https:\/\/prohoster.info\/bs\/blog\/news\/reliz-subd-postgresql-15","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 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\/bs\/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\/bs\/wp-json\/wp\/v2\/posts\/105303","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=105303"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/105303\/revisions"}],"predecessor-version":[{"id":162390,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/posts\/105303\/revisions\/162390"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/media?parent=105303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/categories?post=105303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/bs\/wp-json\/wp\/v2\/tags?post=105303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}