{"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\/ro\/blog\/news\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","title":{"rendered":"A fost lansat Postgres Pro Enterprise pentru 1C 18.4.1 cu optimiz\u0103ri pentru sarcini grele","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

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

Compania Postgres Professional a anun\u021bat lansarea Postgres Pro Enterprise pentru 1C 18.4.1<\/a>. Actualizarea este orientat\u0103 spre instala\u021bii mari de \u201e1C\u201d, unde baza de date se confrunt\u0103 regulat cu interog\u0103ri complexe, numeroase conexiuni, tabele temporare, rapoarte \u0219i opera\u021biuni reglementate. \u00cen notele oficiale de lansare<\/a> se men\u021bioneaz\u0103 c\u0103 noua versiune se bazeaz\u0103 pe PostgreSQL 18.4 \u0219i Postgres Pro Enterprise 18.3.2.<\/p>\n

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

Una dintre principalele modific\u0103ri este posibilitatea de a utiliza tabele temporare, secven\u021be temporare \u0219i vederi temporare pe serverul de rezerv\u0103. Func\u021bia este activat\u0103 prin parametru enable_standby_temp_tables<\/a> \u00eempreun\u0103 cu enable_temp_memory_catalog \u0219i hot_standby. Sensul practic este simplu: rapoartele grele \u0219i procesele ETL pot fi mutate pe serverul de rezerv\u0103, f\u0103r\u0103 a \u00eenc\u0103rca nodul principal.<\/p>\n

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

Pentru planificatorul de interog\u0103ri, a fost ad\u0103ugat mecanismul enable_join_predicate_pushdown<\/a>. Acesta permite propagarea condi\u021biilor de conectare dintr-o interogare extern\u0103 c\u0103tre subinterog\u0103rile \u00eencorporate, astfel \u00eenc\u00e2t optimizerul s\u0103 poat\u0103 alege un plan de execu\u021bie mai eficient. De asemenea, a fost \u00eembun\u0103t\u0103\u021bit\u0103 evaluarea selectivit\u0103\u021bii pentru liste mari MCV \u0219i a fost \u00eembun\u0103t\u0103\u021bit\u0103 func\u021bionarea cu e\u0219antioane restr\u00e2nse prin planner_upper_limit_estimation; aceasta ar trebui s\u0103 fie vizibil\u0103 \u00een scenariile tipice \u201e1C\u201d, inclusiv \u00eenchiderea perioadelor \u0219i generarea rapoartelor.<\/p>\n

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

Au fost actualizate instrumentele de redundan\u021b\u0103. Solu\u021bia \u00eencorporat\u0103 BiHA<\/a> a trecut la versiunea 1.8: georeparti\u021bia multidimensional\u0103 \u0219i rezisten\u021ba la catastrofe nu mai sunt considerate experimentale, iar conexiunile de serviciu \u00eentre noduri pot fi securizate cu certificate SSL. \u00cen Proxima a ap\u0103rut echilibrul adaptiv, care ia \u00een considerare CPU, memorie \u0219i I\/O pe disc, precum \u0219i suportul pentru mai multe adrese de conectare \u2014 IPv4, IPv6 \u0219i Unix-sockets.<\/p>\n

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

Lansarea include, de asemenea, noi instrumente \u0219i extinderi. pgpro_iheap<\/a> adaug\u0103 metoda de acces tabelar iheap, destinat\u0103 acceler\u0103rii scan\u0103rilor secven\u021biale, iar pgpro_temp_stats<\/a> colecteaz\u0103 automat statistici pentru tabelele temporare, astfel \u00eenc\u00e2t planificatorul s\u0103 nu func\u021bioneze \u00een orb. Pentru administratori a fost ad\u0103ugat\u0103 utilitarul pgpro_validate<\/a>, care verific\u0103 integritatea fi\u0219ierelor, indec\u0219ilor, tabelelor, catalogilor de sistem \u0219i drepturilor de acces \u00een instan\u021ba Postgres Pro.<\/p>\n

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

Dat fiind c\u0103 Postgres Pro Enterprise 18.4.1 se bazeaz\u0103 pe PostgreSQL 18.4<\/a>, acesta include de asemenea corec\u021bii din upstream-ul PostgreSQL. Pentru actualizarea \u00een cadrul acelea\u0219i versiuni majore, este suficient s\u0103 instala\u021bi noul release \u00een acelasi catalog, dar \u00een cazul schimb\u0103rii ABI, dezvoltatorii recomand\u0103 actualizarea extensiilor furnizate sau recompilarea celor externe.<\/p>\n

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

Sursa: 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\udd47A fost lansat Postgres Pro Enterprise pentru 1C 18.4.1 cu optimiz\u0103ri pentru sarcini grele | ProHoster","description":"","canonical_url":"https:\/\/prohoster.info\/ro\/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":"ro_RO","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\/ro\/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\/ro\/wp-json\/wp\/v2\/posts\/182551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=182551"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/182551\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=182551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=182551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=182551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}