{"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\/cs\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","title":{"rendered":"Byla vyd\u00e1na distribuovan\u00e1 DBMS Citus 13.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Spole\u010dnost Citus Data, pat\u0159\u00edc\u00ed Microsoftu, publikovala distribuovanou DBMS Citus 13.0, implementovanou jako roz\u0161\u00ed\u0159en\u00ed pro PostgreSQL 17. Citus umo\u017e\u0148uje horizont\u00e1ln\u00ed \u0161k\u00e1lov\u00e1n\u00ed PostgreSQL v clusterech na b\u00e1zi standardn\u00edho hardwaru a umo\u017e\u0148uje rozlo\u017een\u00ed dat mezi uzly pomoc\u00ed shardingu s nastaven\u00edm d\u011blen\u00ed na \u00farovni sloupc\u016f a sch\u00e9matu ukl\u00e1d\u00e1n\u00ed. Pro aplikace vypad\u00e1 cluster Citus jako jeden velk\u00fd server PostgreSQL, kter\u00fd spojuje zdroje jeho uzl\u016f. K\u00f3d je naps\u00e1n v jazyce C a je distribuov\u00e1n pod licenc\u00ed AGPLv3.      <\/p>\n<p>Sharding umo\u017e\u0148uje organizovat ukl\u00e1d\u00e1n\u00ed velmi velk\u00e9ho objemu dat, jeho\u017e celkov\u00e1 velikost v\u00fdrazn\u011b p\u0159esahuje m\u00edstn\u00ed \u00falo\u017ei\u0161t\u011b ka\u017ed\u00e9ho uzlu clustera. Kontrolovan\u00e9 tabulky mohou b\u00fdt nucen\u011b replikov\u00e1ny na v\u0161echny uzly pro urychlen\u00ed prov\u00e1d\u011bn\u00ed operac\u00ed slou\u010den\u00ed a pr\u00e1ce s ciz\u00edmi kl\u00ed\u010di. Pro \u00fasporu diskov\u00e9ho prostoru mohou b\u00fdt data rozlo\u017een\u00e1 na r\u016fzn\u00fdch uzlech ukl\u00e1d\u00e1na ve zkomprimovan\u00e9 podob\u011b.       <\/p>\n<p>Distribuovan\u00e9 dotazy mohou b\u00fdt odes\u00edl\u00e1ny na libovoln\u00fd z uzl\u016f clustera, ale spr\u00e1va a zm\u011bna datov\u00e9ho sch\u00e9matu mus\u00ed prob\u00edhat pouze prost\u0159ednictv\u00edm uzlu, kter\u00fd koordinuje pr\u00e1ci clustera. P\u0159\u00edchoz\u00ed po\u017eadavky od klient\u016f jsou distribuov\u00e1ny po pot\u0159ebn\u00fdch uzlech a pokud pokr\u00fdvaj\u00ed n\u011bkolik uzl\u016f, jejich zpracov\u00e1n\u00ed je paralelizov\u00e1no. Cluster lze roz\u0161i\u0159ovat, jakmile roste objem ukl\u00e1dan\u00fdch dat, p\u0159id\u00e1v\u00e1n\u00edm dal\u0161\u00edch uzl\u016f a iniciov\u00e1n\u00edm rebalance.     <\/p>\n<p>Mezi typick\u00e9 p\u0159\u00edklady pou\u017eit\u00ed Citus pat\u0159\u00ed prov\u00e1d\u011bn\u00ed analytick\u00fdch dotaz\u016f a zpracov\u00e1n\u00ed velk\u00fdch objem\u016f dat ve form\u011b \u010dasov\u00e9ho p\u00e1sma (nap\u0159\u00edklad logy nebo dotazy na stav sn\u00edma\u010d\u016f). Citus je tak\u00e9 vhodn\u00fd pro modernizaci st\u00e1vaj\u00edc\u00ed infrastruktury zalo\u017een\u00e9 na jednom <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/cs\/server\/dts-los-angeles\/\"   title=\"serveru\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3899\">serveru<\/a> PostgreSQL, jeho\u017e v\u00fdkon a \u00falo\u017ei\u0161t\u011b p\u0159estaly sta\u010dit kv\u016fli rostouc\u00ed z\u00e1t\u011b\u017ei nebo objemu p\u0159ich\u00e1zej\u00edc\u00edch dat. S pomoc\u00ed n\u00e1stroje Patroni lze vytv\u00e1\u0159et odoln\u00e9 konfigurace s replikovan\u00fdmi n\u00e1hradn\u00edmi uzly, schopn\u00fdmi v p\u0159\u00edpad\u011b selh\u00e1n\u00ed zaujmout m\u00edsto hlavn\u00edch uzl\u016f.      <\/p>\n<p>Zm\u011bny ve verzi Citus 13.0:  <\/p>\n<ul>\n<li class=\"l\"> P\u0159echod na pou\u017eit\u00ed verze PostgreSQL 17.\n<li class=\"l\"> Mo\u017enost pou\u017eit\u00ed funkce JSON_TABLE() v distribuovan\u00fdch dotazech pro p\u0159evod dat z form\u00e1tu JSON do rela\u010dn\u00edho zobrazen\u00ed, se kter\u00fdm lze pracovat jako s b\u011b\u017en\u00fdmi tabulkami PostgreSQL.\n<li class=\"l\"> Podpora syntaxy \u201eMERGE \u2026 WHEN NOT MATCHED BY SOURCE\u201c.\n<li class=\"l\">  Mo\u017enost definovat p\u0159\u00edstupovou metodu pro rozd\u011blen\u00e9 partitionovan\u00e9 tabulky pomoc\u00ed v\u00fdrazu \u201eCREATE TABLE \u2026 USING\u201c, stejn\u011b jako zm\u011bnit p\u0159\u00edstupovou metodu prost\u0159ednictv\u00edm \u201eALTER TABLE \u2026 SET ACCESS METHOD\u201c.\n<li class=\"l\"> Byla p\u0159id\u00e1na podpora pro ur\u010den\u00ed automaticky generovan\u00fdch identifika\u010dn\u00edch sloupc\u016f v distribuovan\u00fdch d\u011blen\u00fdch tabulk\u00e1ch.\n<li class=\"l\"> Povoleno pou\u017eit\u00ed v\u00fdjime\u010dn\u00fdch omezen\u00ed v distribuovan\u00fdch d\u011blen\u00fdch tabulk\u00e1ch.\n<li class=\"l\"> Vy\u0159e\u0161eny probl\u00e9my se synchronizac\u00ed rol\u00ed mezi uzly.\n<li class=\"l\"> Zlep\u0161eno rozlo\u017een\u00ed dat pro shardov\u00e1n\u00ed p\u0159i p\u0159id\u00e1n\u00ed nov\u00fdch uzl\u016f do clusteru.\n<li class=\"l\"> Do p\u0159\u00edkazu \u201eEXPLAIN\u201c byly p\u0159id\u00e1ny mo\u017enosti \u201eMEMORY\u201c a \u201eSERIALIZE\u201c, pomoc\u00ed kter\u00fdch lze ur\u010dit velikost vyu\u017eit\u00e9 pam\u011bti a \u010das str\u00e1ven\u00fd p\u0159evodem dat pro p\u0159enos po s\u00edti.       <\/ul>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=62701\">opennet.ru<\/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.3 - 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\/cs\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\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\/cs\/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\udd47Zve\u0159ejn\u011bna distribuovan\u00e1 DBMS Citus 13.0 | ProHoster","description":"Spole\u010dnost Citus Data, pat\u0159\u00edc\u00ed Microsoftu, zve\u0159ejnila distribuovanou DBMS Citus 13.0, realizovanou jako roz\u0161\u00ed\u0159en\u00ed k PostgreSQL 17.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/121799","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=121799"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/121799\/revisions"}],"predecessor-version":[{"id":162427,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/121799\/revisions\/162427"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=121799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=121799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=121799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}