{"id":116976,"date":"2024-07-06T09:34:41","date_gmt":"2024-07-06T07:34:41","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij"},"modified":"2024-07-06T09:34:41","modified_gmt":"2024-07-06T07:34:41","slug":"postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","status":"publish","type":"post","link":"https:\/\/prohoster.info\/da\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","title":{"rendered":"Postgres Pro Shardman: opdatering af DBMS til store virksomheder","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Postgres Professional, den f\u00f8rende russiske DBMS-udvikler, annoncerer frigivelsen af mindre opdateringer til Postgres Pro Shardman version 14.12.1.<\/p>\n<p> <noindex><noindex><\/p>\n<p><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/products\/shardman\">Postgres Pro Shardman<\/a> \u2014 et nyt distribueret relations-DMS til h\u00f8jtydende systemer, der er velegnet til de st\u00f8rste installationer p\u00e5 titusindvis til hundredevis af TB, n\u00e5r en enkelt server ikke er tilstr\u00e6kkelig. DMS'et g\u00f8r det muligt at opdele data i dele og fordele dem p\u00e5 forskellige servere \u2014 shards. L\u00f8sningen sikrer samtidig indbygget fejltolerance og garanterer overholdelse af ACID-kravene: atomaritet, konsistens, isolering og holdbarhed.<\/p>\n<p><\/noindex><\/noindex> <\/p>\n<p>I den nye version af Postgres Pro Shardman er der tilf\u00f8jet nye funktioner, forbedret ydeevne, og nogle fejl er blevet rettet. Blandt de vigtigste \u00e6ndringer:<\/p>\n<p><strong>Kernen og udvidelser<\/strong><\/p>\n<ul>\n<li>Der er tilf\u00f8jet parameteren REMOTE til EXPLAIN-kommandoen, som tillader output af EXPLAIN for foresp\u00f8rgsler, der k\u00f8res p\u00e5 en fjernserver. Denne parameter er som standard aktiveret.<\/li>\n<li>Der er implementeret en egen logik til vurdering af planens omkostninger. Det giver planl\u00e6ggeren mulighed for oftere at v\u00e6lge generelle planer, n\u00e5r der er lighed mellem en generel og en specialiseret plan.<\/li>\n<li>Der er tilf\u00f8jet support for at undtage sektioner i udf\u00f8relsesprocessen for plan-tr\u00e6kningsnoder, der udf\u00f8rer dataaggregering p\u00e5 eksterne servere. Denne optimering er prim\u00e6rt n\u00f8dvendig for at fjerne sektioner i generelle planer.<\/li>\n<li>Der er tilf\u00f8jet kumulative metrikker for st\u00f8rrelsen af netv\u00e6rkstrafik mellem noderne i Shardman-klusteret i visningen <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/shardman-views.html#SHARDMAN-PG-STAT-NETUSAGE\">shardman.pg_stat_netusage<\/a>.<\/li>\n<li>Visningen pg_stat_activity er blevet opdateret og viser nu status for de processer, der h\u00e5ndterer Shardman.<\/li>\n<\/ul>\n<p><strong>Styringsv\u00e6rkt\u00f8jer<\/strong><\/p>\n<ul>\n<li>S\u00e5rbarhederne CVE-2023-45288 og CVE-2023-44487 er blevet rettet.<\/li>\n<li>En fejl i kommandoen <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-CLEANUP\">shardmanctl cleanup<\/a>, som f\u00f8rte til, at grupper af replikation ikke kunne slettes, er blevet l\u00f8st.<\/li>\n<li>Udf\u00f8relsen af kommandoen <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-FORALL\">shardmanctl forall<\/a> er blevet forbedret, n\u00e5r der ikke er noget resultat.<\/li>\n<li>Fejlen i v\u00e6rkt\u00f8jet <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmand.html\">shardmand<\/a>, der tidligere opstod, hvis Shardman-klusteret ikke var fuldst\u00e6ndig konfigureret, er blevet l\u00f8st.<\/li>\n<\/ul>\n<p>Kilde: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.linux.org.ru\/news\/proprietary\/17653564\">linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1. Postgres Pro Shardman \u2014 \u043d\u043e\u0432\u0430\u044f \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0430\u044f \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u0430\u044f \u0421\u0423\u0411\u0414 \u0434\u043b\u044f \u0432\u044b\u0441\u043e\u043a\u043e\u043d\u0430\u0433\u0440\u0443\u0436\u0435\u043d\u043d\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c, \u043f\u043e\u0434\u0445\u043e\u0434\u0438\u0442 \u0434\u043b\u044f \u043a\u0440\u0443\u043f\u043d\u0435\u0439\u0448\u0438\u0445 \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u044f\u0446\u0438\u0439 \u0432 \u0434\u0435\u0441\u044f\u0442\u043a\u0438 \u0438 \u0441\u043e\u0442\u043d\u0438 \u0422\u0411, \u043a\u043e\u0433\u0434\u0430 \u043e\u0434\u0438\u043d\u043e\u0447\u043d\u043e\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u043d\u0435\u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e. \u0421\u0423\u0411\u0414 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0434\u0435\u043b\u0438\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043d\u0430 \u0447\u0430\u0441\u0442\u0438 \u0438 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u044c \u0438\u0445 \u043f\u043e \u0440\u0430\u0437\u043d\u044b\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u043c \u2014 \u0448\u0430\u0440\u0434\u0430\u043c. \u041f\u0440\u0438 \u044d\u0442\u043e\u043c [&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-116976","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=\"Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1.\" \/>\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\/da\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"da_DK\" \/>\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\udd47Postgres Pro Shardman: \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0421\u0423\u0411\u0414 \u0434\u043b\u044f \u043a\u0440\u0443\u043f\u043d\u044b\u0445 \u043f\u0440\u0435\u0434\u043f\u0440\u0438\u044f\u0442\u0438\u0439 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/da\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij\" \/>\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-07-06T07:34:41+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-07-06T07:34: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\udd47Postgres Pro Shardman: opdatering af DMS til store virksomheder | ProHoster","description":"Postgres Professional, den f\u00f8rende russiske DBMS-udvikler, annoncerer frigivelsen af mindre opdateringer til Postgres Pro Shardman version 14.12.1.","canonical_url":"https:\/\/prohoster.info\/da\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"da_DK","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\udd47Postgres Pro Shardman: \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0421\u0423\u0411\u0414 \u0434\u043b\u044f \u043a\u0440\u0443\u043f\u043d\u044b\u0445 \u043f\u0440\u0435\u0434\u043f\u0440\u0438\u044f\u0442\u0438\u0439 | ProHoster","og:description":"Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1.","og:url":"https:\/\/prohoster.info\/da\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","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-07-06T07:34:41+00:00","article:modified_time":"2024-07-06T07:34:41+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"116976","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 03:36:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 03:36:19","updated":"2026-01-23 03:36:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/116976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/comments?post=116976"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/116976\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=116976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=116976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=116976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}