Citus 10.1 is out! 10.1 builds on top of all the great columnar, single-node, and shard rebalancer features in Citus 10. Read the new Citus 10.1 blog.
Scale out Postgres by distributing your data & queries across a cluster. And it’s simple to add nodes & rebalance shards when you need to grow.
Speed up queries by 20x to 300x (or more) through parallelism, keeping more data in memory, higher I/O bandwidth, and columnar compression.
Run Citus in the cloud with Hyperscale (Citus), a
Reduce your infrastructure headaches by using a single database for both your transactional and analytical workloads.
With Basic tier, you can be “scale-out-ready” by sharding Postgres on a single Hyperscale (Citus) node and using a distributed data model from the start—so you can easily add nodes later. Or use Basic tier as a handy way to try out Citus. (Preview)
With the new columnar table storage feature in Hyperscale (Citus), you can compress regular Postgres tables and/or distributed tables to reduce disk footprint, reduce I/O bandwidth needs, and speed up queries. (Preview)
Analysts & developers alike sometimes need to run complex queries without impacting the production database. Read-only replicas of a Hyperscale (Citus) server group are available in the same region. Forks/PITR also available. (Preview)
Outsource PgBouncer administration to Azure. Allow many clients to connect, while limiting the number of active connections and keeping the coordinator node running smoothly. (Preview)
Postgres 11, 12, and 13 database versions are all supported. Postgres major version upgrades available with minimal downtime. (Preview)
Be “scale-out-ready” by sharding Postgres on a single Hyperscale (Citus) node and using a distributed data model from the start—so you can easily add nodes later. Or use Basic tier as a handy way to try out Citus. (Preview)
Transparently shard Postgres tables across multiple nodes to give your application more memory, compute, and disk. Which gives you parallelism, high performance, and a way to scale. And with Basic tier in Preview, you can also shard Postgres on a single Hyperscale (Citus) node.
Easy to increase compute/memory and storage on your Hyperscale (Citus) coordinator & worker nodes.
It’s as simple as moving a slider to add nodes to your Hyperscale (Citus) cluster, whether starting with Basic tier or Standard tier in the Azure Database for PostgreSQL managed service.
When adding nodes to a Hyperscale (Citus) server group, the shard rebalancer enables you to redistribute shards across nodes to better balance the data distribution and the performance of your Citus database. Online, with zero downtime.
Read-only replicas of a Hyperscale (Citus) server group in the same region. Forks/PITR also available. (Preview)
HA uses standby replicas for all nodes in a cluster, with streaming replication & automated failover.
Automated backups are stored in multiple Azure availability zones.
Automated monitoring, configurable metrics dashboard, plus alert setup through Azure Monitor.
Encryption at rest & in flight, firewall rules, and 2FA.
Pay-as-you-go pricing, or prepay with reserved capacity discounts.
Watch a short demo on how to shard Postgres on a single node, so you can start small and seamlessly add nodes to your Hyperscale (Citus) cluster in the future. Umur also demos the new Citus 10 columnar feature, showing >5X compression.
If you don’t yet have an Azure subscription, this is the first step: create a free account before you begin.
Azure Database for PostgreSQL is a database as a service that you can use to run, manage, and scale PostgreSQL on Azure. This Quickstart will show you how to create a Hyperscale (Citus) server group (aka cluster) in Azure Database for PostgreSQL, using the Azure portal. Along the way, you will get to shard tables across nodes, ingest sample data, and run queries that execute on multiple nodes in a Hyperscale (Citus) server group.
After you’ve checked out the docs, the best next step is to provision a Hyperscale (Citus) server group. Then you get to figure out your distribution key, run the
create_distributed_table command, ingest your data, and start assessing how Hyperscale (Citus) performs for your workload.
Citus was a game changer for us. After migrating to Citus, we can onboard Vonto customers 20X faster, in 2 minutes vs. the 40+ minutes it used to take. And with the launch of Hyperscale (Citus) on Azure Database for PostgreSQL, we are excited to see what we can build next on Azure.Head of Integration of Business Ventures at ASB Bank & Chief Product Officer at Vonto