{"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\/fr\/blog\/news\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","title":{"rendered":"Sortie de Postgres Pro Enterprise pour 1C 18.4.1 avec des optimisations pour les charges lourdes","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

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

La soci\u00e9t\u00e9 Postgres Professional a annonc\u00e9 la sortie de Postgres Pro Enterprise pour 1C 18.4.1<\/a>. La mise \u00e0 jour est destin\u00e9e aux grandes installations de \u00ab 1C \u00bb, o\u00f9 la base de donn\u00e9es est r\u00e9guli\u00e8rement confront\u00e9e \u00e0 des requ\u00eates complexes, \u00e0 de nombreuses connexions, \u00e0 des tables temporaires, \u00e0 des rapports et \u00e0 des op\u00e9rations programm\u00e9es. Dans les notes de publication officielles<\/a> , il est indiqu\u00e9 que la nouvelle version est bas\u00e9e sur PostgreSQL 18.4 et Postgres Pro Enterprise 18.3.2.<\/p>\n

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

Un des principaux changements est la possibilit\u00e9 d'utiliser des tables temporaires, des s\u00e9quences temporaires et des vues temporaires sur le serveur de secours. Cette fonction est activ\u00e9e par le param\u00e8tre enable_standby_temp_tables<\/a> avec enable_temp_memory_catalog et hot_standby. Le principe pratique est simple : les rapports lourds et les processus ETL peuvent \u00eatre transf\u00e9r\u00e9s vers le serveur de secours sans surcharger le n\u0153ud principal.<\/p>\n

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

Pour le planificateur de requ\u00eates, un m\u00e9canisme enable_join_predicate_pushdown<\/a>a \u00e9t\u00e9 ajout\u00e9. Cela permet de pousser les conditions de jointure des requ\u00eates externes vers les sous-requ\u00eates imbriqu\u00e9es, afin que l'optimiseur puisse choisir un plan d'ex\u00e9cution plus optimal. L'\u00e9valuation de la s\u00e9lectivit\u00e9 pour de grandes listes MCV a \u00e9galement \u00e9t\u00e9 acc\u00e9l\u00e9r\u00e9e et le travail avec des \u00e9chantillons limit\u00e9s a \u00e9t\u00e9 am\u00e9lior\u00e9 gr\u00e2ce \u00e0 planner_upper_limit_estimation ; cela devrait \u00eatre perceptible dans des sc\u00e9narios typiques de \u00ab 1C \u00bb, y compris la cl\u00f4ture de p\u00e9riode et la g\u00e9n\u00e9ration de rapports.<\/p>\n

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

Les outils de tol\u00e9rance aux pannes ont \u00e9galement \u00e9t\u00e9 mis \u00e0 jour. La solution int\u00e9gr\u00e9e BiHA<\/a> est pass\u00e9e \u00e0 la version 1.8 : la g\u00e9o-distribution multi-niveaux et la r\u00e9sistance aux catastrophes ne sont plus consid\u00e9r\u00e9es comme exp\u00e9rimentales, et les connexions de service entre les n\u0153uds peuvent \u00eatre prot\u00e9g\u00e9es par des certificats SSL. Proxima a introduit un \u00e9quilibrage de charge adaptatif qui prend en compte le CPU, la m\u00e9moire et les entr\u00e9es-sorties de disque, ainsi que le support de plusieurs adresses de connexion \u2014 IPv4, IPv6 et Unix-sockets.<\/p>\n

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

La version comprend \u00e9galement de nouveaux outils et extensions. pgpro_iheap<\/a> ajoute une m\u00e9thode d'acc\u00e8s tabulaire iheap, con\u00e7ue pour acc\u00e9l\u00e9rer les scans s\u00e9quentiels, tandis que pgpro_temp_stats<\/a> collecte automatiquement des statistiques sur les tables temporaires, afin que le planificateur ne fonctionne pas dans le brouillard. Pour les administrateurs, un utilitaire a \u00e9t\u00e9 ajout\u00e9, pgpro_validate<\/a>, qui v\u00e9rifie l'int\u00e9grit\u00e9 des fichiers, des index, des tables, des catalogues syst\u00e8me et des droits d'acc\u00e8s dans l'instance Postgres Pro.<\/p>\n

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

Comme Postgres Pro Enterprise 18.4.1 est bas\u00e9 sur PostgreSQL 18.4<\/a>, il comprend \u00e9galement des corrections de l'upstream PostgreSQL. Pour une mise \u00e0 jour au sein de la m\u00eame version majeure, il suffit d'installer le nouveau correctif dans le r\u00e9pertoire courant, mais lors d'un changement d'ABI, les d\u00e9veloppeurs recommandent de mettre \u00e0 jour les extensions fournies ou de recompiler celles tierces.<\/p>\n

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

Source : 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\udd47Postgres Pro Enterprise pour 1C 18.4.1 est sorti avec des optimisations pour les charges lourdes | ProHoster","description":"","canonical_url":"https:\/\/prohoster.info\/fr\/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":"fr_FR","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\/fr\/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\/fr\/wp-json\/wp\/v2\/posts\/182551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=182551"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/182551\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=182551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=182551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=182551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}