Citus Enterprise

Worry-free Postgres from Citus distributes your database across multiple nodes so your app can scale out and your queries are fast. Also available as open source & as a fully-managed cloud database, Citus Enterprise is on-prem software that comes with 24x7 support plus additional enterprise features.

BOOK A DEMO

Modernize Your Database Infrastructure with Citus

Postgres icon

Power of Worry-Free
Postgres

We get that you trust Postgres. So we built Citus as a Postgres extension to stay current with the latest releases. And we built Citus to scale out. With Citus, you get to leverage all your Postgres expertise, use your familiar SQL toolset, and scale out your database.

Citus Data swirl icon

Never Worry About
Scaling Again

You shouldn’t have to re-architect your app to scale out your database. You shouldn’t have to stitch together multiple different database technologies. And you shouldn’t have to give up Postgres, either. Our worry-free Postgres is built to scale out. So you can focus on your app and not your database.

Query faster icon

Query Faster Than Any
One Server Can

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. And adding nodes to increase parallelism is as easy as dragging a slider.

All the Features You Need in an Enterprise Database That Scales Out Postgres

Postgres is a Favorite Among Databases for Good Reason

All the Goodness of Postgres

Because we’ve implemented Citus as an extension to Postgres, you get trusted and familiar Postgres with Citus, complete with all the data types, operators and functions, extensions, and indexes in Postgres. Plus the reliability of Postgres and all of the ongoing innovation in the Postgres community. Also, JSONB.

Postgres Tooling & Ecosystem

The Postgres ecosystem of tools, extensions, and libraries is vast. One of the reasons Citus is popular is because Citus is an extension to Postgres: therefore you get to leverage your Postgres expertise and use all of your familiar Postgres tools.

Relational Database Semantics

Citus is an extension to Postgres, which means we offer relational database features like ACID transactions, joins, foreign key constraints, and SQL.

Streaming Replication

The streaming replication feature in Postgres can be used to setup High Availability secondary nodes and failover capabilities for Citus.

Who Says You Can’t Scale Out A Relational Database?

Packaged as a Postgres Extension

Because Citus is an extension to Postgres and not a fork, Citus can easily stay current with the latest releases of Postgres, allowing you to benefit from all of the latest innovations in Postgres.

Horizontal Scale via Sharding

Citus shards your Postgres database across multiple nodes to give your application more memory, compute, and disk storage. Which gives you massive parallelism, high performance, and a way to keep scaling as your application grows.

Shard Rebalancer

When adding nodes to a Citus cluster, the zero-downtime shard rebalancer enables you to redistribute shards across old and new worker nodes to better balance the data distribution and the performance of your Citus database.

Tenant Isolation

Multi-tenant SaaS applications sometimes need to isolate the shards for a large customer to ensure that the large customer gets the resources they need and doesn’t negatively impact performance for everyone else. Hence: tenant isolation.

Distributing SQL Queries & Transactions for Speed and Scale

Distributed Query Engine

Citus takes an incoming SQL query, plans the query for parallel execution, and pushes down the parallel computations to the nodes in the database cluster. As you add new nodes, Citus automatically distributes queries to leverage all the memory and cpu cores available.

Dynamic Query Executors

Multi-tenant and analytic workloads introduce different trade-offs in a distributed database. Citus comes built-in with three dynamic executors, each optimized for a different workload, and Citus intelligently determines which executor to use, based on the query.

Distributed Transactions

Citus provides full SQL transactions across shards and nodes, making it easier than ever to migrate applications onto Citus.

Cross-Tenant Query Support

Because Citus can parallelize query fragments across multiple nodes cluster, you can run powerful cross-shard queries across all of your customer data quickly and easily.

Massive Parallelism

As a distributed database that can scale out Postgres to hundreds of nodes, Citus gives you unparalleled parallelism and performance across billions of records. By allowing you to perform scale-out analytics across your entire data set, you can provide new value to your customers where not possible before.

Monitoring & Management Features in Citus

Logging

To analyze and retain your Postgres and Citus logs over time, logs can be transmitted to log management apps such as Splunk, Loggly, Papertrail, Sumo Logic, and Logentries.

Monitoring Metrics

Citus utilities can be used to query Citus table and relation sizes. The popular pg_stat_statements gives visibility into statistics about queries that are running on the database. And many customers integrate their favorite monitoring tools with Postgres and Citus.

Distributed Explain

The Postgres EXPLAIN feature creates a query plan for each query it receives and is invaluable in optimizing performance. In Citus, we’ve created a distributed EXPLAIN feature that performs the same function in the context of a distributed database.

Fine-Grained Access Controls

Granular access controls in Citus enable you to limit capabilities to certain types of users to control user access and reduce risk.

Enterprise SLA & 24x7 Support

Includes 24x7 on-call support, as well as the professional services to get you up and running. We help model your data and tune your systems so they’re ready for production workloads. Citus Enterprise also includes an SLA to ensure you have the support you need.

Rich Data Types & Extensions

JSONB

PostgreSQL and Citus support 40+ data types, including semi-structured data types and JSONB. Many developers celebrate the JSONB support in Postgres database as a way to store blobs in the database in a way that enables document store workflows.

HyperLogLog (HLL)

HLL is an algorithm for the count-distinct problem and can approximate the number of distinct elements in a set. With sketch algorithms for probabilistic distincts such as HLL, you can provide deeper analytics in real-time across petabytes of data.

PostGIS

PostGIS is an extension to Postgres that adds support for geographical objects to Postgres, allowing location queries to be run in SQL. Open source, freely available, and works with Citus.

TopN

TopN is a new Postgres extension that is currently in beta. Created by Citus Data, TopN can be used to calculate the most frequently occurring values in a column, and is part of the class of probabilistic distinct algorithms called sketch algorithms.

Full Text Search

Full text search in Postgres enables you to search documents, parts of documents, and semi-structured data using regular expressions and text search from within your Citus database.

Behavioral Analytics

Citus enables interactive funnel, cohort, and session analytics on real-time event data at scale. It can serve instant responses to concurrent queries with on-the-fly segmentation and funnel step definitions.

Run Anywhere with Citus: On-Prem, in the Cloud, and Open Source

Open Source

We’re on a mission to make it so you never have to worry about scaling your database again. And by database, we mean Postgres. Download the Citus extension to Postgres and get started scaling out today.

On-Premises

The Citus Enterprise software comes is the same as our open source offering with the addition of a few enterprise features and 24x7 Citus Support. The ideal cloud-ready database to scale out Postgres in an on-prem environment.

In the Cloud

Convenience trumps all, and our customers tell us they would rather focus on their application and not their database. So we make Citus available as a fully-managed database as a service. We carry the pager so you don’t have to.

I 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.

Vidur Apparao, CTO at Agari

Are You Ready to Get Started with Citus?

Want to test drive our open source community edition? Download today.

developer's desk