Learn about Citus on Microsoft Azure in our latest post about use cases: When to use Hyperscale (Citus) to scale out Postgres.
Learn about Citus on Microsoft Azure in our latest post about use cases: When to use Hyperscale (Citus) to scale out Postgres.
Citus is now available as Hyperscale (Citus), a built-in deployment option for Azure Database for PostgreSQL. Now in GA on
Citus transforms Postgres into a distributed database. And the Citus extension to Postgres is open source. Find Citus on GitHub or download today.
Citus is an open source extension to Postgres that distributes your data and queries across multiple nodes, so your database can scale & your queries are fast.
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.
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.
By parallelizing SQL across multiple nodes, Citus delivers insanely fast performance. Even with real-time data ingest & billions of rows of data.
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.
In the cloud, Citus is built into Azure Database for PostgreSQL, a managed database as a service.
Distributed query planner that parallelizes queries across shards, plus dynamic executor logic.
Citus is open source, hence no
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.
Citus works with WAL & Postgres streaming replication to ensure your Citus clusters are HA.
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.
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.
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.
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 Community is our open source edition. If you need
Hyperscale (Citus) is a
Citus Enterprise gives you the same awesome scale-out features as our open source edition, plus advanced features like shard rebalancing & tenant isolation.