Citus guides and best practices

These articles provide in-depth guidance on specific Citus features and use cases.

In this section

Article Description
Efficient Rollup Tables with HyperLogLog Use HyperLogLog for efficient rollup tables and approximate distinct counts
HyperLogLog for Count Distinct Implement approximate distinct counting with HyperLogLog
Parallel Indexing Create indexes in parallel across distributed tables
Aggregation Optimize aggregate queries on distributed data
Outer Joins Handle outer joins in distributed queries
Designing Multi-Tenant SaaS Applications Best practices for multitenant database design
Metrics Dashboard Build real-time analytics dashboards
Sharding a multitenant app Step-by-step guide to sharding multitenant applications
Semi-Structured Data Work with JSONB and semi-structured data
Faceted Search Implement faceted search patterns