Learn about Citus on Microsoft Azure in our latest post about use cases: When to use Hyperscale (Citus) to scale out Postgres.
Focus On Your App—Not Your Database
Leverage the power of Postgres
Citus is a Postgres extension (not a fork), so you can stay current with new releases, use your familiar SQL toolset, & leverage all your Postgres expertise.
Never worry about scaling again
Citus makes it simple to add nodes and scale out compute, memory, and disk. So you no longer have to worry about how to scale and grow.
Query faster than any one server can
By parallelizing SQL across multiple nodes, Citus delivers insanely fast performance. Even with real-time data ingest & billions of rows of data.
See how Citus shards PostgreSQL across nodes
All the Features You Need in a Distributed Relational Database
-
Scale-Out Database
Citus enables you to shard the Postgres relational database across nodes, cpu, memory, & disk.
-
Extension to Postgres
Citus is not a fork. Rather, it’s an extension of PostgreSQL, staying current with the latest releases.
-
Database as a Service
In the cloud, Citus is built into Azure Database for PostgreSQL, a managed database as a service.
-
Distributed SQL Engine
Distributed query planner that parallelizes queries across shards, plus dynamic executor logic.
-
No Lock-In
Citus is open source, hence no
lock-in . Also available in the cloud & as enterprise software. -
Seamless Migration Tools
Data migration tools, fine-grained access controls, and PostgreSQL libraries for Rails & Django.
-
Insanely Fast Performance
Query faster than any one server can by scaling out Postgres & distributing SQL across nodes.
-
Multi-Tenant SaaS Support
Advanced features include shard rebalancing, tenant isolation, & cross-tenant query support.
-
High Availability
Citus works with WAL & Postgres streaming replication to ensure your Citus clusters are HA.
Ready to get started with Citus?
Why Scale Out Postgres? Performance.
Citus vs. Single-Node Postgres
A side-by-side comparison of Citus vs. single-node Postgres, comparing the performance of CREATE INDEX, data loading, analytical queries, and lookup queries.
Applications That Love Citus:
- MULTI-TENANT APPLICATIONS
Most SaaS Applications Are
Multi-Tenant SaaS apps often have a natural dimension on which to distribute data across nodes—dimensions such as tenant, customer, or account_id. Which means SaaS apps have a data model that is a good fit for a distributed database like Citus: just shard by tenant_id.
Features for Multi-Tenant Apps
- Built-in sharding & query parallelization
- Faster app performance via scaling out
- One-click slider to add Postgres nodes
- Shard rebalancing & tenant isolation
- REAL-TIME ANALYTICS
Real-Time Analytics Apps Need
Sub-Second LatencyReal-time analytics apps, particularly apps with customer-facing dashboards, require sub-second latency. By sharding and parallelizing your SQL queries across multiple nodes, Citus makes it possible to perform real-time queries across billions of records in under a second.
Features for Real-Time Analytics
- Ingest event & time-series data in real-time
- Sub-second queries on billions of events
- Low latency for customer-facing dashboards
- Pre-aggregation of distributed tables
Our Customers Love Using Citus to Scale Out Postgres
Dan Robinson, CTO at HeapThanks to Citus, we’re powering a product that is really kind of magical for a lot of customers. The speed and performance of our database make it possible for them to immediately perform truly advanced analytics on any user activities they want to explore.
Sylvain Friquet, Software Engineer, AlgoliaAt Algolia, our job is to provide the best search as a service, not to maintain clusters of PostgreSQL servers. We really wanted a database that scales, a database we wouldn’t have to worry about. Citus has given us that.
Vidur Apparao, CTO at AgariI like Citus’ combination of features, open source flexibility, and commercial-grade scalability. Best of all, because Citus is built on the latest version of PostgreSQL, we have been able to continue using the same core SQL toolset, leverage our existing PostgreSQL expertise, and take advantage of the continuing innovation within the PostgreSQL community.
Deepak Balasubramanyam, Technical Architect at FreshworksUsually for analytics applications, acceptable response times can be a matter of seconds. And this is especially true for long-term reporting that needs to query a huge amount of data. With Citus, it’s amazing. The response time on long-term queries of billions of rows is on the order of milliseconds.
Shashank Kumar, Founder at PushOwlWith Citus, we don’t have to worry about our infrastructure. That’s one of the main reasons I’m on Citus. We don’t have to think about DevOps anymore. We’re automatically and seamlessly scaling in the cloud, and we’re now managing more than 6,500 ecommerce stores.
Jonathan Denney, CTO and Co-Founder at ConvertFlowWe provisioned a new database using the Citus console, ran our migrations, copied over our data from Heroku, and we were up and running on Citus in just a few minutes. And the technical benefits were instant. We saw queries that were once taking
15-30+ seconds reduced to less than 500 ms.
Ready to get started with Citus?
Not a Fork
Yes, Citus really is Postgres. Not a fork, and not out of date. Citus is an extension to Postgres and stays in sync with the latest releases. So you can leverage your expertise in PostgreSQL and the Postgres ecosystem. And so you can take advantage of all the innovations in Postgres—including features like JSONB, PostGIS, HyperLogLog, and full text search.
Three Ways to Get Citus
Citus
Community
Open Source Download
Citus Community is our open source edition. If you need
Citus on
Azure
Hyperscale (Citus)
Hyperscale (Citus) is a
Citus
Enterprise
Enterprise Software
Citus Enterprise gives you the same awesome scale-out features as our open source edition, plus advanced features like shard rebalancing & tenant isolation.