{"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\/pl\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","title":{"rendered":"Opublikowano rozproszon\u0105 baz\u0119 danych Citus 13.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Firma Citus Data, b\u0119d\u0105ca cz\u0119\u015bci\u0105 Microsoft, opublikowa\u0142a rozproszon\u0105 baz\u0119 danych Citus 13.0, wdro\u017con\u0105 jako rozszerzenie dla PostgreSQL 17. Citus zapewnia poziome skalowanie PostgreSQL w klastrze na standardowym sprz\u0119cie i umo\u017cliwia rozmieszczanie danych na w\u0119z\u0142ach przy u\u017cyciu shardingu, z konfiguracj\u0105 podzia\u0142u na poziomie kolumn i schemat\u00f3w przechowywania. Dla aplikacji klaster Citus wygl\u0105da jak jeden du\u017cy serwer PostgreSQL, \u0142\u0105cz\u0105cy zasoby jego w\u0119z\u0142\u00f3w. Kod napisany jest w j\u0119zyku C i udost\u0119pniany na licencji AGPLv3.      <\/p>\n<p>Sharding umo\u017cliwia organizacj\u0119 przechowywania bardzo du\u017cej ilo\u015bci danych, ca\u0142kowity rozmiar kt\u00f3rych znacznie przekracza lokalne no\u015bniki ka\u017cdego z w\u0119z\u0142\u00f3w klastra. Poszczeg\u00f3lne tabele mog\u0105 by\u0107 wymuszone do replikacji na wszystkich w\u0119z\u0142ach w celu przyspieszenia operacji \u0142\u0105czenia i pracy z kluczami obcymi. Aby zaoszcz\u0119dzi\u0107 miejsce na dysku, dane rozproszone na r\u00f3\u017cnych w\u0119z\u0142ach mog\u0105 by\u0107 przechowywane w formie skompresowanej.       <\/p>\n<p>Rozproszone zapytania mog\u0105 by\u0107 wysy\u0142ane do dowolnego z w\u0119z\u0142\u00f3w klastra, ale zarz\u0105dzanie i modyfikacja schematu danych musz\u0105 by\u0107 przeprowadzane tylko przez w\u0119ze\u0142 koordynuj\u0105cy prac\u0119 klastra. Przychodz\u0105ce zapytania od klient\u00f3w s\u0105 rozdzielane mi\u0119dzy odpowiednie w\u0119z\u0142y i, je\u015bli obejmuj\u0105 kilka w\u0119z\u0142\u00f3w, ich przetwarzanie jest r\u00f3wnoleg\u0142e. Klaster mo\u017cna rozbudowywa\u0107 w miar\u0119 wzrostu rozmiaru przechowywanych danych, dodaj\u0105c dodatkowe w\u0119z\u0142y i inicjuj\u0105c rebalance.     <\/p>\n<p>Typowe przyk\u0142ady zastosowania Citus obejmuj\u0105 wykonywanie zapyta\u0144 analitycznych oraz przetwarzanie du\u017cych zbior\u00f3w danych w formie szereg\u00f3w czasowych (na przyk\u0142ad logi lub ankiety stanu czujnik\u00f3w). Citus nadaje si\u0119 r\u00f3wnie\u017c do modernizacji istniej\u0105cej infrastruktury opartej na jednostkowym <a class=\"wpil_keyword_link\" href=\"https:\/\/prohoster.info\/server\/dts-los-angeles\/\"   title=\"serwera\" data-wpil-keyword-link=\"linked\"  data-wpil-monitor-id=\"3899\">serwera<\/a> PostgreSQL, kt\u00f3rego wydajno\u015bci i no\u015bnik\u00f3w przesta\u0142o wystarcza\u0107 z powodu zwi\u0119kszonego obci\u0105\u017cenia lub ilo\u015bci przychodz\u0105cych danych. Za pomoc\u0105 narz\u0119dzi Patroni mo\u017cna tworzy\u0107 konfiguracje odporne na awarie z replikowanymi zapasowymi w\u0119z\u0142ami, kt\u00f3re w przypadku awarii mog\u0105 zaj\u0105\u0107 miejsce g\u0142\u00f3wnych w\u0119z\u0142\u00f3w.      <\/p>\n<p>Zmiany w wersji Citus 13.0:  <\/p>\n<ul>\n<li class=\"l\"> Przej\u015bcie na u\u017cycie ga\u0142\u0119zi PostgreSQL 17.\n<li class=\"l\"> Mo\u017cliwo\u015b\u0107 korzystania z funkcji JSON_TABLE() w zapytaniach rozproszonych do przekszta\u0142cania danych z formatu JSON do relacyjnej postaci, z kt\u00f3r\u0105 mo\u017cna pracowa\u0107 jak z zwyk\u0142ymi tabelami PostgreSQL.\n<li class=\"l\"> \u041f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0430 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0430 &#171;MERGE &#8230; WHEN NOT MATCHED BY SOURCE&#187;.\n<li class=\"l\">  \u0412\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u043c\u0435\u0442\u043e\u0434\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0434\u043b\u044f \u0440\u0430\u0441\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0445 \u0441\u0435\u043a\u0446\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f &#171;CREATE TABLE &#8230; USING&#187;, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f \u043c\u0435\u0442\u043e\u0434\u0430 \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u0447\u0435\u0440\u0435\u0437 &#171;ALTER TABLE &#8230; SET ACCESS METHOD&#187;.\n<li class=\"l\"> Dodano wsparcie dla okre\u015blania automatycznie generowanych kolumn identyfikacyjnych w rozproszonych tabelach sekcjonowanych.\n<li class=\"l\"> Zezwalaj\u0105 na stosowanie ogranicze\u0144 wyklucze\u0144 w rozproszonych tabelach sekcjonowanych.\n<li class=\"l\"> Rozwi\u0105zano problemy z synchronizacj\u0105 r\u00f3l mi\u0119dzy w\u0119z\u0142ami.\n<li class=\"l\"> Udoskonalono rozdzielanie danych dla shardingu przy dodawaniu nowych w\u0119z\u0142\u00f3w do klastra.\n<li class=\"l\"> \u0412 \u043a\u043e\u043c\u0430\u043d\u0434\u0443 &#171;EXPLAIN&#187; \u0434\u043e\u0431\u0430\u0432\u043b\u0435\u043d\u044b \u043e\u043f\u0446\u0438\u0438 &#171;MEMORY&#187; \u0438 &#171;SERIALIZE&#187;, \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043c\u043e\u0436\u043d\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0438\u0442\u044c \u0440\u0430\u0437\u043c\u0435\u0440 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u043d\u043e\u0439 \u043f\u0430\u043c\u044f\u0442\u0438 \u0438 \u0432\u0440\u0435\u043c\u044f, \u043f\u043e\u0442\u0440\u0430\u0447\u0435\u043d\u043d\u043e\u0435 \u043d\u0430 \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u0434\u0430\u0447\u0438 \u043f\u043e \u0441\u0435\u0442\u0438.       <\/ul>\n<p>\u0179r\u00f3d\u0142o: <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.1.1 - 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\/pl\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.1.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"pl_PL\" \/>\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\/pl\/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\udd47Opublikowana rozproszona baza danych Citus 13.0 | ProHoster","description":"Firma Citus Data, nale\u017c\u0105ca do Microsoftu, opublikowa\u0142a rozproszon\u0105 baz\u0119 danych Citus 13.0, wdro\u017con\u0105 w formie rozszerzenia dla PostgreSQL 17.","canonical_url":"https:\/\/prohoster.info\/pl\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pl_PL","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\/pl\/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\/pl\/wp-json\/wp\/v2\/posts\/121799","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/comments?post=121799"}],"version-history":[{"count":1,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts\/121799\/revisions"}],"predecessor-version":[{"id":162427,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/posts\/121799\/revisions\/162427"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/media?parent=121799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/categories?post=121799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pl\/wp-json\/wp\/v2\/tags?post=121799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}