{"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\/en\/blog\/news\/opublikovana-raspredelyonnaya-subd-citus-13-0","title":{"rendered":"Distributed DBMS Citus 13.0 has been released","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Citus Data, a subsidiary of Microsoft, has released the distributed database Citus 13.0, implemented as an extension to PostgreSQL 17. Citus enables horizontal scaling of PostgreSQL in a cluster based on standard hardware, allowing data to be spread across nodes using sharding with configuration for column-level partitioning and storage schemes. For applications, the Citus cluster appears as a single large PostgreSQL server, aggregating the resources of its constituent nodes. The code is written in C and is distributed under the AGPLv3 license. <\/p>\n
Sharding allows for the organization of very large volumes of data, the total size of which significantly exceeds the local storage of each node in the cluster. Individual tables can be forcibly replicated across all nodes to speed up merge operations and work with foreign keys. To save disk space, data distributed across different nodes can be stored in a compressed format. <\/p>\n
Distributed queries can be sent to any node in the cluster, but management and modification of the data schema must be done only through the node coordinating the cluster's operation. Incoming client queries are distributed to the necessary nodes and, if they span multiple nodes, their processing is parallelized. The cluster can be expanded as the size of the stored data grows by adding additional nodes and initiating rebalancing. <\/p>\n