{"id":116976,"date":"2024-07-06T09:34:41","date_gmt":"2024-07-06T07:34:41","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij"},"modified":"2024-07-06T09:34:41","modified_gmt":"2024-07-06T07:34:41","slug":"postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","status":"publish","type":"post","link":"https:\/\/prohoster.info\/az\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","title":{"rendered":"Postgres Pro Shardman: m\u00fc\u0259ssis\u0259l\u0259r \u00fc\u00e7\u00fcn DBMS yenil\u0259m\u0259si","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Postgres Professional, apar\u0131c\u0131 Rusiya DBMS inki\u015faf etdiricisi, Postgres Pro Shardman versiyas\u0131 14.12.1-in ki\u00e7ik yenil\u0259m\u0259l\u0259rinin burax\u0131ld\u0131\u011f\u0131n\u0131 elan edir.<\/p>\n<p> <noindex><noindex><\/p>\n<p><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/products\/shardman\">Postgres Pro Shardman<\/a> \u2014 y\u00fcks\u0259k y\u00fckl\u00fc sisteml\u0259r \u00fc\u00e7\u00fcn yeni paylanm\u0131\u015f \u0259laq\u0259li DBMS, \u0259n b\u00f6y\u00fck TB-l\u0131k qura\u015fd\u0131rmalar \u00fc\u00e7\u00fcn uygundur, t\u0259k bir serverin kifay\u0259t etm\u0259diyi hallarda. DBMS m\u0259lumatlar\u0131 hiss\u0259l\u0259r\u0259 b\u00f6lm\u0259y\u0259 v\u0259 onlar\u0131 m\u00fcxt\u0259lif serverl\u0259r\u0259 \u2014 \u015fardlara \u2014 paylama\u011fa imkan tan\u0131y\u0131r. Bu yana\u015fma eyni zamanda daxili dayan\u0131ql\u0131\u011f\u0131 t\u0259min edir v\u0259 ACID t\u0259l\u0259bl\u0259rin\u0259 (atomiklik, uy\u011funluq, ayr\u0131l\u0131q v\u0259 davaml\u0131l\u0131q) tam riay\u0259t edir.<\/p>\n<p><\/noindex><\/noindex> <\/p>\n<p>Postgres Pro Shardman-in n\u00f6vb\u0259ti burax\u0131l\u0131\u015f\u0131nda yeni imkanlar \u0259lav\u0259 edilib, performans art\u0131r\u0131l\u0131b v\u0259 b\u0259zi s\u0259hvl\u0259r d\u00fcz\u0259ldilib. \u018fsas d\u0259yi\u015fiklikl\u0259r aras\u0131nda:<\/p>\n<p><strong>N\u00fcv\u0259 v\u0259 geni\u015fl\u0259ndirm\u0259l\u0259r<\/strong><\/p>\n<ul>\n<li>Uzaq serverd\u0259 icra olunan sor\u011fular \u00fc\u00e7\u00fcn EXPLAIN komandas\u0131 vasit\u0259sil\u0259 EXPLAIN \u00e7\u0131x\u0131\u015f\u0131n\u0131 t\u0259min ed\u0259n REMOTE parametr \u0259lav\u0259 edilib. Bu parametr varsay\u0131lan olaraq aktivdir.<\/li>\n<li>Planlar\u0131n qiym\u0259tini d\u0259y\u0259rl\u0259ndirm\u0259k \u00fc\u00e7\u00fcn \u00f6z loqika h\u0259yata ke\u00e7irilib. Bu, planla\u015fd\u0131r\u0131c\u0131ya ox\u015far \u00fcmumi v\u0259 spesifikl\u0259r aras\u0131nda daha \u00e7ox \u00fcmumi planlar\u0131 se\u00e7m\u0259y\u0259 imkan tan\u0131y\u0131r.<\/li>\n<li>Xarici serverl\u0259rd\u0259 m\u0259lumatlar\u0131 toplamaqla m\u0259\u015f\u011ful olan plan d\u00fcy\u00fcnl\u0259ri \u00fc\u00e7\u00fcn icra prosesi zaman\u0131 hiss\u0259l\u0259rin istisnas\u0131n\u0131 d\u0259st\u0259kl\u0259y\u0259n funksiya \u0259lav\u0259 edilib. Bu optimizasiya, \u00fcmumi planlarda hiss\u0259l\u0259rin aradan qald\u0131r\u0131lmas\u0131 \u00fc\u00e7\u00fcn x\u00fcsusil\u0259 vacibdir.<\/li>\n<li>Shardman klaster d\u00fcy\u00fcnl\u0259ri aras\u0131nda \u015f\u0259b\u0259k\u0259 trafikinin \u00f6l\u00e7\u00fcs\u00fc \u00fczr\u0259 y\u0131\u011f\u0131lm\u0131\u015f metrikalar t\u0259qdimata \u0259lav\u0259 edilib <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/shardman-views.html#SHARDMAN-PG-STAT-NETUSAGE\">shardman.pg_stat_netusage<\/a>.<\/li>\n<li>Shardman xidm\u0259t prosesl\u0259rinin v\u0259ziyy\u0259tini g\u00f6st\u0259r\u0259n pg_stat_activity t\u0259qdimat\u0131 yenil\u0259ndi.<\/li>\n<\/ul>\n<p><strong>\u0130dar\u0259etm\u0259 utilitl\u0259ri<\/strong><\/p>\n<ul>\n<li>CVE-2023-45288 v\u0259 CVE-2023-44487 z\u0259iflikl\u0259ri aradan qald\u0131r\u0131l\u0131b.<\/li>\n<li>A\u015fa\u011f\u0131dak\u0131 komanda daxilind\u0259 bir s\u0259hv d\u00fcz\u0259ldilib <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-CLEANUP\">shardmanctl cleanup<\/a>, replikasiya qruplar\u0131n\u0131n silinm\u0259sinin m\u00fcmk\u00fcn olmamas\u0131na s\u0259b\u0259b olan.<\/li>\n<li>Komandan\u0131n \u00e7\u0131x\u0131\u015f\u0131 yax\u015f\u0131la\u015fd\u0131r\u0131l\u0131b <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmanctl.html#APP-SHARDMANCTL-FORALL\">shardmanctl forall<\/a> bo\u015f n\u0259tic\u0259 zaman\u0131.<\/li>\n<li>Shardman konfiqurasiya edilm\u0259dikd\u0259 meydana g\u0259l\u0259n s\u0259hv aradan qald\u0131r\u0131l\u0131b. <a rel=\"nofollow\" href=\"https:\/\/repo.postgrespro.ru\/doc\/sdm\/14.12.1\/ru\/html\/app-shardmand.html\">shardmand<\/a>, daha \u0259vv\u0259l ba\u015f ver\u0259n.<\/li>\n<\/ul>\n<p>M\u0259nb\u0259: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.linux.org.ru\/news\/proprietary\/17653564\">linux.org.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1. Postgres Pro Shardman \u2014 \u043d\u043e\u0432\u0430\u044f \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0430\u044f \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u0430\u044f \u0421\u0423\u0411\u0414 \u0434\u043b\u044f \u0432\u044b\u0441\u043e\u043a\u043e\u043d\u0430\u0433\u0440\u0443\u0436\u0435\u043d\u043d\u044b\u0445 \u0441\u0438\u0441\u0442\u0435\u043c, \u043f\u043e\u0434\u0445\u043e\u0434\u0438\u0442 \u0434\u043b\u044f \u043a\u0440\u0443\u043f\u043d\u0435\u0439\u0448\u0438\u0445 \u0438\u043d\u0441\u0442\u0430\u043b\u043b\u044f\u0446\u0438\u0439 \u0432 \u0434\u0435\u0441\u044f\u0442\u043a\u0438 \u0438 \u0441\u043e\u0442\u043d\u0438 \u0422\u0411, \u043a\u043e\u0433\u0434\u0430 \u043e\u0434\u0438\u043d\u043e\u0447\u043d\u043e\u0433\u043e \u0441\u0435\u0440\u0432\u0435\u0440\u0430 \u043d\u0435\u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e. \u0421\u0423\u0411\u0414 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u0434\u0435\u043b\u0438\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043d\u0430 \u0447\u0430\u0441\u0442\u0438 \u0438 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u044c \u0438\u0445 \u043f\u043e \u0440\u0430\u0437\u043d\u044b\u043c \u0441\u0435\u0440\u0432\u0435\u0440\u0430\u043c \u2014 \u0448\u0430\u0440\u0434\u0430\u043c. \u041f\u0440\u0438 \u044d\u0442\u043e\u043c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-116976","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/az\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"az_AZ\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47Postgres Pro Shardman: \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0421\u0423\u0411\u0414 \u0434\u043b\u044f \u043a\u0440\u0443\u043f\u043d\u044b\u0445 \u043f\u0440\u0435\u0434\u043f\u0440\u0438\u044f\u0442\u0438\u0439 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/az\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2024-07-06T07:34:41+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2024-07-06T07:34:41+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Postgres Pro Shardman: m\u00fc\u0259ssis\u0259l\u0259r \u00fc\u00e7\u00fcn DBMS yenil\u0259m\u0259si | ProHoster","description":"Postgres Professional, apar\u0131c\u0131 Rusiya DBMS inki\u015faf etdiricisi, Postgres Pro Shardman versiyas\u0131 14.12.1-in ki\u00e7ik yenil\u0259m\u0259l\u0259rinin burax\u0131ld\u0131\u011f\u0131n\u0131 elan edir.","canonical_url":"https:\/\/prohoster.info\/az\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"az_AZ","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\udd47Postgres Pro Shardman: \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 \u0421\u0423\u0411\u0414 \u0434\u043b\u044f \u043a\u0440\u0443\u043f\u043d\u044b\u0445 \u043f\u0440\u0435\u0434\u043f\u0440\u0438\u044f\u0442\u0438\u0439 | ProHoster","og:description":"Postgres Professional, \u0432\u0435\u0434\u0443\u0449\u0438\u0439 \u0440\u043e\u0441\u0441\u0438\u0439\u0441\u043a\u0438\u0439 \u0421\u0423\u0411\u0414-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a, \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0435\u0442 \u043e \u0432\u044b\u043f\u0443\u0441\u043a\u0435 \u043c\u0438\u043d\u043e\u0440\u043d\u044b\u0445 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 Postgres Pro Shardman \u0432\u0435\u0440\u0441\u0438\u0438 14.12.1.","og:url":"https:\/\/prohoster.info\/az\/blog\/news\/postgres-pro-shardman-obnovlenie-subd-dlya-krupnyh-predpriyatij","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":"2024-07-06T07:34:41+00:00","article:modified_time":"2024-07-06T07:34:41+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"116976","title":null,"description":null,"keywords":null,"keyphrases":null,"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":"2026-01-23 03:36:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 03:36:19","updated":"2026-01-23 03:36:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/posts\/116976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/comments?post=116976"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/posts\/116976\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/media?parent=116976"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/categories?post=116976"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/az\/wp-json\/wp\/v2\/tags?post=116976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}