{"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\/et\/blog\/novosti-interneta\/vyshel-postgres-pro-enterprise-dlya-1s-18-4-1-s-optimizacziyami-pod-tyazhyolye-nagruzki","title":{"rendered":"V\u00e4lja anti Postgres Pro Enterprise versioon 1C 18.4.1, optimeeritud rasketeks koormusteks","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

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

Postgres Professionali teatas v\u00e4ljaande kohta Postgres Pro Enterprise 1C 18.4.1 jaoks<\/a>. Uuendus on suunatud suurtele \u201e1C\u201d installatsioonidele, kus andmebaas kohtab regulaarselt keerulisi p\u00e4ringuid, palju \u00fchendusi, ajutisi tabeleid, aruanne ja regulaarseid operatsioonide. Ametlikes v\u00e4ljaande m\u00e4rkustes<\/a> on m\u00e4rgitud, et uus versioon p\u00f5hineb PostgreSQL 18.4-l ja Postgres Pro Enterprise 18.3.2-l.<\/p>\n

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

\u00dcks peamisi muudatusi on v\u00f5imalus kasutada ajutisi tabeleid, ajutisi j\u00e4rjestusi ja ajutisi esitlusi kuuma varukoopia serveris. Funktsioon aktiveeritakse parameetriga enable_standby_temp_tables<\/a> koos enable_temp_memory_catalog ja hot_standby. Praktikas t\u00e4hendab see, et keerulisi aruandeid ja ETL-protsesse saab viia \u00fcle standby-serverisse, koormamata p\u00f5hiv\u00f5lku.<\/p>\n

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

P\u00e4ringute plaanijale on lisatud mehhanism enable_join_predicate_pushdown<\/a>. See v\u00f5imaldab edastada \u00fchenduse tingimusi v\u00e4lisest p\u00e4ringust sisseehitatud alamp\u00e4ringutesse, et optimeerija saaks valida parema t\u00e4itmisplaani. Samuti on kiirendatud selektiivsuse hindamist suurte MCV nimekirjade jaoks ja parandatud t\u00f6\u00f6tamist piiratud valimitega l\u00e4bi planner_upper_limit_estimation; see peaks olema m\u00e4rgatav t\u00fc\u00fcpilistes '1C' stsenaariumides, sealhulgas perioodi sulgemisel ja aruannete koostamisel.<\/p>\n

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

Uuendatud on ka rikkevastaseid lahendusi. Sisseehitatud lahendus BiHA<\/a> on l\u00e4inud versioonile 1.8: mitmeastmeline geograafiline jaotamine ja katastroofi vastupidavus ei ole enam eksperimentaalsed, ning teenuse \u00fchendused s\u00f5lmedes on kaitstud SSL-sertifikaatidega. Proximas on ilmnenud kohanduv tasakaalustamine, mis arvestab CPU, m\u00e4lu ja kettasisendit\/v\u00e4ljundit, samuti toetust mitmele \u00fchenduse aadressile - IPv4, IPv6 ja Unix-soketid.<\/p>\n

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

V\u00e4ljalaskesse on lisatud uusi t\u00f6\u00f6riistu ja laiendusi. pgpro_iheap<\/a> lisab tabelip\u00f5hise juurdep\u00e4\u00e4sumeetodi iheap, mis on m\u00f5eldud j\u00e4rjestikulise skaneerimise kiirendamiseks, ja pgpro_temp_stats<\/a> kogub automaatselt ajutiste tabelite statistikat, et plaanija ei t\u00f6\u00f6taks pime. Administratsioonidele on lisatud utiliit pgpro_validate<\/a>, mis kontrollib failide, indeksite, tabelite, s\u00fcsteemikataloogide ja juurdep\u00e4\u00e4su\u00f5iguste terviklikkust Postgres Pro instantsis.<\/p>\n

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

Kuna Postgres Pro Enterprise 18.4.1 p\u00f5hineb PostgreSQL 18.4<\/a>, sisaldab see ka parandusi PostgreSQL-i allikast. Sama p\u00f5hiversiooni raames piisab, kui paigaldada uus v\u00e4ljaanne k\u00e4esolevasse kausta, kuid ABI muutumise korral soovitavad arendajad uuendada tooteid v\u00f5i uuesti kompileerida kolmanda osapoole laiendusi.<\/p>\n

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

Allikas: 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-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\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\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47V\u00e4lja on antud Postgres Pro Enterprise for 1C 18.4.1, mis on optimeeritud k\u00f5rgete koormuste jaoks | ProHoster","description":"Postgres Professional kuulutas v\u00e4lja Postgres Pro Enterprise for 1C 18.4.1. Uuendamine on suunatud suurematele 1C installatsioonidele, kus andmebaas puutub pidevalt kokku keeruliste p\u00e4ringute, arvukate \u00fchendustega, ajutiste tabelitega, aruannete ja regulaarsete toimingutega. Ametlikes v\u00e4ljaande m\u00e4rkustes \u00f6eldakse, et uus versioon p\u00f5hineb PostgreSQL 18.4-l ja Postgres Pro Enterprise 18.3.2-l. \u00dcks","canonical_url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/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":"et_EE","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:description":"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","og:url":"https:\/\/prohoster.info\/et\/blog\/novosti-interneta\/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":[],"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/182551","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=182551"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/182551\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=182551"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=182551"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=182551"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}