{"id":182551,"date":"2026-07-08T22:53:49","date_gmt":"2026-07-08T20:53:50","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki"},"modified":"2026-07-08T22:53:49","modified_gmt":"2026-07-08T20:53:50","slug":"vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","status":"publish","type":"post","link":"https:\/\/prohoster.info\/es\/blog\/news\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","title":{"rendered":"Lanzamiento de Postgres Pro Enterprise para 1C 18.4.1 con optimizaciones para cargas pesadas","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

<\/i><\/a>
2 <\/p>\n

La empresa Postgres Professional ha anunciado el lanzamiento de Postgres Pro Enterprise para 1C 18.4.1<\/a>. La actualizaci\u00f3n est\u00e1 orientada a grandes instalaciones de \u00ab1C\u00bb, donde la base de datos recibe regularmente solicitudes complejas, m\u00faltiples conexiones, tablas temporales, informes y operaciones programadas. En las notas de lanzamiento oficiales<\/a> , se indica que la nueva versi\u00f3n est\u00e1 basada en PostgreSQL 18.4 y Postgres Pro Enterprise 18.3.2.<\/p>\n

<\/noindex> <\/p>\n

Uno de los principales cambios es la posibilidad de usar tablas temporales, secuencias temporales y vistas temporales en el servidor de reserva en caliente. Esta funci\u00f3n se activa con el par\u00e1metro enable_standby_temp_tables<\/a> junto con enable_temp_memory_catalog y hot_standby. El sentido pr\u00e1ctico es sencillo: se pueden trasladar informes pesados y procesos ETL al servidor en espera, sin sobrecargar el nodo principal.<\/p>\n

<\/noindex> <\/p>\n

Se ha a\u00f1adido al planificador de consultas el mecanismo enable_join_predicate_pushdown<\/a>. Permite empujar las condiciones de uni\u00f3n de la consulta externa a las subconsultas anidadas, para que el optimizador pueda elegir un plan de ejecuci\u00f3n m\u00e1s adecuado. Tambi\u00e9n se ha acelerado la estimaci\u00f3n de selectividad para listas grandes de MCV y se ha mejorado el trabajo con muestras limitadas a trav\u00e9s de planner_upper_limit_estimation; esto debe ser notable en escenarios t\u00edpicos de \u00ab1C\u00bb, incluyendo el cierre de per\u00edodos y la elaboraci\u00f3n de informes.<\/p>\n

<\/noindex> <\/p>\n

Se han actualizado tambi\u00e9n las herramientas de alta disponibilidad. La soluci\u00f3n incorporada BiHA<\/a> ha pasado a la versi\u00f3n 1.8: la geodistribuci\u00f3n multicapa y la resistencia a desastres ya no se consideran experimentales, y las conexiones de servicio entre nodos se pueden proteger con certificados SSL. En Proxima se ha implementado un balanceo de carga adaptativo que tiene en cuenta CPU, memoria y entrada\/salida de disco, as\u00ed como el soporte para m\u00faltiples direcciones de conexi\u00f3n: IPv4, IPv6 y sockets Unix.<\/p>\n

<\/noindex> <\/p>\n

El lanzamiento tambi\u00e9n incluye nuevas herramientas y extensiones. pgpro_iheap<\/a> a\u00f1ade un m\u00e9todo de acceso tabular iheap, dise\u00f1ado para acelerar el escaneo secuencial, y pgpro_temp_stats<\/a> recoge autom\u00e1ticamente estad\u00edsticas sobre tablas temporales, para que el planificador no trabaje a ciegas. Para los administradores se ha a\u00f1adido la utilidad pgpro_validate<\/a>, que comprueba la integridad de los archivos, \u00edndices, tablas, cat\u00e1logos del sistema y permisos en la instancia de Postgres Pro.<\/p>\n

<\/noindex> <\/p>\n

Dado que Postgres Pro Enterprise 18.4.1 est\u00e1 basado en PostgreSQL 18.4<\/a>, tambi\u00e9n se incluyeron correcciones del upstream de PostgreSQL. Para actualizar dentro de la misma versi\u00f3n principal, basta con instalar el nuevo lanzamiento en el directorio actual, pero al cambiar el ABI, los desarrolladores recomiendan actualizar las extensiones suministradas o recompilar las de terceros.<\/p>\n

<\/noindex><\/p>\n

Fuente: linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

2 \u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Postgres Professional \u043e\u0431\u044a\u044f\u0432\u0438\u043b\u0430 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 Postgres Pro Enterprise \u0434\u043b\u044f 1\u0421 18.4.1. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u043e\u0440\u0438\u0435\u043d\u0442\u0438\u0440\u043e\u0432\u0430\u043d\u043e \u043d\u0430 \u043a\u0440\u0443\u043f\u043d\u044b\u0435 \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u044f\u0446\u0438\u0438 \u00ab1\u0421\u00bb, \u0433\u0434\u0435 \u0431\u0430\u0437\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u0440\u0435\u0433\u0443\u043b\u044f\u0440\u043d\u043e \u0441\u0442\u0430\u043b\u043a\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u0441\u043e \u0441\u043b\u043e\u0436\u043d\u044b\u043c\u0438 \u0437\u0430\u043f\u0440\u043e\u0441\u0430\u043c\u0438, \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e\u043c \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0439, \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u043c\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438, \u043e\u0442\u0447\u0451\u0442\u0430\u043c\u0438 \u0438 \u0440\u0435\u0433\u043b\u0430\u043c\u0435\u043d\u0442\u043d\u044b\u043c\u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u044f\u043c\u0438. \u0412 \u043e\u0444\u0438\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0445 \u0437\u0430\u043c\u0435\u0447\u0430\u043d\u0438\u044f\u0445 \u043a \u0432\u044b\u043f\u0443\u0441\u043a\u0443 \u0443\u043a\u0430\u0437\u0430\u043d\u043e, \u0447\u0442\u043e \u043d\u043e\u0432\u0430\u044f \u0432\u0435\u0440\u0441\u0438\u044f \u043e\u0441\u043d\u043e\u0432\u0430\u043d\u0430 \u043d\u0430 PostgreSQL 18.4 \u0438 Postgres Pro Enterprise 18.3.2. \u041e\u0434\u043d\u043e \u0438\u0437 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-182551","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Ha salido Postgres Pro Enterprise para 1C 18.4.1 con optimizaciones para cargas pesadas | ProHoster","description":"","canonical_url":"https:\/\/prohoster.info\/es\/blog\/news\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","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\udd47\u0412\u044b\u0448\u0435\u043b Postgres Pro Enterprise \u0434\u043b\u044f 1\u0421 18.4.1 \u0441 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u044f\u043c\u0438 \u043f\u043e\u0434 \u0442\u044f\u0436\u0451\u043b\u044b\u0435 \u043d\u0430\u0433\u0440\u0443\u0437\u043a\u0438 | ProHoster","og:url":"https:\/\/prohoster.info\/es\/blog\/news\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","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":"2026-07-08T20:53:50+00:00","article:modified_time":"2026-07-08T20:53:50+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"182551","title":null,"description":null,"keywords":null,"keyphrases":{"focus":[],"additional":[]},"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-08-05 12:22:06","updated":"2026-08-05 12:22:06","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\/182551","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\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/comments?post=182551"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/posts\/182551\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/media?parent=182551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/categories?post=182551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/es\/wp-json\/wp\/v2\/tags?post=182551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}