{"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\/sv\/blog\/news\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","title":{"rendered":"Postgres Pro Enterprise f\u00f6r 1C 18.4.1 har sl\u00e4ppts med optimeringar f\u00f6r tung belastning","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

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

Postgres Professional har meddelat om lanseringen av Postgres Pro Enterprise f\u00f6r 1C 18.4.1<\/a>. Uppdateringen \u00e4r riktad mot stora installationer av \"1C\", d\u00e4r databasen regelbundet st\u00e4lls inf\u00f6r komplexa fr\u00e5gor, m\u00e5nga anslutningar, tempor\u00e4ra tabeller, rapporter och schemalagda operationer. I de officiella utg\u00e5veanm\u00e4rkningarna<\/a> anges det att den nya versionen \u00e4r baserad p\u00e5 PostgreSQL 18.4 och Postgres Pro Enterprise 18.3.2.<\/p>\n

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

En av de st\u00f6rsta f\u00f6r\u00e4ndringarna \u00e4r m\u00f6jligheten att anv\u00e4nda tempor\u00e4ra tabeller, tempor\u00e4ra sekvenser och tempor\u00e4ra vyer p\u00e5 en standby-server. Funktionen aktiveras med parametern enable_standby_temp_tables<\/a> tillsammans med enable_temp_memory_catalog och hot_standby. Den praktiska inneb\u00f6rden \u00e4r enkel: tunga rapporter och ETL-processer kan flyttas till standby-servern utan att belasta huvudenheten.<\/p>\n

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

F\u00f6r fr\u00e5geplaneraren har mekanismen enable_join_predicate_pushdown<\/a>lagts till. Denna mekanism g\u00f6r det m\u00f6jligt att driva kriterier f\u00f6r anslutning fr\u00e5n en yttre fr\u00e5ga till inre delfr\u00e5gor, s\u00e5 att optimizern kan v\u00e4lja en mer f\u00f6rdelaktig utf\u00f6randeplan. Dessutom har bed\u00f6mningen av selektivitet f\u00f6r stora MCV-listor f\u00f6rb\u00e4ttrats och arbetet med begr\u00e4nsade urval via planner_upper_limit_estimation har f\u00f6rb\u00e4ttrats; detta borde vara m\u00e4rkbart i typiska \"1C\"-scenarier, inklusive st\u00e4ngning av perioder och rapportgenerering.<\/p>\n

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

Verktygen f\u00f6r h\u00f6g tillg\u00e4nglighet har ocks\u00e5 uppdaterats. Den inbyggda l\u00f6sningen BiHA<\/a> har \u00f6verg\u00e5tt till version 1.8: flerlagig geo-redundans och katastrofskydd betraktas inte l\u00e4ngre som experimentellt, och tj\u00e4nsteanslutningar mellan noder kan skyddas med SSL-certifikat. Proxima har inf\u00f6rlivat adaptiv belastningsbalansering som tar h\u00e4nsyn till CPU, minne och disk-I\/O, liksom st\u00f6d f\u00f6r flera anslutningsadresser \u2013 IPv4, IPv6 och Unix-socketar.<\/p>\n

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

Denna version inneh\u00e5ller ocks\u00e5 nya verktyg och till\u00e4gg. pgpro_iheap<\/a> introducerar en tabell\u00e5tkomstmetod som kallas iheap, avsedd f\u00f6r att p\u00e5skynda sekventiell skanning, medan pgpro_temp_stats<\/a> automatiskt samlar statistik f\u00f6r tempor\u00e4ra tabeller s\u00e5 att planl\u00e4ggaren inte arbetar i blindo. F\u00f6r administrat\u00f6rer har ett verktyg lagts till: pgpro_validate<\/a>, som kontrollerar integriteten hos filer, index, tabeller, systemkataloger och beh\u00f6righeter i en Postgres Pro-instans.<\/p>\n

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

Eftersom Postgres Pro Enterprise 18.4.1 \u00e4r baserat p\u00e5 PostgreSQL 18.4<\/a>, det inkluderade ocks\u00e5 fixar fr\u00e5n upstream PostgreSQL. F\u00f6r att uppdatera inom samma huvudversion r\u00e4cker det med att installera den nya utg\u00e5van i den nuvarande katalogen, men vid \u00e4ndring av ABI rekommenderar utvecklarna att uppdatera de levererade till\u00e4gg eller \u00e5terkompilera tredjeparts.<\/p>\n

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

K\u00e4lla: 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\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 f\u00f6r 1C 18.4.1 har sl\u00e4ppts med optimeringar f\u00f6r tunga laster | ProHoster","description":"","canonical_url":"https:\/\/prohoster.info\/sv\/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":"sv_SE","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\/sv\/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\/sv\/wp-json\/wp\/v2\/posts\/182551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/comments?post=182551"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/posts\/182551\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/media?parent=182551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/categories?post=182551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sv\/wp-json\/wp\/v2\/tags?post=182551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}