Howdy Logo
Glossary Hero image

The Howdy Glossary

Search terms in Glossary


Citus is an extension for Postgres databases that distributes and scales out data horizontally, providing capabilities typically associated with NoSQL databases while maintaining compatibility with SQL syntax and Postgres features. It uses sharding to distribute data across a cluster of nodes, enabling increased performance for large analytical workloads or high-throughput transactional applications. With Citus, complex queries can be executed in parallel across multiple shards, leading to faster response times compared to single-node databases. Additionally, the technology provides automated shard rebalancing and failure recovery mechanisms. This database technology is useful for managing growing datasets in real-time applications on cloud environments or on-premises infrastructure without redesigning the application's architecture from scratch.