1 min read
Time-Series Data at Scale with Citus and TimescaleDB
This architecture handles billions of time-series data points while maintaining query performance for both real-time and historical analysis.
Citus
7 articles
1 min read
Building Real-Time Dashboards with Citus
Combining Citus's distributed query power with rollup tables and caching enables dashboards that handle millions of events per second.
1 min read
Data Colocation in Citus for Optimal Join Performance
When two distributed tables share the same distribution column and colocation group, their corresponding shards are placed on the same worker node.
1 min read
Mastering Distributed Queries in Citus
Understanding these query patterns helps you leverage Citus effectively for high-performance distributed PostgreSQL applications.
1 min read
Using Reference Tables in Citus for Efficient Joins
Reference tables eliminate network round-trips for joins, significantly improving query performance in distributed setups.
1 min read
Understanding Hyperscale Citus Architecture
Understanding this architecture helps you make informed decisions about data modeling and query optimization in your distributed PostgreSQL deployments.
1 min read
PostgreSQL Hyperscale (Citus) on Azure: Distributed Database Patterns
Hyperscale uses the Citus extension to create a distributed database: Coordinator : Routes queries, stores metadata Workers : Store data shards, execute…