{"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\/es\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","title":{"rendered":"Postgres Pro Shardman: actualizaci\u00f3n de la base de datos para grandes empresas","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Postgres Professional, el principal desarrollador de bases de datos en Rusia, anuncia el lanzamiento de actualizaciones menores de Postgres Pro Shardman versi\u00f3n 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 una nueva base de datos relacional distribuida para sistemas de alta carga, adecuada para las instalaciones m\u00e1s grandes de decenas y cientos de TB, cuando un solo servidor no es suficiente. Esta base de datos permite dividir los datos en partes y distribuirlos en diferentes servidores \u2014 shards. Adem\u00e1s, la soluci\u00f3n proporciona resistencia incorporada y garantiza el cumplimiento de los requisitos ACID: atomicidad, consistencia, aislamiento y durabilidad.<\/p>\n<p><\/noindex><\/noindex> <\/p>\n<p>En esta nueva versi\u00f3n de Postgres Pro Shardman se han a\u00f1adido nuevas funciones, mejorado el rendimiento y corregido algunos errores. Entre los cambios clave se encuentran:<\/p>\n<p><strong>N\u00facleo y extensiones<\/strong><\/p>\n<ul>\n<li>Se ha agregado el par\u00e1metro REMOTE al comando EXPLAIN, que permite la salida de EXPLAIN para consultas ejecutadas en un servidor remoto. Est\u00e1 habilitado por defecto.<\/li>\n<li>Se ha implementado una l\u00f3gica de evaluaci\u00f3n de costos propia. Esto permite al planificador elegir con m\u00e1s frecuencia planes generales cuando hay similitudes entre los planes generales y especializados.<\/li>\n<li>Se ha a\u00f1adido soporte para la exclusi\u00f3n de secciones durante la ejecuci\u00f3n para nodos del plan que realizan agregaci\u00f3n de datos en servidores externos. Esta optimizaci\u00f3n es necesaria principalmente para eliminar secciones en planes generales.<\/li>\n<li>Se han a\u00f1adido m\u00e9tricas acumulativas sobre la cantidad de tr\u00e1fico de red entre nodos del cl\u00faster Shardman en la vista <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>Se ha actualizado la vista pg_stat_activity, que ahora muestra el estado de los procesos de servicio de Shardman.<\/li>\n<\/ul>\n<p><strong>Utilidades de gesti\u00f3n<\/strong><\/p>\n<ul>\n<li>Se han corregido las vulnerabilidades CVE-2023-45288 y CVE-2023-44487.<\/li>\n<li>Se ha solucionado un error en el comando <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-CLEANUP\">shardmanctl cleanup<\/a>, que imped\u00eda la eliminaci\u00f3n de grupos de replicaci\u00f3n.<\/li>\n<li>Se ha mejorado la salida del comando <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-FORALL\">shardmanctl forall<\/a> cuando el resultado est\u00e1 vac\u00edo.<\/li>\n<li>Se ha solucionado un fallo en la utilidad <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmand.html\">shardmand<\/a>, que anteriormente ocurr\u00eda si el cl\u00faster Shardman no estaba configurado completamente.<\/li>\n<\/ul>\n<p>Fuente: <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.2 - 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\/es\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"es_ES\" \/>\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\/es\/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: actualizaci\u00f3n de la base de datos para grandes empresas | ProHoster","description":"Postgres Professional, el principal desarrollador de bases de datos en Rusia, anuncia el lanzamiento de actualizaciones menores de Postgres Pro Shardman versi\u00f3n 14.12.1.","canonical_url":"https:\/\/prohoster.info\/es\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"es_ES","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\/es\/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\/es\/wp-json\/wp\/v2\/posts\/116976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/comments?post=116976"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/116976\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/media?parent=116976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/categories?post=116976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/tags?post=116976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}