{"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\/de\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","title":{"rendered":"Postgres Pro Shardman: Datenbank-Update f\u00fcr Gro\u00dfunternehmen","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Postgres Professional, der f\u00fchrende russische Anbieter von DBMS, gibt die Ver\u00f6ffentlichung von Minor-Updates f\u00fcr Postgres Pro Shardman Version 14.12.1 bekannt.<\/p>\n<p> <noindex><noindex><\/p>\n<p><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/products\/shardman\">Postgres Pro Shardman<\/a> \u2014 eine neue verteilte relationale DBMS f\u00fcr hochbelastete Systeme, geeignet f\u00fcr die gr\u00f6\u00dften Installationen von mehreren zehn bis mehreren hundert TB, wenn ein einzelner Server nicht ausreicht. Das DBMS erm\u00f6glicht es, Daten in Teile zu unterteilen und diese auf verschiedene Server \u2014 Shards \u2014 zu verteilen. Dabei bietet die L\u00f6sung eine integrierte Fehlertoleranz und garantiert die Einhaltung der ACID-Anforderungen: Atomarit\u00e4t, Konsistenz, Isolation und Dauerhaftigkeit.<\/p>\n<p><\/noindex><\/noindex> <\/p>\n<p>In der aktuellen Version wurden neue Funktionen hinzugef\u00fcgt, die Leistung verbessert und einige Fehler behoben. Zu den wichtigsten \u00c4nderungen z\u00e4hlen:<\/p>\n<p><strong>Kern und Erweiterungen<\/strong><\/p>\n<ul>\n<li>Ein neuer Parameter REMOTE f\u00fcr den EXPLAIN-Befehl wurde hinzugef\u00fcgt, der die Ausgabe von EXPLAIN f\u00fcr Abfragen erlaubt, die auf einem entfernten Server ausgef\u00fchrt werden. Standardm\u00e4\u00dfig aktiviert.<\/li>\n<li>Eine eigene Logik zur Kostenbewertung von Pl\u00e4nen wurde implementiert. Sie erm\u00f6glicht es dem Planner, h\u00e4ufiger gemeinsame Pl\u00e4ne auszuw\u00e4hlen, wenn \u00c4hnlichkeiten zwischen allgemeinen und spezialisierten Pl\u00e4nen bestehen.<\/li>\n<li>Unterst\u00fctzung f\u00fcr das Ausnehmen von Sektionen w\u00e4hrend der Ausf\u00fchrung wurde f\u00fcr Plan-Knoten hinzugef\u00fcgt, die Datenaggregation auf externen Servern durchf\u00fchren. Diese Optimierung ist in erster Linie erforderlich, um Sektionen in gemeinsamen Pl\u00e4nen zu eliminieren.<\/li>\n<li>Kumulative Metriken f\u00fcr das Volumen des Netzwerkverkehrs zwischen den Knoten des Shardman-Clusters wurden der Ansicht hinzugef\u00fcgt <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>Die Ansicht pg_stat_activity wurde aktualisiert, die nun den Status der verwaltenden Prozesse von Shardman anzeigt.<\/li>\n<\/ul>\n<p><strong>Verwaltungswerkzeuge<\/strong><\/p>\n<ul>\n<li>Die Schwachstellen CVE-2023-45288 und CVE-2023-44487 wurden behoben.<\/li>\n<li>Ein Fehler im Befehl <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-CLEANUP\">shardmanctl cleanup<\/a>, der dazu f\u00fchrte, dass Gruppen von Replikationen nicht gel\u00f6scht werden konnten, wurde behoben.<\/li>\n<li>Die Ausgabe des Befehls <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-FORALL\">shardmanctl forall<\/a> wurde bei leerem Ergebnis verbessert.<\/li>\n<li>Ein Absturz des Dienstprogramms <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmand.html\">shardmand<\/a>, der zuvor auftrat, wenn der Shardman-Cluster nicht vollst\u00e4ndig konfiguriert war, wurde behoben.<\/li>\n<\/ul>\n<p>Quelle: <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.1.1 - 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\/de\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"de_DE\" \/>\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\/de\/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: DBMS-Update f\u00fcr gro\u00dfe Unternehmen | ProHoster","description":"Postgres Professional, der f\u00fchrende russische Anbieter von DBMS, gibt die Ver\u00f6ffentlichung von Minor-Updates f\u00fcr Postgres Pro Shardman Version 14.12.1 bekannt.","canonical_url":"https:\/\/prohoster.info\/de\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"de_DE","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\/de\/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\/de\/wp-json\/wp\/v2\/posts\/116976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/comments?post=116976"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/116976\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media?parent=116976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/categories?post=116976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/tags?post=116976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}