Citus intelligently distributes your data & queries across nodes so your database can scale and your queries are fast. Available as a database as a service, as enterprise software, and as open source. At Citus, we make sharding your PostgreSQL database simple. So you can focus on your app—not your database.
We get that you trust Postgres. So we’ve built Citus as a Postgres extension (not a fork) to stay current with the latest releases. With Citus, you get to use your familiar SQL toolset and leverage all your Postgres expertise.
Adding nodes to your Citus database is as easy as moving a slider. We make sharding simple. Plus Citus is open source and platform independent: you can run Citus anywhere. Hence the moniker:
By parallelizing SQL queries across multiple nodes, Citus delivers unparalleled performance. Even with real-time data ingest and sub-second queries across billions of rows of data. Happy dashboarding.
Our team has decades of experience managing millions of Postgres databases in the cloud. With our
Citus enables you to shard the Postgres relational database across nodes, cpu, memory, & disk.
Citus is not a fork. Rather, it’s an extension of PostgreSQL, staying current with the latest releases.
Fully-managed cloud database. Continuous monitoring, automated backups & DR, security, & encryption.
Distributed query planner that parallelizes queries across shards, plus dynamic executor logic.
Runs anywhere. Available as a cloud database service, as
Data migration tools, fine-grained access controls, and PostgreSQL libraries for Rails & Django.
Query faster than any one server can by scaling out Postgres & distributing SQL across nodes.
Advanced features include shard rebalancing, tenant isolation, & cross-tenant query support.
In Citus Cloud we use the WAL to create HA standby nodes & we use WAL-E for continuous DR archives.
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.
Real-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.
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.
Wesley Chow, CTO at ChartbeatAt Chartbeat, interactivity on our dashboards is very important. Every second a user has to wait, even if that request is crunching a lot of data, represents a potential disruption to our client’s workflow. In the past, it might have taken dozens of seconds or even minutes to materialize queries. With Citus, we can deliver
sub-second latency.
Kelly Cheng, CTO and Co-Founder at Copper (formerly ProsperWorks)By adopting Citus Cloud to scale out Postgres, we didn’t have to slow down feature development to shard at the application level. For us, Citus was the fastest and best way to protect our engineering throughput while still scaling the database.
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.
Dan Robinson, CTO at HeapBeing on a fully relational data model with the full indexing and querying power of Postgres was extremely valuable when it came to adding new analytics capabilities. Yet Citus also enabled us to maintain very fast response times, even with extremely complex queries.
Jonathan Denney, CTO and Co-Founder at ConvertFlowWe provisioned a new database using the Citus Cloud 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.
Watch the Side-by-Side Comparison
In this short video about Citus, we shine a light on the performance benefits you get by scaling out Postgres horizontally. Enjoy the bleeps.
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.
Citus Cloud is our fully-managed database as a service, backed with our expertise monitoring and managing millions of Postgres databases. We carry the pager, so you don’t have to.
Citus Community is our open source edition. If you need
Citus Enterprise gives you the same awesome scale-out features as our open source edition, plus advanced features like shard rebalancing & tenant isolation.