{"id":121799,"date":"2025-02-10T15:46:10","date_gmt":"2025-02-10T13:46:10","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/opublikovana-raspredelyonnaya-subd-citus-13-0"},"modified":"2025-02-10T15:46:10","modified_gmt":"2025-02-10T13:46:10","slug":"opublikovana-raspredelyonnaya-subd-citus-13-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/ro\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","title":{"rendered":"A fost publicat\u0103 baza de date distribuit\u0103 Citus 13.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Compania Citus Data, de\u021binut\u0103 de Microsoft, a publicat sistemul de gestionare a bazelor de date distribuite Citus 13.0, realizat sub forma unei extensii pentru PostgreSQL 17. Citus asigur\u0103 scalabilitate orizontal\u0103 pentru PostgreSQL \u00eentr-un cluster bazat pe echipamente standard \u0219i permite distribuirea datelor pe noduri prin utilizarea sharding-ului, configur\u00e2nd \u00eemp\u0103r\u021birea la nivel de coloane \u0219i schema de stocare. Pentru aplica\u021bii, clusterul Citus arat\u0103 ca un singur server PostgreSQL mare, care unific\u0103 resursele nodurilor care \u00eel compun. Codul este scris \u00een limbajul C \u0219i este distribuit sub licen\u021ba AGPLv3.      <\/p>\n<p>Sharding-ul permite organizarea stoc\u0103rii unor cantit\u0103\u021bi foarte mari de date, a c\u0103ror dimensiune total\u0103 dep\u0103\u0219e\u0219te semnificativ unit\u0103\u021bile locale de stocare ale fiec\u0103rui nod din cluster. Tabelele individuale pot fi replicate for\u021bat pe toate nodurile pentru a accelera executarea opera\u021biunilor de fuziune \u0219i a lucrului cu cheile externe. Pentru economisirea spa\u021biului pe disk, datele distribuite pe diferite noduri pot fi stocate \u00een format comprimat.       <\/p>\n<p>Interog\u0103rile distribuite pot fi trimise c\u0103tre oricare dintre nodurile din cluster, dar gestionarea \u0219i modificarea schemei de date trebuie efectuate doar prin nodul care coordoneaz\u0103 func\u021bionarea clusterului. Cererile primite de la clien\u021bi sunt distribuite pe nodurile necesare \u0219i, dac\u0103 acestea acoper\u0103 mai multe noduri, procesarea lor este paralelizat\u0103. Clusterul poate fi extins pe m\u0103sur\u0103 ce dimensiunea datelor stocate cre\u0219te, ad\u0103ug\u00e2nd noduri suplimentare \u0219i ini\u021biind reechilibrarea.     <\/p>\n<p>Printre exemplele tipice de utilizare a Citus se num\u0103r\u0103 executarea interog\u0103rilor analitice \u0219i procesarea unor volume mari de date sub form\u0103 de serii temporale (de exemplu, jurnalele sau starea senzorilor). Citus este, de asemenea, potrivit pentru modernizarea infrastructurii existente bazate pe un singur PostgreSQL, ale c\u0103rei performan\u021be \u0219i unit\u0103\u021bi de stocare nu mai sunt suficiente din cauza cre\u0219terii sarcinii sau a volumului de date primite. <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/ro\/server\/dts-los-angeles\/\"   title=\"server\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3899\">server<\/a> Cu ajutorul instrumentului Patroni, pot fi create configura\u021bii rezistente la defec\u021biuni, cu noduri de rezerv\u0103 replicate, capabile s\u0103 preia locul nodurilor principale \u00een caz de e\u0219ec.      <\/p>\n<p>Modific\u0103rile din versiunea Citus 13.0:  <\/p>\n<ul>\n<li class=\"l\"> Trecerea la utilizarea ramurii PostgreSQL 17.\n<li class=\"l\"> Posibilitatea de a utiliza \u00een interog\u0103ri distribuite func\u021bia JSON_TABLE() pentru a transforma datele din format JSON \u00een reprezent\u0103ri rela\u021bionale cu care se poate lucra ca cu tabele PostgreSQL obi\u0219nuite.\n<li class=\"l\"> Suport pentru sintaxa &laquo;MERGE &hellip; WHEN NOT MATCHED BY SOURCE&raquo;.\n<li class=\"l\">  Posibilitatea de a defini metoda de acces pentru tabelele distribuite prin expresia &laquo;CREATE TABLE &hellip; USING&raquo;, precum \u0219i modificarea metodei de acces prin &laquo;ALTER TABLE &hellip; SET ACCESS METHOD&raquo;.\n<li class=\"l\"> S-a ad\u0103ugat suport pentru specificarea coloanelor de identificare generate automat \u00een tabelele distribuite partitionate.\n<li class=\"l\"> A fost permis\u0103 aplicarea constr\u00e2ngerilor de excludere \u00een tabelele distribuite partitionate.\n<li class=\"l\"> S-au rezolvat problemele de sincronizare a rolurilor \u00eentre noduri.\n<li class=\"l\"> A fost \u00eembun\u0103t\u0103\u021bit\u0103 distribu\u021bia datelor pentru sharding la ad\u0103ugarea de noduri noi \u00een cluster.\n<li class=\"l\"> Comanda &laquo;EXPLAIN&raquo; a fost extins\u0103 cu op\u021biunile &laquo;MEMORY&raquo; \u0219i &laquo;SERIALIZE&raquo;, cu ajutorul c\u0103rora se poate determina dimensiunea memoriei utilizate \u0219i timpul necesar pentru transformarea datelor pentru transmisia \u00een re\u021bea.       <\/ul>\n<p>Sursa: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62701\">opennet.ro<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Citus Data, \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0430\u0449\u0430\u044f Microsoft, \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0443\u044e \u0421\u0423\u0411\u0414 Citus 13.0, \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u0443\u044e \u0432 \u0444\u043e\u0440\u043c\u0435 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f \u043a PostgreSQL 17. Citus \u043e\u0431\u0435\u0441\u043f\u0435\u0447\u0438\u0432\u0430\u0435\u0442 \u0433\u043e\u0440\u0438\u0437\u043e\u043d\u0442\u0430\u043b\u044c\u043d\u043e\u0435 \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 PostgreSQL \u0432 \u043a\u043b\u0430\u0441\u0442\u0435\u0440\u0435 \u043d\u0430 \u0431\u0430\u0437\u0435 \u0442\u0438\u043f\u043e\u0432\u043e\u0433\u043e \u043e\u0431\u043e\u0440\u0443\u0434\u043e\u0432\u0430\u043d\u0438\u044f \u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0437\u043d\u043e\u0441\u0438\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u0435 \u043f\u043e \u0443\u0437\u043b\u0430\u043c \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u0448\u0430\u0440\u0434\u0438\u043d\u0433\u0430 (sharding) \u0441 \u043d\u0430\u0441\u0442\u0440\u043e\u0439\u043a\u043e\u0439 \u0440\u0430\u0437\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0438 \u0441\u0445\u0435\u043c\u044b \u0445\u0440\u0430\u043d\u0435\u043d\u0438\u044f. \u0414\u043b\u044f \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0439 \u043a\u043b\u0430\u0441\u0442\u0435\u0440 Citus \u0432\u044b\u0433\u043b\u044f\u0434\u0438\u0442 \u043a\u0430\u043a \u043e\u0434\u0438\u043d \u0431\u043e\u043b\u044c\u0448\u043e\u0439 [&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-121799","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Citus Data, \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0430\u0449\u0430\u044f Microsoft, \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0443\u044e \u0421\u0423\u0411\u0414 Citus 13.0, \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u0443\u044e \u0432 \u0444\u043e\u0440\u043c\u0435 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f \u043a PostgreSQL 17.\" \/>\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\/ro\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"ro_RO\" \/>\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\udd47\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0430\u044f \u0421\u0423\u0411\u0414 Citus 13.0 | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Citus Data, \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0430\u0449\u0430\u044f Microsoft, \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0443\u044e \u0421\u0423\u0411\u0414 Citus 13.0, \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u0443\u044e \u0432 \u0444\u043e\u0440\u043c\u0435 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f \u043a PostgreSQL 17.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/ro\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0\" \/>\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=\"2025-02-10T13:46:10+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-02-10T13:46:10+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\udd47 A fost publicat\u0103 baza de date distribuit\u0103 Citus 13.0 | ProHoster","description":"Compania Citus Data, de\u021binut\u0103 de Microsoft, a publicat baza de date distribuit\u0103 Citus 13.0, realizat\u0103 sub forma unei extensii pentru PostgreSQL 17.","canonical_url":"https:\/\/prohoster.info\/ro\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","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\u041e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043d\u0430 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0430\u044f \u0421\u0423\u0411\u0414 Citus 13.0 | ProHoster","og:description":"\u041a\u043e\u043c\u043f\u0430\u043d\u0438\u044f Citus Data, \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0430\u0449\u0430\u044f Microsoft, \u043e\u043f\u0443\u0431\u043b\u0438\u043a\u043e\u0432\u0430\u043b\u0430 \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u0443\u044e \u0421\u0423\u0411\u0414 Citus 13.0, \u0440\u0435\u0430\u043b\u0438\u0437\u043e\u0432\u0430\u043d\u043d\u0443\u044e \u0432 \u0444\u043e\u0440\u043c\u0435 \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u044f \u043a PostgreSQL 17.","og:url":"https:\/\/prohoster.info\/ro\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","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":"2025-02-10T13:46:10+00:00","article:modified_time":"2025-02-10T13:46:10+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"121799","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-02-22 15:49:11","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2026-01-23 10:29:19","updated":"2026-02-22 15:49:11","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\/121799","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/comments?post=121799"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/121799\/revisions"}],"predecessor-version":[{"id":162427,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/posts\/121799\/revisions\/162427"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/media?parent=121799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/categories?post=121799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/ro\/wp-json\/wp\/v2\/tags?post=121799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}